APPS.BOM_REVISIONS dependencies on ENG_REVISED_ITEMS

Line 127: FROM MTL_ITEM_REVISIONS_B MIR, ENG_REVISED_ITEMS ERI

123: stmt_num NUMBER;
124:
125: CURSOR ECO_STATUS_ITEM_REV IS
126: SELECT REVISION,REVISION_LABEL,REVISION_ID
127: FROM MTL_ITEM_REVISIONS_B MIR, ENG_REVISED_ITEMS ERI
128: WHERE MIR.INVENTORY_ITEM_ID = item_id
129: AND MIR.ORGANIZATION_ID = org_id
130: AND MIR.EFFECTIVITY_DATE <= rev_date --Bug 3020310
131: AND MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)

Line 292: FROM MTL_ITEM_REVISIONS_B MIR, ENG_REVISED_ITEMS ERI

288: stmt_num NUMBER;
289:
290: CURSOR ECO_STATUS_ITEM_REV IS
291: SELECT REVISION
292: FROM MTL_ITEM_REVISIONS_B MIR, ENG_REVISED_ITEMS ERI
293: WHERE MIR.INVENTORY_ITEM_ID = item_id
294: AND MIR.ORGANIZATION_ID = org_id
295: AND MIR.EFFECTIVITY_DATE <= rev_date --Bug 3020310
296: AND MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)

Line 404: FROM MTL_ITEM_REVISIONS_B MIR, ENG_REVISED_ITEMS ERI

400: itm_rev VARCHAR2(3);
401:
402: CURSOR ECO_STATUS_ITEM_REV IS
403: SELECT REVISION
404: FROM MTL_ITEM_REVISIONS_B MIR, ENG_REVISED_ITEMS ERI
405: WHERE MIR.INVENTORY_ITEM_ID = item_id
406: AND MIR.ORGANIZATION_ID = org_id
407: AND MIR.EFFECTIVITY_DATE <= rev_date
408: AND MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)

Line 512: FROM MTL_ITEM_REVISIONS_B MIR, ENG_REVISED_ITEMS ERI

508: revision_id NUMBER;
509:
510: CURSOR ECO_STATUS_ITEM_REV IS
511: SELECT REVISION_ID
512: FROM MTL_ITEM_REVISIONS_B MIR, ENG_REVISED_ITEMS ERI
513: WHERE MIR.INVENTORY_ITEM_ID = item_id
514: AND MIR.ORGANIZATION_ID = org_id
515: AND MIR.EFFECTIVITY_DATE <= rev_date
516: AND MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)

Line 604: FROM MTL_RTG_ITEM_REVISIONS MIR, ENG_REVISED_ITEMS ERI

600:
601: -- Added Cursor for BUG 3940863
602: CURSOR ECO_STATUS_RTG_REV IS
603: SELECT PROCESS_REVISION
604: FROM MTL_RTG_ITEM_REVISIONS MIR, ENG_REVISED_ITEMS ERI
605: WHERE MIR.INVENTORY_ITEM_ID = item_id
606: AND MIR.ORGANIZATION_ID = org_id
607: AND MIR.EFFECTIVITY_DATE <= rev_date --Bug 3020310
608: AND MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)

Line 907: FROM ENG_REVISED_ITEMS B

903: AND REVISION = itm_rev
904: )
905: AND NOT EXISTS
906: ( SELECT 'X'
907: FROM ENG_REVISED_ITEMS B
908: WHERE A.REVISED_ITEM_SEQUENCE_ID =
909: B.REVISED_ITEM_SEQUENCE_ID
910: AND
911: (