APPS.ASO_SHIPMENT_PVT dependencies on HZ_CUST_SITE_USES

Line 264: FROM hz_cust_site_uses b,hz_cust_acct_sites a

260: WHERE quote_header_id = p_qte_header_id;
261:
262: CURSOR C_site_use(l_cust_id NUMBER, l_inv_site_id NUMBER) IS
263: SELECT site_use_id
264: FROM hz_cust_site_uses b,hz_cust_acct_sites a
265: WHERE b.cust_acct_site_id = a.cust_acct_site_id
266: AND b.site_use_code = 'BILL_TO' --and b.primary_flag = 'Y'
267: AND a.party_site_id = l_inv_site_id
268: AND a.cust_account_id = l_cust_id;

Line 351: --Get the site use id from the HZ_cust_site_uses

347: END IF;
348:
349: CLOSE c_inv_cust_id;
350:
351: --Get the site use id from the HZ_cust_site_uses
352:
353: OPEN C_site_use(l_cust_id , l_inv_site_id);
354: FETCH C_site_use into l_bill_site_use_id;
355: CLOSE C_site_use;

Line 449: --Get the site use id from the HZ_cust_site_uses

445: END IF; --c_inv_cust_id
446:
447: CLOSE c_inv_cust_id;
448:
449: --Get the site use id from the HZ_cust_site_uses
450:
451: OPEN C_site_use(l_cust_id , l_inv_site_id);
452: FETCH C_site_use into l_bill_site_use_id;
453: CLOSE C_site_use;

Line 526: FROM hz_cust_site_uses b,hz_cust_acct_sites a

522: and quote_line_id IS NULL;
523:
524: CURSOR C_site_use(l_cust_id NUMBER, l_ship_site_id NUMBER) IS
525: SELECT site_use_id
526: FROM hz_cust_site_uses b,hz_cust_acct_sites a
527: WHERE b.cust_acct_site_id = a.cust_acct_site_id
528: AND b.site_use_code = 'SHIP_TO' --and b.primary_flag = 'Y'
529: AND a.party_site_id = l_ship_site_id
530: AND a.cust_account_id = l_cust_id;

Line 662: --Get the site use id from the HZ_cust_site_uses

658:
659: CLOSE c_ship_cust_id;
660:
661:
662: --Get the site use id from the HZ_cust_site_uses
663:
664: OPEN C_site_use(l_cust_id , l_ship_site_id);
665: FETCH C_site_use into l_ship_site_use_id;
666:

Line 813: --Get the site use id from the HZ_cust_site_uses

809:
810: END IF;
811: CLOSE c_ship_cust_id;
812:
813: --Get the site use id from the HZ_cust_site_uses
814:
815: OPEN C_site_use(l_cust_id , l_ship_site_id);
816: FETCH C_site_use into l_ship_site_use_id;
817: