APPS.RLM_EXTINTERFACE_SV dependencies on HZ_CUST_ACCT_SITES

Line 105: FROM hz_cust_acct_sites acct_site ,

101:
102: CURSOR get_ship_to_address (
103: P_SHIP_TO_ORG_ID IN NUMBER) IS
104: SELECT acct_site.ece_tp_location_code
105: FROM hz_cust_acct_sites acct_site ,
106: hz_cust_site_uses_all cust_site
107: WHERE cust_site.site_use_id = P_SHIP_TO_ORG_ID
108: AND cust_site.site_use_code = 'SHIP_TO'
109: AND cust_site.cust_acct_site_id = acct_site.cust_acct_site_id;

Line 2135: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

2131: into v_address1
2132: from HZ_CUST_SITE_USES_ALL cust_site,
2133: HZ_PARTY_SITES PARTY_SITE,
2134: HZ_LOCATIONS LOC,
2135: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
2136: where cust_site.site_use_code = 'SHIP_TO'
2137: and cust_site.site_use_id = x_OrgId
2138: and cust_site.CUST_ACCT_SITE_ID = acct_site.CUST_ACCT_SITE_ID
2139: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

Line 2173: HZ_CUST_ACCT_SITES ACCT_SITE

2169: SELECT ETG.tp_group_code
2170: FROM ece_tp_headers ETH,
2171: ece_tp_group ETG,
2172: HZ_CUST_SITE_USES_ALL cust_site,
2173: HZ_CUST_ACCT_SITES ACCT_SITE
2174: WHERE ACCT_SITE.CUST_ACCOUNT_ID = x_Op_rec.customer_id
2175: AND cust_site.site_use_id = x_Op_rec.ship_to_org_id
2176: and cust_site.CUST_ACCT_SITE_ID = acct_site.CUST_ACCT_SITE_ID
2177: AND ETH.tp_header_id = ACCT_SITE.tp_header_id

Line 2199: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

2195: --
2196: -- Following query is changed as per TCA obsolescence project.
2197: SELECT ACCT_SITE.ece_tp_location_code
2198: INTO x_ship_to_ece_locn_code
2199: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
2200: HZ_CUST_SITE_USES_ALL CUST_SITE
2201: WHERE cust_site.site_use_id = x_Op_rec.ship_to_org_id
2202: AND cust_site.site_use_code = 'SHIP_TO'
2203: AND CUST_SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID;

Line 2215: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

2211: --
2212: -- Following query is changed as per TCA obsolescence project.
2213: SELECT ACCT_SITE.ece_tp_location_code
2214: INTO x_bill_to_ece_locn_code
2215: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
2216: HZ_CUST_SITE_USES_ALL CUST_SITE
2217: WHERE cust_site.site_use_id = x_Op_rec.invoice_to_org_id
2218: AND cust_site.site_use_code = 'BILL_TO'
2219: AND CUST_SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID;

Line 2241: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

2237: --
2238: -- Following query is changed as per TCA obsolescence project.
2239: SELECT ACCT_SITE.ece_tp_location_code
2240: INTO x_inter_ship_to_ece_locn_code
2241: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
2242: HZ_CUST_SITE_USES_ALL CUST_SITE
2243: WHERE cust_site.site_use_id = x_Op_rec.intmed_ship_to_org_id
2244: AND cust_site.site_use_code = 'SHIP_TO'
2245: AND CUST_SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID;