[Home] [Help]
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
5033: -- SHIP_FROM_PARTY_NAME
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:
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.
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.
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:
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:
5145: party_id_tbl(l_party_index).party_number := l_ptnr_loc_tbl.ship_from_party_number(p_ptnr_idx);
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:
5195: party_id_tbl(l_party_index).party_number := l_ptnr_loc_tbl.bill_from_party_number(p_ptnr_idx);
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:
5245: party_id_tbl(l_party_index).party_number := l_ptnr_loc_tbl.ship_to_party_number(p_ptnr_idx);
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:
5295: party_id_tbl(l_party_index).party_number := l_ptnr_loc_tbl.bill_to_party_number(p_ptnr_idx);