fork download
  1. SELECT DFRI.REGION_ID,
  2. DFRI.RECEIVE_DATE RECEIVED_ON_DAY,
  3. DFRI.WAREHOUSE_ID,
  4. --INBOUND_SLA_METRICS_ID,
  5. OISD.INBOUND_SHIP_APPOINTMENT_ID,
  6. DFRI.INBOUND_SHIPMENT_DELIVERY_ID,
  7. DFAD.STANDARD_CARRIER_ALPHA_CODE,
  8. DO.DISTRIBUTOR_ID VENDOR_CODE,
  9. DFRI.DISTRIBUTOR_ORDER_ID ORDER_ID,
  10. DFRI.ISBN ASIN,
  11. --DDOI.GL_PRODUCT_GROUP,
  12. --RECEIVE_PROCESS_PATH,
  13. --INBOUND_WORK_FLOW,
  14. DFRI.ISBN ASIN,
  15. DFRI.QUANTITY RECEIVED_QTY,
  16. --STOWED_QTY,
  17. DFRI.RECEIVE_DATE RECEIVED_DATE_LOCAL
  18. --DO.FREIGHT_TERMS
  19. --DISTRIBUTOR_SHIPMENT_ID,
  20. --MARKETPLACE_ID
  21. FROM LP_METRICS_DDL.D_FC_RECEIVED_ITEMS DFRI
  22. LEFT OUTER JOIN O_INBOUND_SHIPMENT_DELIVERIES OISD
  23. ON DFRI.INBOUND_SHIPMENT_DELIVERY_ID = OISD.INBOUND_SHIPMENT_DELIVERY_ID
  24. INNER JOIN D_FC_APPOINTMENT_DETAILS DFAD
  25. ON OISD.INBOUND_SHIP_APPOINTMENT_ID = DFAD.INBOUND_SHIP_APPOINTMENT_ID
  26. LEFT OUTER JOIN (
  27. SELECT DISTINCT ORDER_ID,
  28. DISTRIBUTOR_ID,
  29. NVL(TRIM(FREIGHT_PAYMENT_TERMS_CODE), 'UNKNOWN') AS FREIGHT_TERMS,
  30. INVENTORY_OWNER_GROUP_ID
  31. FROM D_DISTRIBUTOR_ORDERS
  32. WHERE REGION_ID = 1
  33. ) DO;-- your code goes here
Runtime error #stdin #stdout #stderr 0s 3396KB
stdin
Standard input is empty
stdout
Standard output is empty
stderr
Error: near line 1: no such table: LP_METRICS_DDL.D_FC_RECEIVED_ITEMS