VIEW: APPS.OE_AK_SHIP_TO_ORGS_V

Source

View Text - Preformatted

SELECT SHIP_TO.SITE_USE_ID , SHIP_TO.PRICE_LIST_ID , SHIP_TO.FOB_POINT , SHIP_TO.FREIGHT_TERM , SHIP_TO.SHIP_PARTIAL , SHIP_TO.SHIP_VIA , SHIP_TO.CONTACT_ID , SHIP_TO.WAREHOUSE_ID , SHIP_TO.WAREHOUSE_ID , SHIP_TO.BILL_TO_SITE_USE_ID , INV_TO.SITE_USE_ID , SHIP_TO.PAYMENT_TERM_ID , SHIP_TO.DEMAND_CLASS_CODE , SHIP_TO.PRIMARY_SALESREP_ID , SHIP_TO.OVER_SHIPMENT_TOLERANCE , SHIP_TO.UNDER_SHIPMENT_TOLERANCE , SHIP_TO.DATES_NEGATIVE_TOLERANCE , SHIP_TO.DATES_POSITIVE_TOLERANCE , SHIP_TO.DATE_TYPE_PREFERENCE , SHIP_TO.OVER_RETURN_TOLERANCE , SHIP_TO.UNDER_RETURN_TOLERANCE , SHIP_TO.ITEM_CROSS_REF_PREF , SHIP_TO.ORDER_TYPE_ID , DECODE (NVL(SHIP_TO.ship_sets_include_lines_flag,'N'),'Y','SHIP', DECODE(NVL(SHIP_TO.arrivalsets_include_lines_flag,'N'),'Y','ARRIVAL',NULL)) DEFAULT_LINE_SET , SHIP_TO.ORG_ID FROM HZ_CUST_SITE_USES SHIP_TO, HZ_CUST_SITE_USES_ALL INV_TO WHERE SHIP_TO.BILL_TO_SITE_USE_ID = INV_TO.SITE_USE_ID(+) AND SHIP_TO.site_use_code ='SHIP_TO' AND inv_to.site_use_code(+) = 'BILL_TO' AND ship_to.org_id = inv_to.org_id(+)

View Text - HTML Formatted

SELECT SHIP_TO.SITE_USE_ID
, SHIP_TO.PRICE_LIST_ID
, SHIP_TO.FOB_POINT
, SHIP_TO.FREIGHT_TERM
, SHIP_TO.SHIP_PARTIAL
, SHIP_TO.SHIP_VIA
, SHIP_TO.CONTACT_ID
, SHIP_TO.WAREHOUSE_ID
, SHIP_TO.WAREHOUSE_ID
, SHIP_TO.BILL_TO_SITE_USE_ID
, INV_TO.SITE_USE_ID
, SHIP_TO.PAYMENT_TERM_ID
, SHIP_TO.DEMAND_CLASS_CODE
, SHIP_TO.PRIMARY_SALESREP_ID
, SHIP_TO.OVER_SHIPMENT_TOLERANCE
, SHIP_TO.UNDER_SHIPMENT_TOLERANCE
, SHIP_TO.DATES_NEGATIVE_TOLERANCE
, SHIP_TO.DATES_POSITIVE_TOLERANCE
, SHIP_TO.DATE_TYPE_PREFERENCE
, SHIP_TO.OVER_RETURN_TOLERANCE
, SHIP_TO.UNDER_RETURN_TOLERANCE
, SHIP_TO.ITEM_CROSS_REF_PREF
, SHIP_TO.ORDER_TYPE_ID
, DECODE (NVL(SHIP_TO.SHIP_SETS_INCLUDE_LINES_FLAG
, 'N')
, 'Y'
, 'SHIP'
, DECODE(NVL(SHIP_TO.ARRIVALSETS_INCLUDE_LINES_FLAG
, 'N')
, 'Y'
, 'ARRIVAL'
, NULL)) DEFAULT_LINE_SET
, SHIP_TO.ORG_ID
FROM HZ_CUST_SITE_USES SHIP_TO
, HZ_CUST_SITE_USES_ALL INV_TO
WHERE SHIP_TO.BILL_TO_SITE_USE_ID = INV_TO.SITE_USE_ID(+)
AND SHIP_TO.SITE_USE_CODE ='SHIP_TO'
AND INV_TO.SITE_USE_CODE(+) = 'BILL_TO'
AND SHIP_TO.ORG_ID = INV_TO.ORG_ID(+)