DBA Data[Home] [Help]

APPS.EGO_ICC_STRUCTURE_PVT dependencies on ENG_REVISED_ITEMS

Line 1533: AND EXISTS( SELECT 1 from eng_revised_items eri

1529: FROM mtl_item_revisions_b WHERE revision_id = TO_OBJECT_REVISION_ID))))
1530: AND (change_notice is not null
1531: and( implementation_date is not null and P_changeNotice is null OR
1532: (implementation_date is null and change_notice = P_changeNotice
1533: AND EXISTS( SELECT 1 from eng_revised_items eri
1534: where eri.revised_item_sequence_id = bic.revised_item_sequence_id
1535: and eri.bill_Sequence_id = bic.bill_Sequence_id )))
1536: OR (change_notice is null and P_changeNotice is null))
1537: AND (( EXISTS (SELECT null FROM mtl_item_revisions_b