View: OE_AK_SHIP_TO_ORGS_V

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

View Text

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(+)

Columns