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 5028: -- Retrieve the following from hz_parties given the party_tax_profile ids

5024: -- PRIVATE PROCEDURE
5025: -- populate_parties
5026: --
5027: -- DESCRIPTION
5028: -- Retrieve the following from hz_parties given the party_tax_profile ids
5029: -- from zx_lines_det_factors and zx_party_tax_profile
5030: -- SHIP_TO_PARTY_NUMBER
5031: -- SHIP_TO_PARTY_NAME
5032: -- SHIP_FROM_PARTY_NUMBER

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

5083: AND trx_line_id = p_trx_line_id
5084: AND trx_level_type = p_trx_level_type;
5085:
5086: /*
5087: Get the party_number,party_name from hz_parties for the ptp_ids
5088: Cache the values in party_id_tbl so that multiple selects are not performed
5089:
5090: Bug 4939819
5091: The source of party number and name information varies depending upon the family group.

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

5092:
5093: For O2C products, the information can be derived as follows.
5094: Party Type PTP known Other Info Derivation Logic
5095: --------------- ----- ----------- ----------------
5096: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5097:
5098: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES
5099: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
5100:

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

5094: Party Type PTP known Other Info Derivation Logic
5095: --------------- ----- ----------- ----------------
5096: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5097:
5098: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES
5099: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
5100:
5101: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5102: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in

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

5097:
5098: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES
5099: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
5100:
5101: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5102: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in
5103: Rel 12 with new partner integration, he must do legal to business association using LE form.
5104: That would create a PTP for the first party inv org.
5105: Hence, there will be a record in HZ_PARTIES and is correct to derive info from HZ_PARTIES.

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

5101: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5102: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in
5103: Rel 12 with new partner integration, he must do legal to business association using LE form.
5104: That would create a PTP for the first party inv org.
5105: Hence, there will be a record in HZ_PARTIES and is correct to derive info from HZ_PARTIES.
5106:
5107: SHIP/BILL FROM N NULL (PTP is always expected)
5108:
5109: -------------------------------------------------------------------------------------------

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

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

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

5113: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5114: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in
5115: Rel 12 with new partner integration, he must do legal to business association using LE form.
5116: That would create a PTP for the first party inv org.
5117: Hence, there will definitely be record in HZ_PARTIES.
5118:
5119: SHIP/BILL TO N NULL (PTP is always expected)
5120:
5121: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES

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

5117: Hence, there will definitely be record in HZ_PARTIES.
5118:
5119: SHIP/BILL TO N NULL (PTP is always expected)
5120:
5121: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5122:
5123: SHIP/BILL FROM N SHIP_THIRD_PTY_ACCT_ID Via AP_SUPPLIERS
5124: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of VENDOR_ID.
5125:

Line 5140: FROM hz_parties pty,

5136: SELECT pty.party_name,
5137: pty.party_number
5138: INTO l_ptnr_loc_tbl.ship_from_party_name(p_ptnr_idx),
5139: l_ptnr_loc_tbl.ship_from_party_number(p_ptnr_idx)
5140: FROM hz_parties pty,
5141: zx_party_tax_profile ptp
5142: WHERE ptp.party_tax_profile_id = l_ship_from_ptp_id
5143: AND ptp.party_id = pty.party_id;
5144:

Line 5163: , hz_parties hp

5159: hp.party_number
5160: INTO l_ptnr_loc_tbl.ship_from_party_name(p_ptnr_idx),
5161: l_ptnr_loc_tbl.ship_from_party_number(p_ptnr_idx)
5162: FROM ap_suppliers po
5163: , hz_parties hp
5164: WHERE po.vendor_id = l_ship_third_pty_acct_id
5165: AND po.party_id = hp.party_id;
5166: EXCEPTION WHEN OTHERS THEN
5167: l_ptnr_loc_tbl.ship_from_party_number(p_ptnr_idx):= null;

Line 5190: FROM hz_parties pty,

5186: SELECT pty.party_name,
5187: pty.party_number
5188: INTO l_ptnr_loc_tbl.bill_from_party_name(p_ptnr_idx),
5189: l_ptnr_loc_tbl.bill_from_party_number(p_ptnr_idx)
5190: FROM hz_parties pty,
5191: zx_party_tax_profile ptp
5192: WHERE ptp.party_tax_profile_id = l_bill_from_ptp_id
5193: AND ptp.party_id = pty.party_id;
5194:

Line 5213: , hz_parties hp

5209: hp.party_number
5210: INTO l_ptnr_loc_tbl.bill_from_party_name(p_ptnr_idx),
5211: l_ptnr_loc_tbl.bill_from_party_number(p_ptnr_idx)
5212: FROM ap_suppliers po
5213: , hz_parties hp
5214: WHERE po.vendor_id = l_bill_third_pty_acct_id
5215: AND po.party_id = hp.party_id;
5216: EXCEPTION WHEN OTHERS THEN
5217: l_ptnr_loc_tbl.bill_from_party_number(p_ptnr_idx):= null;

Line 5240: FROM hz_parties pty,

5236: SELECT pty.party_name,
5237: pty.party_number
5238: INTO l_ptnr_loc_tbl.ship_to_party_name(p_ptnr_idx),
5239: l_ptnr_loc_tbl.ship_to_party_number(p_ptnr_idx)
5240: FROM hz_parties pty,
5241: zx_party_tax_profile ptp
5242: WHERE ptp.party_tax_profile_id = l_ship_to_ptp_id
5243: AND ptp.party_id = pty.party_id;
5244:

Line 5263: hz_parties hzp

5259: hzp.party_number
5260: INTO l_ptnr_loc_tbl.ship_to_party_name(p_ptnr_idx),
5261: l_ptnr_loc_tbl.ship_to_party_number(p_ptnr_idx)
5262: FROM hz_cust_accounts hzca,
5263: hz_parties hzp
5264: WHERE hzp.party_id = hzca.party_id
5265: AND hzca.cust_account_id = l_ship_third_pty_acct_id;
5266: EXCEPTION WHEN OTHERS THEN
5267: l_ptnr_loc_tbl.ship_to_party_number(p_ptnr_idx):= null;

Line 5290: FROM hz_parties pty,

5286: SELECT pty.party_name,
5287: pty.party_number
5288: INTO l_ptnr_loc_tbl.bill_to_party_name(p_ptnr_idx),
5289: l_ptnr_loc_tbl.bill_to_party_number(p_ptnr_idx)
5290: FROM hz_parties pty,
5291: zx_party_tax_profile ptp
5292: WHERE ptp.party_tax_profile_id = l_bill_to_ptp_id
5293: AND ptp.party_id = pty.party_id;
5294:

Line 5313: hz_parties hzp

5309: hzp.party_number
5310: INTO l_ptnr_loc_tbl.bill_to_party_name(p_ptnr_idx),
5311: l_ptnr_loc_tbl.bill_to_party_number(p_ptnr_idx)
5312: FROM hz_cust_accounts hzca,
5313: hz_parties hzp
5314: WHERE hzp.party_id = hzca.party_id
5315: AND hzca.cust_account_id = l_bill_third_pty_acct_id;
5316: EXCEPTION WHEN OTHERS THEN
5317: l_ptnr_loc_tbl.bill_to_party_number(p_ptnr_idx):= null;