APPS.BOMPCMBM dependencies on ENG_REVISED_ITEMS

Line 2073: FROM eng_revised_items

2069: WHERE old_component_sequence_id = p_src_comp_Seq_id
2070: AND implementation_date IS NULL
2071: AND nvl(common_component_sequence_id, component_sequence_id) <> component_sequence_id
2072: AND bill_sequence_id NOT IN (SELECT bill_sequence_id
2073: FROM eng_revised_items
2074: WHERE change_notice = bic.change_notice);
2075:
2076: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2077:

Line 4027: FROM eng_revised_items

4023:
4024: BEGIN
4025: SELECT bill_Sequence_id
4026: INTO l_rev_itm_bill_seq
4027: FROM eng_revised_items
4028: WHERE revised_item_sequence_id = p_rev_item_seq_id;
4029: EXCEPTION
4030: WHEN NO_DATA_FOUND THEN
4031: NULL;

Line 4052: SELECT 1 from eng_revised_items eri

4048: implementation_date is not null and p_change_notice is null
4049: OR
4050: (implementation_date is null and change_notice = p_change_notice
4051: AND EXISTS(
4052: SELECT 1 from eng_revised_items eri
4053: where eri.revised_item_sequence_id = bic.revised_item_sequence_id
4054: and eri.bill_Sequence_id = l_rev_itm_bill_seq
4055: )
4056: )

Line 4083: SELECT 1 from eng_revised_items eri

4079: implementation_date is not null and p_change_notice is null
4080: OR
4081: (implementation_date is null and change_notice = p_change_notice
4082: AND EXISTS(
4083: SELECT 1 from eng_revised_items eri
4084: where eri.revised_item_sequence_id = bic.revised_item_sequence_id
4085: and eri.bill_Sequence_id = bic.bill_Sequence_id
4086: )
4087: )

Line 4201: AND EXISTS (SELECT 1 FROM eng_revised_items eri

4197: AND bcb.bill_sequence_id = cp_bill_sequence_id
4198: AND bcb.implementation_date IS NULL
4199: -- The following exists clause is to ensure that the pending component is not a source
4200: -- referenced component but the one actually created for the destination bill itself
4201: AND EXISTS (SELECT 1 FROM eng_revised_items eri
4202: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
4203: AND eri.change_notice= bcb.change_notice
4204: AND eri.bill_sequence_id = bcb.bill_sequence_id)
4205: ORDER BY change_notice, revised_item_sequence_id;