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 508: FROM hz_cust_site_uses b,hz_cust_acct_sites a

504: and quote_line_id IS NULL;
505:
506: CURSOR C_site_use(l_cust_id NUMBER, l_ship_site_id NUMBER) IS
507: SELECT site_use_id
508: FROM hz_cust_site_uses b,hz_cust_acct_sites a
509: WHERE b.cust_acct_site_id = a.cust_acct_site_id
510: AND b.site_use_code = 'SHIP_TO' --and b.primary_flag = 'Y'
511: AND a.party_site_id = l_ship_site_id
512: AND a.cust_account_id = l_cust_id;

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

620:
621: CLOSE c_ship_cust_id;
622:
623:
624: --Get the site use id from the HZ_cust_site_uses
625:
626: OPEN C_site_use(l_cust_id , l_ship_site_id);
627: FETCH C_site_use into l_ship_site_use_id;
628:

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

760:
761: END IF;
762: CLOSE c_ship_cust_id;
763:
764: --Get the site use id from the HZ_cust_site_uses
765:
766: OPEN C_site_use(l_cust_id , l_ship_site_id);
767: FETCH C_site_use into l_ship_site_use_id;
768: