Product: | ONT - Order Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OE_AK_SOLD_TO_ORGS_V |
SELECT CUST_ACCT.CUST_ACCOUNT_ID
, CUST_ACCT.PRICE_LIST_ID
, CUST_ACCT.FOB_POINT
, CUST_ACCT.FREIGHT_TERM
, CUST_ACCT.SHIP_PARTIAL
, CUST_ACCT.SHIP_VIA
, OE_HEADER_UTIL.GET_PRIMARY_SITE_USE_ID('BILL_TO'
, CUST_ACCT.CUST_ACCOUNT_ID
, HR.ORGANIZATION_ID) INVOICE_TO_ORG_ID
, OE_HEADER_UTIL.GET_PRIMARY_SITE_USE_ID('SHIP_TO'
, CUST_ACCT.CUST_ACCOUNT_ID
, HR.ORGANIZATION_ID) SHIP_TO_ORG_ID
, NULL
, CUST_PROF.STANDARD_TERMS
, CUST_ACCT.ORDER_TYPE_ID
, CUST_ACCT.PRIMARY_SALESREP_ID
, CUST_ACCT.SALES_CHANNEL_CODE
, TO_NUMBER(TO_CHAR(CUST_ACCT.WAREHOUSE_ID))
, CUST_ACCT.OVER_SHIPMENT_TOLERANCE
, CUST_ACCT.UNDER_SHIPMENT_TOLERANCE
, CUST_ACCT.OVER_RETURN_TOLERANCE
, CUST_ACCT.UNDER_RETURN_TOLERANCE
, CUST_ACCT.ITEM_CROSS_REF_PREF
, CUST_ACCT.DATE_TYPE_PREFERENCE
, CUST_ACCT.DATES_NEGATIVE_TOLERANCE
, CUST_ACCT.DATES_POSITIVE_TOLERANCE
, DECODE (NVL(CUST_ACCT.SHIP_SETS_INCLUDE_LINES_FLAG
, 'N')
, 'Y'
, 'SHIP'
, DECODE(NVL(CUST_ACCT.ARRIVALSETS_INCLUDE_LINES_FLAG
, 'N')
, 'Y'
, 'ARRIVAL'
, NULL)) DEFAULT_LINE_SET
, HR.ORGANIZATION_ID
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_CUSTOMER_PROFILES CUST_PROF
, HR_OPERATING_UNITS HR
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND CUST_ACCT.CUST_ACCOUNT_ID = CUST_PROF.CUST_ACCOUNT_ID(+)
AND CUST_PROF.SITE_USE_ID(+) IS NULL
AND MO_GLOBAL.CHECK_ACCESS (HR.ORGANIZATION_ID) = 'Y'