APPS.ZX_SRVC_TYP_PKG dependencies on HZ_CUST_ACCOUNTS

Line 5098: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES

5094: Party Type PTP known Other Info Derivation Logic
5095: --------------- ----- ----------- ----------------
5096: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5097:
5098: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES
5099: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
5100:
5101: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5102: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in

Line 5099: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.

5095: --------------- ----- ----------- ----------------
5096: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5097:
5098: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES
5099: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
5100:
5101: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5102: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in
5103: Rel 12 with new partner integration, he must do legal to business association using LE form.

Line 5262: FROM hz_cust_accounts hzca,

5258: SELECT hzp.party_name,
5259: hzp.party_number
5260: INTO l_ptnr_loc_tbl.ship_to_party_name(p_ptnr_idx),
5261: l_ptnr_loc_tbl.ship_to_party_number(p_ptnr_idx)
5262: FROM hz_cust_accounts hzca,
5263: hz_parties hzp
5264: WHERE hzp.party_id = hzca.party_id
5265: AND hzca.cust_account_id = l_ship_third_pty_acct_id;
5266: EXCEPTION WHEN OTHERS THEN

Line 5312: FROM hz_cust_accounts hzca,

5308: SELECT hzp.party_name,
5309: hzp.party_number
5310: INTO l_ptnr_loc_tbl.bill_to_party_name(p_ptnr_idx),
5311: l_ptnr_loc_tbl.bill_to_party_number(p_ptnr_idx)
5312: FROM hz_cust_accounts hzca,
5313: hz_parties hzp
5314: WHERE hzp.party_id = hzca.party_id
5315: AND hzca.cust_account_id = l_bill_third_pty_acct_id;
5316: EXCEPTION WHEN OTHERS THEN