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 10866: AND l_instance_csr.owner_party_source_table = 'HZ_PARTIES')

10862: l_exists := 'N';
10863: --
10864: IF ( l_instance_csr.owner_party_id IS NOT NULL
10865: AND l_instance_csr.owner_party_id <> l_internal_party_id
10866: AND l_instance_csr.owner_party_source_table = 'HZ_PARTIES')
10867: OR ( l_instance_csr.owner_party_id IS NOT NULL
10868: AND l_instance_csr.owner_party_id = l_internal_party_id
10869: AND p_transaction_type in ('TRM','RET')
10870: AND l_instance_csr.owner_party_source_table = 'HZ_PARTIES')

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

10866: AND l_instance_csr.owner_party_source_table = 'HZ_PARTIES')
10867: OR ( l_instance_csr.owner_party_id IS NOT NULL
10868: AND l_instance_csr.owner_party_id = l_internal_party_id
10869: AND p_transaction_type in ('TRM','RET')
10870: AND l_instance_csr.owner_party_source_table = 'HZ_PARTIES')
10871: THEN
10872: IF p_source_transaction_date IS NULL OR p_source_transaction_date = fnd_api.g_miss_date THEN
10873: l_transaction_date:= SYSDATE;
10874: ELSE

Line 11008: l_new_instance_csr.owner_party_source_table = 'HZ_PARTIES' THEN

11004: CLOSE instance_csr;
11005: --
11006: IF l_new_instance_csr.owner_party_id IS NOT NULL AND
11007: l_new_instance_csr.owner_party_id <> l_internal_party_id AND
11008: l_new_instance_csr.owner_party_source_table = 'HZ_PARTIES' THEN
11009: l_call_contracts := TRUE;
11010: p_oks_txn_inst_tbl(l_oks_txn_count).new_customer_product_id := p_new_instance_id;
11011: p_oks_txn_inst_tbl(l_oks_txn_count).new_quantity := l_new_instance_csr.quantity;
11012: p_oks_txn_inst_tbl(l_oks_txn_count).new_unit_of_measure :=

Line 11273: l_new_instance_csr.owner_party_source_table = 'HZ_PARTIES' THEN

11269: CLOSE instance_csr;
11270: --
11271: IF l_new_instance_csr.owner_party_id IS NOT NULL AND
11272: l_new_instance_csr.owner_party_id <> l_internal_party_id AND
11273: l_new_instance_csr.owner_party_source_table = 'HZ_PARTIES' THEN
11274: l_call_contracts := TRUE;
11275: p_oks_txn_inst_tbl(l_oks_txn_count).new_customer_product_id := p_new_instance_id;
11276: p_oks_txn_inst_tbl(l_oks_txn_count).new_quantity := l_new_instance_csr.quantity;
11277: p_oks_txn_inst_tbl(l_oks_txn_count).new_unit_of_measure := l_new_instance_csr.unit_of_measure;