View: OE_AK_DELIVER_TO_ORGS_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_AK_DELIVER_TO_ORGS_V

View Text

SELECT DELIVER_TO.ORGANIZATION_ID
, DELIVER_TO.PRICE_LIST_ID
, DELIVER_TO.FOB_POINT_CODE
, DELIVER_TO.FREIGHT_TERMS_CODE
, DELIVER_TO.SHIP_PARTIAL_ALLOWED
, DELIVER_TO.SHIPPING_METHOD_CODE
, DELIVER_TO.CONTACT_ID
, DELIVER_TO.SOLD_FROM_ORG_ID
, DELIVER_TO.SHIP_FROM_ORG_ID
, DELIVER_TO.BILL_TO_SITE_USE_ID
, INV_TO.SITE_USE_ID
FROM OE_DELIVER_TO_ORGS_V DELIVER_TO
, HZ_CUST_SITE_USES_ALL INV_TO
WHERE DELIVER_TO.BILL_TO_SITE_USE_ID = INV_TO.SITE_USE_ID(+)
AND INV_TO.SITE_USE_CODE(+) = 'BILL_TO'
AND INV_TO.STATUS(+) = 'A'

Columns