DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEMS_PKG dependencies on ENG_CHANGE_STATUSES

Line 722: FROM eng_change_statuses ecsb

718: AND (eri.status_type = 1
719: OR (eri.status_type = 10
720: AND EXISTS
721: (SELECT 1
722: FROM eng_change_statuses ecsb
723: WHERE ecsb.status_code = eri.status_code
724: AND ecsb.status_type = 1)))
725: AND nvl(eri.new_item_revision_id, eri.current_item_revision_id)
726: = nvl(p_revision_id, nvl(eri.new_item_revision_id, eri.current_item_revision_id))

Line 981: FROM eng_change_statuses ecsb

977: AND (eri.status_type = 1
978: OR (eri.status_type = 10
979: AND EXISTS
980: (SELECT 1
981: FROM eng_change_statuses ecsb
982: WHERE ecsb.status_code = eri.status_code
983: AND ecsb.status_type = 1)))
984: -- 3: common bom for src pending changes
985: AND bcb.bill_sequence_id = eri.bill_sequence_id;