APPS.RLM_EXTINTERFACE_SV dependencies on HZ_CUST_ACCT_SITES

Line 1959: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1955: into v_address1
1956: from HZ_CUST_SITE_USES_ALL cust_site,
1957: HZ_PARTY_SITES PARTY_SITE,
1958: HZ_LOCATIONS LOC,
1959: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1960: where cust_site.site_use_code = 'SHIP_TO'
1961: and cust_site.site_use_id = x_OrgId
1962: and cust_site.CUST_ACCT_SITE_ID = acct_site.CUST_ACCT_SITE_ID
1963: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

Line 1997: HZ_CUST_ACCT_SITES ACCT_SITE

1993: SELECT ETG.tp_group_code
1994: FROM ece_tp_headers ETH,
1995: ece_tp_group ETG,
1996: HZ_CUST_SITE_USES_ALL cust_site,
1997: HZ_CUST_ACCT_SITES ACCT_SITE
1998: WHERE ACCT_SITE.CUST_ACCOUNT_ID = x_Op_rec.customer_id
1999: AND cust_site.site_use_id = x_Op_rec.ship_to_org_id
2000: and cust_site.CUST_ACCT_SITE_ID = acct_site.CUST_ACCT_SITE_ID
2001: AND ETH.tp_header_id = ACCT_SITE.tp_header_id

Line 2023: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

2019: --
2020: -- Following query is changed as per TCA obsolescence project.
2021: SELECT ACCT_SITE.ece_tp_location_code
2022: INTO x_ship_to_ece_locn_code
2023: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
2024: HZ_CUST_SITE_USES_ALL CUST_SITE
2025: WHERE cust_site.site_use_id = x_Op_rec.ship_to_org_id
2026: AND cust_site.site_use_code = 'SHIP_TO'
2027: AND CUST_SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID;

Line 2039: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

2035: --
2036: -- Following query is changed as per TCA obsolescence project.
2037: SELECT ACCT_SITE.ece_tp_location_code
2038: INTO x_bill_to_ece_locn_code
2039: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
2040: HZ_CUST_SITE_USES_ALL CUST_SITE
2041: WHERE cust_site.site_use_id = x_Op_rec.invoice_to_org_id
2042: AND cust_site.site_use_code = 'BILL_TO'
2043: AND CUST_SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID;

Line 2065: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

2061: --
2062: -- Following query is changed as per TCA obsolescence project.
2063: SELECT ACCT_SITE.ece_tp_location_code
2064: INTO x_inter_ship_to_ece_locn_code
2065: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
2066: HZ_CUST_SITE_USES_ALL CUST_SITE
2067: WHERE cust_site.site_use_id = x_Op_rec.intmed_ship_to_org_id
2068: AND cust_site.site_use_code = 'SHIP_TO'
2069: AND CUST_SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID;