SELECT DFRI.REGION_ID,
	DFRI.RECEIVE_DATE RECEIVED_ON_DAY,
	DFRI.WAREHOUSE_ID,
	--INBOUND_SLA_METRICS_ID,
	OISD.INBOUND_SHIP_APPOINTMENT_ID,
	DFRI.INBOUND_SHIPMENT_DELIVERY_ID,
	DFAD.STANDARD_CARRIER_ALPHA_CODE,
	DO.DISTRIBUTOR_ID VENDOR_CODE,
	DFRI.DISTRIBUTOR_ORDER_ID ORDER_ID,
	DFRI.ISBN ASIN,
	--DDOI.GL_PRODUCT_GROUP,
	--RECEIVE_PROCESS_PATH,
	--INBOUND_WORK_FLOW,
	DFRI.ISBN ASIN,
	DFRI.QUANTITY RECEIVED_QTY,
	--STOWED_QTY,
	DFRI.RECEIVE_DATE RECEIVED_DATE_LOCAL
	--DO.FREIGHT_TERMS
--DISTRIBUTOR_SHIPMENT_ID,
--MARKETPLACE_ID
FROM LP_METRICS_DDL.D_FC_RECEIVED_ITEMS DFRI
LEFT OUTER JOIN O_INBOUND_SHIPMENT_DELIVERIES OISD
	ON DFRI.INBOUND_SHIPMENT_DELIVERY_ID = OISD.INBOUND_SHIPMENT_DELIVERY_ID
INNER JOIN D_FC_APPOINTMENT_DETAILS DFAD
	ON OISD.INBOUND_SHIP_APPOINTMENT_ID = DFAD.INBOUND_SHIP_APPOINTMENT_ID
LEFT OUTER JOIN (
	SELECT DISTINCT ORDER_ID,
		DISTRIBUTOR_ID,
		NVL(TRIM(FREIGHT_PAYMENT_TERMS_CODE), 'UNKNOWN') AS FREIGHT_TERMS,
		INVENTORY_OWNER_GROUP_ID
	FROM D_DISTRIBUTOR_ORDERS
	WHERE REGION_ID = 1
	) DO;-- your code goes here

U0VMRUNUIERGUkkuUkVHSU9OX0lELAoJREZSSS5SRUNFSVZFX0RBVEUgUkVDRUlWRURfT05fREFZLAoJREZSSS5XQVJFSE9VU0VfSUQsCgktLUlOQk9VTkRfU0xBX01FVFJJQ1NfSUQsCglPSVNELklOQk9VTkRfU0hJUF9BUFBPSU5UTUVOVF9JRCwKCURGUkkuSU5CT1VORF9TSElQTUVOVF9ERUxJVkVSWV9JRCwKCURGQUQuU1RBTkRBUkRfQ0FSUklFUl9BTFBIQV9DT0RFLAoJRE8uRElTVFJJQlVUT1JfSUQgVkVORE9SX0NPREUsCglERlJJLkRJU1RSSUJVVE9SX09SREVSX0lEIE9SREVSX0lELAoJREZSSS5JU0JOIEFTSU4sCgktLURET0kuR0xfUFJPRFVDVF9HUk9VUCwKCS0tUkVDRUlWRV9QUk9DRVNTX1BBVEgsCgktLUlOQk9VTkRfV09SS19GTE9XLAoJREZSSS5JU0JOIEFTSU4sCglERlJJLlFVQU5USVRZIFJFQ0VJVkVEX1FUWSwKCS0tU1RPV0VEX1FUWSwKCURGUkkuUkVDRUlWRV9EQVRFIFJFQ0VJVkVEX0RBVEVfTE9DQUwKCS0tRE8uRlJFSUdIVF9URVJNUwotLURJU1RSSUJVVE9SX1NISVBNRU5UX0lELAotLU1BUktFVFBMQUNFX0lECkZST00gTFBfTUVUUklDU19EREwuRF9GQ19SRUNFSVZFRF9JVEVNUyBERlJJCkxFRlQgT1VURVIgSk9JTiBPX0lOQk9VTkRfU0hJUE1FTlRfREVMSVZFUklFUyBPSVNECglPTiBERlJJLklOQk9VTkRfU0hJUE1FTlRfREVMSVZFUllfSUQgPSBPSVNELklOQk9VTkRfU0hJUE1FTlRfREVMSVZFUllfSUQKSU5ORVIgSk9JTiBEX0ZDX0FQUE9JTlRNRU5UX0RFVEFJTFMgREZBRAoJT04gT0lTRC5JTkJPVU5EX1NISVBfQVBQT0lOVE1FTlRfSUQgPSBERkFELklOQk9VTkRfU0hJUF9BUFBPSU5UTUVOVF9JRApMRUZUIE9VVEVSIEpPSU4gKAoJU0VMRUNUIERJU1RJTkNUIE9SREVSX0lELAoJCURJU1RSSUJVVE9SX0lELAoJCU5WTChUUklNKEZSRUlHSFRfUEFZTUVOVF9URVJNU19DT0RFKSwgJ1VOS05PV04nKSBBUyBGUkVJR0hUX1RFUk1TLAoJCUlOVkVOVE9SWV9PV05FUl9HUk9VUF9JRAoJRlJPTSBEX0RJU1RSSUJVVE9SX09SREVSUwoJV0hFUkUgUkVHSU9OX0lEID0gMQoJKSBETzstLSB5b3VyIGNvZGUgZ29lcyBoZXJl