VIEW: APPS.RLM_CUST_SHIP_FROM_ORG_EXT_V

Source

View Text - Preformatted

SELECT distinct cust_assign_supplier_cd, decode(rcst.address_id, null, null, acct_sites.ece_tp_location_code) ece_tp_location_code, ood.organization_code, party.party_name, etd.translator_code, rcst.address_id, rcst.org_id FROM ece_tp_details etd , hz_cust_acct_sites_all acct_sites, hz_cust_accounts cust_acct , rlm_cust_shipto_terms_all rcst , org_organization_definitions ood, hz_parties party WHERE etd.document_type IN ('C-SPSI' , 'C-SSSI' ,'PSQ', 'DSNO' ,'ASN') AND etd.tp_header_id = acct_sites.tp_header_id AND cust_acct.party_id = party.party_id AND acct_sites.cust_account_id = acct_sites.cust_account_id AND cust_acct.cust_account_id = rcst.customer_id AND rcst.ship_from_org_id = ood.organization_id AND etd.edi_flag = 'Y' AND acct_sites.org_id = rcst.org_id AND ( (rcst.address_id IS NOT NULL AND rcst.address_id = acct_sites.cust_acct_site_id) OR (rcst.address_id IS NULL) )

View Text - HTML Formatted

SELECT DISTINCT CUST_ASSIGN_SUPPLIER_CD
, DECODE(RCST.ADDRESS_ID
, NULL
, NULL
, ACCT_SITES.ECE_TP_LOCATION_CODE) ECE_TP_LOCATION_CODE
, OOD.ORGANIZATION_CODE
, PARTY.PARTY_NAME
, ETD.TRANSLATOR_CODE
, RCST.ADDRESS_ID
, RCST.ORG_ID
FROM ECE_TP_DETAILS ETD
, HZ_CUST_ACCT_SITES_ALL ACCT_SITES
, HZ_CUST_ACCOUNTS CUST_ACCT
, RLM_CUST_SHIPTO_TERMS_ALL RCST
, ORG_ORGANIZATION_DEFINITIONS OOD
, HZ_PARTIES PARTY
WHERE ETD.DOCUMENT_TYPE IN ('C-SPSI'
, 'C-SSSI'
, 'PSQ'
, 'DSNO'
, 'ASN')
AND ETD.TP_HEADER_ID = ACCT_SITES.TP_HEADER_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND ACCT_SITES.CUST_ACCOUNT_ID = ACCT_SITES.CUST_ACCOUNT_ID
AND CUST_ACCT.CUST_ACCOUNT_ID = RCST.CUSTOMER_ID
AND RCST.SHIP_FROM_ORG_ID = OOD.ORGANIZATION_ID
AND ETD.EDI_FLAG = 'Y'
AND ACCT_SITES.ORG_ID = RCST.ORG_ID
AND ( (RCST.ADDRESS_ID IS NOT NULL
AND RCST.ADDRESS_ID = ACCT_SITES.CUST_ACCT_SITE_ID) OR (RCST.ADDRESS_ID IS NULL) )