APPS.BOMPCMBM dependencies on ENG_REVISED_ITEMS

Line 2365: FROM eng_revised_items

2361: WHERE old_component_sequence_id = p_src_comp_Seq_id
2362: AND implementation_date IS NULL
2363: AND nvl(common_component_sequence_id, component_sequence_id) <> component_sequence_id
2364: AND bill_sequence_id NOT IN (SELECT bill_sequence_id
2365: FROM eng_revised_items
2366: WHERE change_notice = bic.change_notice);
2367:
2368: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2369:

Line 4375: FROM eng_revised_items

4371:
4372: BEGIN
4373: SELECT bill_Sequence_id
4374: INTO l_rev_itm_bill_seq
4375: FROM eng_revised_items
4376: WHERE revised_item_sequence_id = p_rev_item_seq_id;
4377: EXCEPTION
4378: WHEN NO_DATA_FOUND THEN
4379: NULL;

Line 4400: SELECT 1 from eng_revised_items eri

4396: implementation_date is not null and p_change_notice is null
4397: OR
4398: (implementation_date is null and change_notice = p_change_notice
4399: AND EXISTS(
4400: SELECT 1 from eng_revised_items eri
4401: where eri.revised_item_sequence_id = bic.revised_item_sequence_id
4402: and eri.bill_Sequence_id = l_rev_itm_bill_seq
4403: )
4404: )

Line 4431: SELECT 1 from eng_revised_items eri

4427: implementation_date is not null and p_change_notice is null
4428: OR
4429: (implementation_date is null and change_notice = p_change_notice
4430: AND EXISTS(
4431: SELECT 1 from eng_revised_items eri
4432: where eri.revised_item_sequence_id = bic.revised_item_sequence_id
4433: and eri.bill_Sequence_id = bic.bill_Sequence_id
4434: )
4435: )

Line 4549: AND EXISTS (SELECT 1 FROM eng_revised_items eri

4545: AND bcb.bill_sequence_id = cp_bill_sequence_id
4546: AND bcb.implementation_date IS NULL
4547: -- The following exists clause is to ensure that the pending component is not a source
4548: -- referenced component but the one actually created for the destination bill itself
4549: AND EXISTS (SELECT 1 FROM eng_revised_items eri
4550: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
4551: AND eri.change_notice= bcb.change_notice
4552: AND eri.bill_sequence_id = bcb.bill_sequence_id)
4553: ORDER BY change_notice, revised_item_sequence_id;