APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on HZ_CUST_ACCOUNTS

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

818: Party Type PTP known Other Info Derivation Logic
819: --------------- ----- ----------- ----------------
820: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
821:
822: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES
823: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
824:
825: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
826: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in

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

819: --------------- ----- ----------- ----------------
820: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
821:
822: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES
823: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
824:
825: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
826: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in
827: Rel 12 with new partner integration, he must do legal to business association using LE form.

Line 886: FROM hz_cust_accounts hzca,

882: SELECT hzp.party_name,
883: hzp.party_number
884: INTO ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_NAME(i),
885: ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_NUMBER(i)
886: FROM hz_cust_accounts hzca,
887: hz_parties hzp
888: WHERE hzp.party_id = hzca.party_id
889: AND hzca.cust_account_id = ZX_PTNR_NEG_LINES_TAB.BILL_THIRD_PTY_ACCT_ID(i);
890: END;

Line 923: FROM hz_cust_accounts hzca,

919: SELECT hzp.party_name,
920: hzp.party_number
921: INTO ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_NAME(i),
922: ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_NUMBER(i)
923: FROM hz_cust_accounts hzca,
924: hz_parties hzp
925: WHERE hzp.party_id = hzca.party_id
926: AND hzca.cust_account_id = ZX_PTNR_NEG_LINES_TAB.BILL_THIRD_PTY_ACCT_ID(i);
927: EXCEPTION WHEN OTHERS THEN

Line 1056: FROM hz_cust_site_uses_all siteuse, hz_cust_acct_sites_all site, hz_cust_accounts acct, zx_party_tax_profile ptp

1052: BEGIN
1053: BEGIN
1054: SELECT ptp.party_tax_profile_id
1055: INTO x_party_tax_profile_id
1056: FROM hz_cust_site_uses_all siteuse, hz_cust_acct_sites_all site, hz_cust_accounts acct, zx_party_tax_profile ptp
1057: WHERE siteuse.site_use_id = p_site_use_id and
1058: siteuse.cust_acct_site_id = site.cust_acct_site_id and
1059: site.cust_account_id = acct.cust_account_id and
1060: acct.party_id = ptp.party_id and