APPS.RLM_EXTINTERFACE_SV dependencies on HZ_CUST_SITE_USES_ALL

Line 1923: from HZ_CUST_SITE_USES_ALL

1919: IF (x_OrgId IS NOT NULL) THEN
1920: -- Following query is changed as per TCA obsolescence project.
1921: select location
1922: into v_location
1923: from HZ_CUST_SITE_USES_ALL
1924: where site_use_code = 'SHIP_TO'
1925: and site_use_id = x_OrgId;
1926:
1927: return v_location;

Line 1956: from HZ_CUST_SITE_USES_ALL cust_site,

1952: --
1953: -- Following query is changed as per TCA obsolescence project.
1954: select loc.address1
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'

Line 1996: HZ_CUST_SITE_USES_ALL cust_site,

1992: CURSOR C is
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

Line 2024: HZ_CUST_SITE_USES_ALL CUST_SITE

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;
2028: --

Line 2040: HZ_CUST_SITE_USES_ALL CUST_SITE

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;
2044: --

Line 2066: HZ_CUST_SITE_USES_ALL CUST_SITE

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;
2070: --