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 789: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES

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

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

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

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.
797: That would create a PTP for the first party inv org.
798: Hence, there will be a record in HZ_PARTIES and is correct to derive info from HZ_PARTIES.
799:
800: SHIP/BILL FROM N NULL (PTP is always expected)
801:
802: -------------------------------------------------------------------------------------------

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

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

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

806: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
807: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in
808: Rel 12 with new partner integration, he must do legal to business association using LE form.
809: That would create a PTP for the first party inv org.
810: Hence, there will definitely be record in HZ_PARTIES.
811:
812: SHIP/BILL TO N NULL (PTP is always expected)
813:
814: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES

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

810: Hence, there will definitely be record in HZ_PARTIES.
811:
812: SHIP/BILL TO N NULL (PTP is always expected)
813:
814: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
815:
816: SHIP/BILL FROM N SHIP_THIRD_PTY_ACCT_ID Via PO_VENDORS
817: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of VENDOR_ID.
818:

Line 840: FROM hz_parties pty,

836: SELECT pty.party_name,
837: pty.party_number
838: INTO ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_NAME(i),
839: ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_NUMBER(i)
840: FROM hz_parties pty,
841: zx_party_tax_profile ptp
842: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_TAX_PROF_ID(i)
843: AND ptp.party_id = pty.party_id;
844: EXCEPTION WHEN OTHERS THEN

Line 856: hz_parties hzp

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

Line 893: hz_parties hzp

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

Line 913: FROM hz_parties pty,

909: SELECT pty.party_name,
910: pty.party_number
911: INTO ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_NAME(i),
912: ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_NUMBER(i)
913: FROM hz_parties pty,
914: zx_party_tax_profile ptp
915: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_TAX_PROF_ID(i)
916: AND ptp.party_id = pty.party_id;
917: EXCEPTION WHEN OTHERS THEN

Line 941: FROM hz_parties pty,

937: SELECT pty.party_name,
938: pty.party_number
939: INTO ZX_PTNR_NEG_LINES_TAB.BILL_FROM_PARTY_NAME(i),
940: ZX_PTNR_NEG_LINES_TAB.BILL_FROM_PARTY_NUMBER(i)
941: FROM hz_parties pty,
942: zx_party_tax_profile ptp
943: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.BILL_FROM_PARTY_TAX_PROF_ID(i)
944: AND ptp.party_id = pty.party_id;
945: EXCEPTION WHEN OTHERS THEN

Line 978: FROM hz_parties pty,

974: SELECT pty.party_name,
975: pty.party_number
976: INTO ZX_PTNR_NEG_LINES_TAB.SHIP_FROM_PARTY_NAME(i),
977: ZX_PTNR_NEG_LINES_TAB.SHIP_FROM_PARTY_NUMBER(i)
978: FROM hz_parties pty,
979: zx_party_tax_profile ptp
980: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.SHIP_FROM_PARTY_TAX_PROF_ID(i)
981: AND ptp.party_id = pty.party_id;
982: EXCEPTION WHEN OTHERS THEN

Line 2289: FROM HZ_PARTIES pty,

2285:
2286: Begin
2287: SELECT pty.party_name
2288: INTO l_srvc_prvdr_name
2289: FROM HZ_PARTIES pty,
2290: ZX_PARTY_TAX_PROFILE ptp
2291: WHERE ptp.party_tax_profile_id =p_srvc_prvdr_id
2292: AND pty.party_id = ptp.party_id
2293: AND ptp.provider_type_code in ('BOTH', 'SERVICE');

Line 2623: FROM HZ_PARTIES pty,

2619:
2620: Begin
2621: SELECT pty.party_name
2622: INTO l_srvc_prvdr_name
2623: FROM HZ_PARTIES pty,
2624: ZX_PARTY_TAX_PROFILE ptp
2625: WHERE ptp.party_tax_profile_id =p_srvc_prvdr_id
2626: AND pty.party_id = ptp.party_id
2627: AND ptp.provider_type_code in ('BOTH', 'SERVICE');