VIEW: APPS.OE_AK_DELIVER_TO_ORGS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'