eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on HZ_PARTIES

Line 820: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES

816:
817: For O2C products, the information can be derived as follows.
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:

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 825: SHIP/BILL FROM 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.
828: That would create a PTP for the first party inv org.
829: Hence, there will be a record in HZ_PARTIES and is correct to derive info from HZ_PARTIES.

Line 829: Hence, there will be a record in HZ_PARTIES and is correct to derive info from HZ_PARTIES.

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.
828: That would create a PTP for the first party inv org.
829: Hence, there will be a record in HZ_PARTIES and is correct to derive info from HZ_PARTIES.
830:
831: SHIP/BILL FROM N NULL (PTP is always expected)
832:
833: -------------------------------------------------------------------------------------------

Line 837: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES

833: -------------------------------------------------------------------------------------------
834: For P2P products, the information can be derived as follows.
835: Party Type PTP known Other Info Derivation Logic
836: --------------- ----- ----------- ----------------
837: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
838: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in
839: Rel 12 with new partner integration, he must do legal to business association using LE form.
840: That would create a PTP for the first party inv org.
841: Hence, there will definitely be record in HZ_PARTIES.

Line 841: Hence, there will definitely be record in HZ_PARTIES.

837: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
838: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in
839: Rel 12 with new partner integration, he must do legal to business association using LE form.
840: That would create a PTP for the first party inv org.
841: Hence, there will definitely be record in HZ_PARTIES.
842:
843: SHIP/BILL TO N NULL (PTP is always expected)
844:
845: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES

Line 845: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES

841: Hence, there will definitely be record in HZ_PARTIES.
842:
843: SHIP/BILL TO N NULL (PTP is always expected)
844:
845: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
846:
847: SHIP/BILL FROM N SHIP_THIRD_PTY_ACCT_ID Via PO_VENDORS
848: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of VENDOR_ID.
849:

Line 871: FROM hz_parties pty,

867: SELECT pty.party_name,
868: pty.party_number
869: INTO ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_NAME(i),
870: ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_NUMBER(i)
871: FROM hz_parties pty,
872: zx_party_tax_profile ptp
873: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_TAX_PROF_ID(i)
874: AND ptp.party_id = pty.party_id;
875: EXCEPTION WHEN OTHERS THEN

Line 887: hz_parties hzp

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;
891: ELSE

Line 924: hz_parties hzp

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
928: ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_NAME(i) := NULL;

Line 944: FROM hz_parties pty,

940: SELECT pty.party_name,
941: pty.party_number
942: INTO ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_NAME(i),
943: ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_NUMBER(i)
944: FROM hz_parties pty,
945: zx_party_tax_profile ptp
946: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_TAX_PROF_ID(i)
947: AND ptp.party_id = pty.party_id;
948: EXCEPTION WHEN OTHERS THEN

Line 972: FROM hz_parties pty,

968: SELECT pty.party_name,
969: pty.party_number
970: INTO ZX_PTNR_NEG_LINES_TAB.BILL_FROM_PARTY_NAME(i),
971: ZX_PTNR_NEG_LINES_TAB.BILL_FROM_PARTY_NUMBER(i)
972: FROM hz_parties pty,
973: zx_party_tax_profile ptp
974: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.BILL_FROM_PARTY_TAX_PROF_ID(i)
975: AND ptp.party_id = pty.party_id;
976: EXCEPTION WHEN OTHERS THEN

Line 1009: FROM hz_parties pty,

1005: SELECT pty.party_name,
1006: pty.party_number
1007: INTO ZX_PTNR_NEG_LINES_TAB.SHIP_FROM_PARTY_NAME(i),
1008: ZX_PTNR_NEG_LINES_TAB.SHIP_FROM_PARTY_NUMBER(i)
1009: FROM hz_parties pty,
1010: zx_party_tax_profile ptp
1011: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.SHIP_FROM_PARTY_TAX_PROF_ID(i)
1012: AND ptp.party_id = pty.party_id;
1013: EXCEPTION WHEN OTHERS THEN

Line 2334: FROM HZ_PARTIES pty,

2330:
2331: Begin
2332: SELECT pty.party_name
2333: INTO l_srvc_prvdr_name
2334: FROM HZ_PARTIES pty,
2335: ZX_PARTY_TAX_PROFILE ptp
2336: WHERE ptp.party_tax_profile_id =p_srvc_prvdr_id
2337: AND pty.party_id = ptp.party_id
2338: AND ptp.provider_type_code in ('BOTH', 'SERVICE');

Line 2670: FROM HZ_PARTIES pty,

2666:
2667: Begin
2668: SELECT pty.party_name
2669: INTO l_srvc_prvdr_name
2670: FROM HZ_PARTIES pty,
2671: ZX_PARTY_TAX_PROFILE ptp
2672: WHERE ptp.party_tax_profile_id =p_srvc_prvdr_id
2673: AND pty.party_id = ptp.party_id
2674: AND ptp.provider_type_code in ('BOTH', 'SERVICE');