APPS.RLM_EXTINTERFACE_SV dependencies on HZ_CUST_SITE_USES_ALL

Line 106: hz_cust_site_uses_all cust_site

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

Line 2099: from HZ_CUST_SITE_USES_ALL

2095: IF (x_OrgId IS NOT NULL) THEN
2096: -- Following query is changed as per TCA obsolescence project.
2097: select location
2098: into v_location
2099: from HZ_CUST_SITE_USES_ALL
2100: where site_use_code = 'SHIP_TO'
2101: and site_use_id = x_OrgId;
2102:
2103: return v_location;

Line 2132: from HZ_CUST_SITE_USES_ALL cust_site,

2128: --
2129: -- Following query is changed as per TCA obsolescence project.
2130: select loc.address1
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'

Line 2172: HZ_CUST_SITE_USES_ALL cust_site,

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

Line 2200: HZ_CUST_SITE_USES_ALL CUST_SITE

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

Line 2216: HZ_CUST_SITE_USES_ALL CUST_SITE

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

Line 2242: HZ_CUST_SITE_USES_ALL CUST_SITE

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