DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEMS_PKG dependencies on ENG_CHANGE_STATUSES

Line 745: FROM eng_change_statuses ecsb

741: AND (eri.status_type = 1
742: OR (eri.status_type = 10
743: AND EXISTS
744: (SELECT 1
745: FROM eng_change_statuses ecsb
746: WHERE ecsb.status_code = eri.status_code
747: AND ecsb.status_type = 1)))
748: AND nvl(eri.new_item_revision_id, eri.current_item_revision_id)
749: = nvl(p_revision_id, nvl(eri.new_item_revision_id, eri.current_item_revision_id))

Line 1004: FROM eng_change_statuses ecsb

1000: AND (eri.status_type = 1
1001: OR (eri.status_type = 10
1002: AND EXISTS
1003: (SELECT 1
1004: FROM eng_change_statuses ecsb
1005: WHERE ecsb.status_code = eri.status_code
1006: AND ecsb.status_type = 1)))
1007: -- 3: common bom for src pending changes
1008: AND bcb.bill_sequence_id = eri.bill_sequence_id;