eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_REVISIONS dependencies on MTL_ITEM_REVISIONS_B

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 147: FROM MTL_ITEM_REVISIONS_B MIR

143: ORDER BY MIR.EFFECTIVITY_DATE DESC, MIR.REVISION DESC;
144:
145: CURSOR NO_ECO_ITEM_REV IS
146: SELECT REVISION,REVISION_LABEL,REVISION_ID
147: FROM MTL_ITEM_REVISIONS_B MIR
148: WHERE INVENTORY_ITEM_ID = item_id
149: AND ORGANIZATION_ID = org_id
150: AND MIR.EFFECTIVITY_DATE <= rev_date --Bug 3020310
151: AND ( (examine_type = 'ALL')

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 312: FROM MTL_ITEM_REVISIONS_B MIR

308: ORDER BY MIR.EFFECTIVITY_DATE DESC, MIR.REVISION DESC;
309:
310: CURSOR NO_ECO_ITEM_REV IS
311: SELECT REVISION
312: FROM MTL_ITEM_REVISIONS_B MIR
313: WHERE INVENTORY_ITEM_ID = item_id
314: AND ORGANIZATION_ID = org_id
315: AND MIR.EFFECTIVITY_DATE <= rev_date --Bug 3020310
316: AND ( (examine_type = 'ALL')

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 419: FROM MTL_ITEM_REVISIONS_B MIR

415: ORDER BY MIR.EFFECTIVITY_DATE DESC, MIR.REVISION DESC;
416:
417: CURSOR NO_ECO_ITEM_REV IS
418: SELECT REVISION
419: FROM MTL_ITEM_REVISIONS_B MIR
420: WHERE INVENTORY_ITEM_ID = item_id
421: AND ORGANIZATION_ID = org_id
422: AND MIR.EFFECTIVITY_DATE <= rev_date
423: AND ( (examine_type = 'ALL')

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 521: FROM MTL_ITEM_REVISIONS_B MIR

517: ORDER BY MIR.EFFECTIVITY_DATE DESC, MIR.REVISION DESC;
518:
519: CURSOR NO_ECO_ITEM_REV IS
520: SELECT REVISION_ID
521: FROM MTL_ITEM_REVISIONS_B MIR
522: WHERE INVENTORY_ITEM_ID = item_id
523: AND ORGANIZATION_ID = org_id
524: AND MIR.EFFECTIVITY_DATE <= rev_date
525: AND ( (examine_type = 'ALL')

Line 798: FROM MTL_ITEM_REVISIONS_B

794: )
795: IS
796: CURSOR ITEM_REV IS
797: SELECT EFFECTIVITY_DATE
798: FROM MTL_ITEM_REVISIONS_B
799: WHERE INVENTORY_ITEM_ID = item_id
800: AND REVISION = itm_rev
801: AND ORGANIZATION_ID = org_id;
802:

Line 886: FROM MTL_ITEM_REVISIONS_B A

882: eco_status = 'EXCLUDE_ALL') THEN
883: stmt_num := 1;
884: SELECT MIN(A.EFFECTIVITY_DATE - 60/(60*60*24))
885: INTO l_rev_date
886: FROM MTL_ITEM_REVISIONS_B A
887: WHERE A.INVENTORY_ITEM_ID = item_id
888: AND A.ORGANIZATION_ID = org_id
889: AND A.EFFECTIVITY_DATE >
890: (SELECT EFFECTIVITY_DATE

Line 891: FROM MTL_ITEM_REVISIONS_B

887: WHERE A.INVENTORY_ITEM_ID = item_id
888: AND A.ORGANIZATION_ID = org_id
889: AND A.EFFECTIVITY_DATE >
890: (SELECT EFFECTIVITY_DATE
891: FROM MTL_ITEM_REVISIONS_B
892: WHERE INVENTORY_ITEM_ID = item_id
893: AND ORGANIZATION_ID = org_id
894: AND REVISION = itm_rev
895: )

Line 920: FROM MTL_ITEM_REVISIONS_B

916: ELSE
917: stmt_num := 2;
918: SELECT MIN(EFFECTIVITY_DATE - 60/(60*60*24))
919: INTO l_rev_date
920: FROM MTL_ITEM_REVISIONS_B
921: WHERE INVENTORY_ITEM_ID = item_id
922: AND ORGANIZATION_ID = org_id
923: AND EFFECTIVITY_DATE >
924: (SELECT EFFECTIVITY_DATE

Line 925: FROM MTL_ITEM_REVISIONS_B

921: WHERE INVENTORY_ITEM_ID = item_id
922: AND ORGANIZATION_ID = org_id
923: AND EFFECTIVITY_DATE >
924: (SELECT EFFECTIVITY_DATE
925: FROM MTL_ITEM_REVISIONS_B
926: WHERE INVENTORY_ITEM_ID = item_id
927: AND ORGANIZATION_ID = org_id
928: AND REVISION = itm_rev
929: );

Line 969: FROM MTL_ITEM_REVISIONS_B

965: IF (type = 'PART') THEN
966: stmt_num := 4;
967: SELECT GREATEST(EFFECTIVITY_DATE,SYSDATE)
968: INTO l_rev_date
969: FROM MTL_ITEM_REVISIONS_B
970: WHERE INVENTORY_ITEM_ID = item_id
971: AND ORGANIZATION_ID = org_id
972: AND REVISION = itm_rev;
973: ELSE

Line 1046: l_rev MTL_ITEM_REVISIONS_B.REVISION%TYPE;

1042: rev_date IN OUT NOCOPY DATE,
1043: itm_rev IN OUT NOCOPY VARCHAR2
1044: )
1045: IS
1046: l_rev MTL_ITEM_REVISIONS_B.REVISION%TYPE;
1047:
1048: CURSOR ITEM_REV IS
1049: SELECT REVISION
1050: FROM MTL_ITEM_REVISIONS_B

Line 1050: FROM MTL_ITEM_REVISIONS_B

1046: l_rev MTL_ITEM_REVISIONS_B.REVISION%TYPE;
1047:
1048: CURSOR ITEM_REV IS
1049: SELECT REVISION
1050: FROM MTL_ITEM_REVISIONS_B
1051: WHERE INVENTORY_ITEM_ID = item_id
1052: AND ORGANIZATION_ID = org_id
1053: AND (
1054: (examine_type = 'ALL')