APPS.BOM_REVISIONS dependencies on ENG_REVISED_ITEMS

Line 125: FROM MTL_ITEM_REVISIONS_B MIR, ENG_REVISED_ITEMS ERI

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

Line 290: FROM MTL_ITEM_REVISIONS_B MIR, ENG_REVISED_ITEMS ERI

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

Line 401: FROM MTL_ITEM_REVISIONS_B MIR, ENG_REVISED_ITEMS ERI

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

Line 503: FROM MTL_ITEM_REVISIONS_B MIR, ENG_REVISED_ITEMS ERI

499: revision_id NUMBER;
500:
501: CURSOR ECO_STATUS_ITEM_REV IS
502: SELECT REVISION_ID
503: FROM MTL_ITEM_REVISIONS_B MIR, ENG_REVISED_ITEMS ERI
504: WHERE MIR.INVENTORY_ITEM_ID = item_id
505: AND MIR.ORGANIZATION_ID = org_id
506: AND MIR.EFFECTIVITY_DATE <= rev_date
507: AND MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)

Line 595: FROM MTL_RTG_ITEM_REVISIONS MIR, ENG_REVISED_ITEMS ERI

591:
592: -- Added Cursor for BUG 3940863
593: CURSOR ECO_STATUS_RTG_REV IS
594: SELECT PROCESS_REVISION
595: FROM MTL_RTG_ITEM_REVISIONS MIR, ENG_REVISED_ITEMS ERI
596: WHERE MIR.INVENTORY_ITEM_ID = item_id
597: AND MIR.ORGANIZATION_ID = org_id
598: AND MIR.EFFECTIVITY_DATE <= rev_date --Bug 3020310
599: AND MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)

Line 898: FROM ENG_REVISED_ITEMS B

894: AND REVISION = itm_rev
895: )
896: AND NOT EXISTS
897: ( SELECT 'X'
898: FROM ENG_REVISED_ITEMS B
899: WHERE A.REVISED_ITEM_SEQUENCE_ID =
900: B.REVISED_ITEM_SEQUENCE_ID
901: AND
902: (