APPS.CSI_ITEM_INSTANCE_PVT dependencies on HZ_PARTIES

Line 2258: hz_parties hzp

2254: p_instance_header_tbl(tab_row).current_party_name,
2255: p_instance_header_tbl(tab_row).current_party_number
2256: FROM hz_locations hzl,
2257: hz_party_sites hps,
2258: hz_parties hzp
2259: WHERE hzl.location_id = hps.location_id(+) --(+)added for bug 5213645
2260: AND hps.party_id = hzp.party_id(+)
2261: AND hzl.location_id = p_instance_header_tbl(tab_row).location_id
2262: AND rownum < 2;

Line 2297: hz_parties hzp

2293: p_instance_header_tbl(tab_row).install_party_name,
2294: p_instance_header_tbl(tab_row).install_party_number
2295: FROM hz_locations hzl,
2296: hz_party_sites hps,
2297: hz_parties hzp
2298: WHERE hzl.location_id = hps.location_id(+) --(+)added for bug 5213645
2299: AND hps.party_id = hzp.party_id(+)
2300: AND hzl.location_id = p_instance_header_tbl(tab_row).install_location_id
2301: AND rownum < 2;

Line 2385: hz_parties hzp

2381: p_instance_header_tbl(tab_row).current_party_name,
2382: p_instance_header_tbl(tab_row).current_party_number
2383: FROM hz_locations hzl,
2384: hz_party_sites hps,
2385: hz_parties hzp
2386: WHERE hps.location_id = hzl.location_id
2387: AND hps.party_id = hzp.party_id
2388: AND hps.party_site_id = p_instance_header_tbl(tab_row).location_id;
2389:

Line 2423: hz_parties hzp

2419: p_instance_header_tbl(tab_row).install_party_name,
2420: p_instance_header_tbl(tab_row).install_party_number
2421: FROM hz_locations hzl,
2422: hz_party_sites hps,
2423: hz_parties hzp
2424: WHERE hps.location_id = hzl.location_id
2425: AND hps.party_id = hzp.party_id
2426: AND hps.party_site_id = p_instance_header_tbl(tab_row).install_location_id;
2427:

Line 11155: AND l_instance_csr.owner_party_source_table = 'HZ_PARTIES')

11151: l_exists := 'N'; -- Added for bug 13057871
11152:
11153: IF ( l_instance_csr.owner_party_id IS NOT NULL
11154: AND l_instance_csr.owner_party_id <> l_internal_party_id
11155: AND l_instance_csr.owner_party_source_table = 'HZ_PARTIES')
11156: OR ( l_instance_csr.owner_party_id IS NOT NULL
11157: AND l_instance_csr.owner_party_id = l_internal_party_id
11158: AND p_transaction_type in ('TRM','RET')
11159: AND l_instance_csr.owner_party_source_table = 'HZ_PARTIES')

Line 11159: AND l_instance_csr.owner_party_source_table = 'HZ_PARTIES')

11155: AND l_instance_csr.owner_party_source_table = 'HZ_PARTIES')
11156: OR ( l_instance_csr.owner_party_id IS NOT NULL
11157: AND l_instance_csr.owner_party_id = l_internal_party_id
11158: AND p_transaction_type in ('TRM','RET')
11159: AND l_instance_csr.owner_party_source_table = 'HZ_PARTIES')
11160: THEN
11161: IF p_source_transaction_date IS NULL OR p_source_transaction_date = fnd_api.g_miss_date THEN
11162: l_transaction_date:= SYSDATE;
11163: ELSE

Line 11297: l_new_instance_csr.owner_party_source_table = 'HZ_PARTIES' THEN

11293: CLOSE instance_csr;
11294: --
11295: IF l_new_instance_csr.owner_party_id IS NOT NULL AND
11296: l_new_instance_csr.owner_party_id <> l_internal_party_id AND
11297: l_new_instance_csr.owner_party_source_table = 'HZ_PARTIES' THEN
11298: l_call_contracts := TRUE;
11299: p_oks_txn_inst_tbl(l_oks_txn_count).new_customer_product_id := p_new_instance_id;
11300: p_oks_txn_inst_tbl(l_oks_txn_count).new_quantity := l_new_instance_csr.quantity;
11301: p_oks_txn_inst_tbl(l_oks_txn_count).new_unit_of_measure :=

Line 11562: l_new_instance_csr.owner_party_source_table = 'HZ_PARTIES' THEN

11558: CLOSE instance_csr;
11559: --
11560: IF l_new_instance_csr.owner_party_id IS NOT NULL AND
11561: l_new_instance_csr.owner_party_id <> l_internal_party_id AND
11562: l_new_instance_csr.owner_party_source_table = 'HZ_PARTIES' THEN
11563: l_call_contracts := TRUE;
11564: p_oks_txn_inst_tbl(l_oks_txn_count).new_customer_product_id := p_new_instance_id;
11565: p_oks_txn_inst_tbl(l_oks_txn_count).new_quantity := l_new_instance_csr.quantity;
11566: p_oks_txn_inst_tbl(l_oks_txn_count).new_unit_of_measure := l_new_instance_csr.unit_of_measure;