[Home] [Help]
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
5860: -- SHIP_FROM_PARTY_NAME
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:
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.
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.
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:
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:
5972: party_id_tbl(l_party_index).party_number := l_ptnr_loc_tbl.ship_from_party_number(p_ptnr_idx);
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:
6022: party_id_tbl(l_party_index).party_number := l_ptnr_loc_tbl.bill_from_party_number(p_ptnr_idx);
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:
6072: party_id_tbl(l_party_index).party_number := l_ptnr_loc_tbl.ship_to_party_number(p_ptnr_idx);
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:
6122: party_id_tbl(l_party_index).party_number := l_ptnr_loc_tbl.bill_to_party_number(p_ptnr_idx);
11270: AND zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(l_trx_line_index) IS NULL
11271: THEN
11272: SELECT party_id
11273: INTO zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(l_trx_line_index)
11274: FROM zx_party_tax_profile
11275: WHERE party_tax_profile_id = zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_TAX_PROF_ID(l_trx_line_index);
11276: END IF;
11277:
11278: IF zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_TAX_PROF_ID(l_trx_line_index) IS NOT NULL
11279: AND zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_ID(l_trx_line_index) IS NULL
11280: THEN
11281: SELECT party_id
11282: INTO zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_ID(l_trx_line_index)
11283: FROM zx_party_tax_profile
11284: WHERE party_tax_profile_id = zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_TAX_PROF_ID(l_trx_line_index);
11285: END IF;
11286:
11287: /*-------------------------------------------------------+
18705: l_tbl_index := to_char(l_legal_entity_id);
18706:
18707: SELECT xle_etb.establishment_id
18708: INTO l_establishment_id
18709: FROM zx_party_tax_profile ptp,
18710: xle_etb_profiles xle_etb
18711: WHERE ptp.party_id = xle_etb.party_id
18712: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
18713: AND xle_etb.legal_entity_id = l_legal_entity_id
18731: l_tbl_index := to_char(l_legal_entity_id);
18732: IF NOT l_main_estb_for_entity_tbl.EXISTS(l_tbl_index) THEN
18733: SELECT xle_etb.establishment_id
18734: INTO l_establishment_id
18735: FROM zx_party_tax_profile ptp,
18736: xle_etb_profiles xle_etb
18737: WHERE ptp.party_id = xle_etb.party_id
18738: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
18739: AND xle_etb.legal_entity_id = l_legal_entity_id