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_SRVC_TYP_PKG dependencies on HZ_PARTIES

Line 5855: -- Retrieve the following from hz_parties given the party_tax_profile ids

5851: -- PRIVATE PROCEDURE
5852: -- populate_parties
5853: --
5854: -- DESCRIPTION
5855: -- Retrieve the following from hz_parties given the party_tax_profile ids
5856: -- from zx_lines_det_factors and zx_party_tax_profile
5857: -- SHIP_TO_PARTY_NUMBER
5858: -- SHIP_TO_PARTY_NAME
5859: -- SHIP_FROM_PARTY_NUMBER

Line 5914: Get the party_number,party_name from hz_parties for the ptp_ids

5910: AND trx_line_id = p_trx_line_id
5911: AND trx_level_type = p_trx_level_type;
5912:
5913: /*
5914: Get the party_number,party_name from hz_parties for the ptp_ids
5915: Cache the values in party_id_tbl so that multiple selects are not performed
5916:
5917: Bug 4939819
5918: The source of party number and name information varies depending upon the family group.

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

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

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

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

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.
5931: That would create a PTP for the first party inv org.
5932: Hence, there will be a record in HZ_PARTIES and is correct to derive info from HZ_PARTIES.
5933:
5934: SHIP/BILL FROM N NULL (PTP is always expected)
5935:
5936: -------------------------------------------------------------------------------------------

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

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

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

5940: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5941: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in
5942: Rel 12 with new partner integration, he must do legal to business association using LE form.
5943: That would create a PTP for the first party inv org.
5944: Hence, there will definitely be record in HZ_PARTIES.
5945:
5946: SHIP/BILL TO N NULL (PTP is always expected)
5947:
5948: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES

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

5944: Hence, there will definitely be record in HZ_PARTIES.
5945:
5946: SHIP/BILL TO N NULL (PTP is always expected)
5947:
5948: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5949:
5950: SHIP/BILL FROM N SHIP_THIRD_PTY_ACCT_ID Via AP_SUPPLIERS
5951: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of VENDOR_ID.
5952:

Line 5967: FROM hz_parties pty,

5963: SELECT pty.party_name,
5964: pty.party_number
5965: INTO l_ptnr_loc_tbl.ship_from_party_name(p_ptnr_idx),
5966: l_ptnr_loc_tbl.ship_from_party_number(p_ptnr_idx)
5967: FROM hz_parties pty,
5968: zx_party_tax_profile ptp
5969: WHERE ptp.party_tax_profile_id = l_ship_from_ptp_id
5970: AND ptp.party_id = pty.party_id;
5971:

Line 5990: , hz_parties hp

5986: hp.party_number
5987: INTO l_ptnr_loc_tbl.ship_from_party_name(p_ptnr_idx),
5988: l_ptnr_loc_tbl.ship_from_party_number(p_ptnr_idx)
5989: FROM ap_suppliers po
5990: , hz_parties hp
5991: WHERE po.vendor_id = l_ship_third_pty_acct_id
5992: AND po.party_id = hp.party_id;
5993: EXCEPTION WHEN OTHERS THEN
5994: l_ptnr_loc_tbl.ship_from_party_number(p_ptnr_idx):= null;

Line 6017: FROM hz_parties pty,

6013: SELECT pty.party_name,
6014: pty.party_number
6015: INTO l_ptnr_loc_tbl.bill_from_party_name(p_ptnr_idx),
6016: l_ptnr_loc_tbl.bill_from_party_number(p_ptnr_idx)
6017: FROM hz_parties pty,
6018: zx_party_tax_profile ptp
6019: WHERE ptp.party_tax_profile_id = l_bill_from_ptp_id
6020: AND ptp.party_id = pty.party_id;
6021:

Line 6040: , hz_parties hp

6036: hp.party_number
6037: INTO l_ptnr_loc_tbl.bill_from_party_name(p_ptnr_idx),
6038: l_ptnr_loc_tbl.bill_from_party_number(p_ptnr_idx)
6039: FROM ap_suppliers po
6040: , hz_parties hp
6041: WHERE po.vendor_id = l_bill_third_pty_acct_id
6042: AND po.party_id = hp.party_id;
6043: EXCEPTION WHEN OTHERS THEN
6044: l_ptnr_loc_tbl.bill_from_party_number(p_ptnr_idx):= null;

Line 6067: FROM hz_parties pty,

6063: SELECT pty.party_name,
6064: pty.party_number
6065: INTO l_ptnr_loc_tbl.ship_to_party_name(p_ptnr_idx),
6066: l_ptnr_loc_tbl.ship_to_party_number(p_ptnr_idx)
6067: FROM hz_parties pty,
6068: zx_party_tax_profile ptp
6069: WHERE ptp.party_tax_profile_id = l_ship_to_ptp_id
6070: AND ptp.party_id = pty.party_id;
6071:

Line 6090: hz_parties hzp

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
6094: l_ptnr_loc_tbl.ship_to_party_number(p_ptnr_idx):= null;

Line 6117: FROM hz_parties pty,

6113: SELECT pty.party_name,
6114: pty.party_number
6115: INTO l_ptnr_loc_tbl.bill_to_party_name(p_ptnr_idx),
6116: l_ptnr_loc_tbl.bill_to_party_number(p_ptnr_idx)
6117: FROM hz_parties pty,
6118: zx_party_tax_profile ptp
6119: WHERE ptp.party_tax_profile_id = l_bill_to_ptp_id
6120: AND ptp.party_id = pty.party_id;
6121:

Line 6140: hz_parties hzp

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
6144: l_ptnr_loc_tbl.bill_to_party_number(p_ptnr_idx):= null;