APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on HZ_CUST_ACCOUNTS

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

787: Party Type PTP known Other Info Derivation Logic
788: --------------- ----- ----------- ----------------
789: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
790:
791: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES
792: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
793:
794: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
795: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in

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

788: --------------- ----- ----------- ----------------
789: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
790:
791: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES
792: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
793:
794: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
795: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in
796: Rel 12 with new partner integration, he must do legal to business association using LE form.

Line 855: FROM hz_cust_accounts hzca,

851: SELECT hzp.party_name,
852: hzp.party_number
853: INTO ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_NAME(i),
854: ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_NUMBER(i)
855: FROM hz_cust_accounts hzca,
856: hz_parties hzp
857: WHERE hzp.party_id = hzca.party_id
858: AND hzca.cust_account_id = ZX_PTNR_NEG_LINES_TAB.BILL_THIRD_PTY_ACCT_ID(i);
859: END;

Line 892: FROM hz_cust_accounts hzca,

888: SELECT hzp.party_name,
889: hzp.party_number
890: INTO ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_NAME(i),
891: ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_NUMBER(i)
892: FROM hz_cust_accounts hzca,
893: hz_parties hzp
894: WHERE hzp.party_id = hzca.party_id
895: AND hzca.cust_account_id = ZX_PTNR_NEG_LINES_TAB.BILL_THIRD_PTY_ACCT_ID(i);
896: EXCEPTION WHEN OTHERS THEN

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

1021: BEGIN
1022: BEGIN
1023: SELECT ptp.party_tax_profile_id
1024: INTO x_party_tax_profile_id
1025: FROM hz_cust_site_uses_all siteuse, hz_cust_acct_sites_all site, hz_cust_accounts acct, zx_party_tax_profile ptp
1026: WHERE siteuse.site_use_id = p_site_use_id and
1027: siteuse.cust_acct_site_id = site.cust_acct_site_id and
1028: site.cust_account_id = acct.cust_account_id and
1029: acct.party_id = ptp.party_id and