VIEW: APPS.OE_AK_SOLD_TO_ORGS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'