APPS.ZX_SRVC_TYP_PKG dependencies on HZ_CUST_ACCOUNTS

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

5921: Party Type PTP known Other Info Derivation Logic
5922: --------------- ----- ----------- ----------------
5923: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5924:
5925: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES
5926: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
5927:
5928: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5929: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in

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

5922: --------------- ----- ----------- ----------------
5923: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5924:
5925: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES
5926: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
5927:
5928: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5929: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in
5930: Rel 12 with new partner integration, he must do legal to business association using LE form.

Line 6089: FROM hz_cust_accounts hzca,

6085: SELECT hzp.party_name,
6086: hzp.party_number
6087: INTO l_ptnr_loc_tbl.ship_to_party_name(p_ptnr_idx),
6088: l_ptnr_loc_tbl.ship_to_party_number(p_ptnr_idx)
6089: FROM hz_cust_accounts hzca,
6090: hz_parties hzp
6091: WHERE hzp.party_id = hzca.party_id
6092: AND hzca.cust_account_id = l_ship_third_pty_acct_id;
6093: EXCEPTION WHEN OTHERS THEN

Line 6139: FROM hz_cust_accounts hzca,

6135: SELECT hzp.party_name,
6136: hzp.party_number
6137: INTO l_ptnr_loc_tbl.bill_to_party_name(p_ptnr_idx),
6138: l_ptnr_loc_tbl.bill_to_party_number(p_ptnr_idx)
6139: FROM hz_cust_accounts hzca,
6140: hz_parties hzp
6141: WHERE hzp.party_id = hzca.party_id
6142: AND hzca.cust_account_id = l_bill_third_pty_acct_id;
6143: EXCEPTION WHEN OTHERS THEN