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

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

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

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

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

424: ORDER BY MIR.EFFECTIVITY_DATE DESC, MIR.REVISION DESC;
425:
426: CURSOR NO_ECO_ITEM_REV IS
427: SELECT REVISION
428: FROM MTL_ITEM_REVISIONS_B MIR
429: WHERE INVENTORY_ITEM_ID = item_id
430: AND ORGANIZATION_ID = org_id
431: AND MIR.EFFECTIVITY_DATE <= rev_date
432: AND ( (examine_type = 'ALL')

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

526: ORDER BY MIR.EFFECTIVITY_DATE DESC, MIR.REVISION DESC;
527:
528: CURSOR NO_ECO_ITEM_REV IS
529: SELECT REVISION_ID
530: FROM MTL_ITEM_REVISIONS_B MIR
531: WHERE INVENTORY_ITEM_ID = item_id
532: AND ORGANIZATION_ID = org_id
533: AND MIR.EFFECTIVITY_DATE <= rev_date
534: AND ( (examine_type = 'ALL')

Line 807: FROM MTL_ITEM_REVISIONS_B

803: )
804: IS
805: CURSOR ITEM_REV IS
806: SELECT EFFECTIVITY_DATE
807: FROM MTL_ITEM_REVISIONS_B
808: WHERE INVENTORY_ITEM_ID = item_id
809: AND REVISION = itm_rev
810: AND ORGANIZATION_ID = org_id;
811:

Line 895: FROM MTL_ITEM_REVISIONS_B A

891: eco_status = 'EXCLUDE_ALL') THEN
892: stmt_num := 1;
893: SELECT MIN(A.EFFECTIVITY_DATE - 60/(60*60*24))
894: INTO l_rev_date
895: FROM MTL_ITEM_REVISIONS_B A
896: WHERE A.INVENTORY_ITEM_ID = item_id
897: AND A.ORGANIZATION_ID = org_id
898: AND A.EFFECTIVITY_DATE >
899: (SELECT EFFECTIVITY_DATE

Line 900: FROM MTL_ITEM_REVISIONS_B

896: WHERE A.INVENTORY_ITEM_ID = item_id
897: AND A.ORGANIZATION_ID = org_id
898: AND A.EFFECTIVITY_DATE >
899: (SELECT EFFECTIVITY_DATE
900: FROM MTL_ITEM_REVISIONS_B
901: WHERE INVENTORY_ITEM_ID = item_id
902: AND ORGANIZATION_ID = org_id
903: AND REVISION = itm_rev
904: )

Line 929: FROM MTL_ITEM_REVISIONS_B

925: ELSE
926: stmt_num := 2;
927: SELECT MIN(EFFECTIVITY_DATE - 60/(60*60*24))
928: INTO l_rev_date
929: FROM MTL_ITEM_REVISIONS_B
930: WHERE INVENTORY_ITEM_ID = item_id
931: AND ORGANIZATION_ID = org_id
932: AND EFFECTIVITY_DATE >
933: (SELECT EFFECTIVITY_DATE

Line 934: FROM MTL_ITEM_REVISIONS_B

930: WHERE INVENTORY_ITEM_ID = item_id
931: AND ORGANIZATION_ID = org_id
932: AND EFFECTIVITY_DATE >
933: (SELECT EFFECTIVITY_DATE
934: FROM MTL_ITEM_REVISIONS_B
935: WHERE INVENTORY_ITEM_ID = item_id
936: AND ORGANIZATION_ID = org_id
937: AND REVISION = itm_rev
938: );

Line 978: FROM MTL_ITEM_REVISIONS_B

974: IF (type = 'PART') THEN
975: stmt_num := 4;
976: SELECT GREATEST(EFFECTIVITY_DATE,SYSDATE)
977: INTO l_rev_date
978: FROM MTL_ITEM_REVISIONS_B
979: WHERE INVENTORY_ITEM_ID = item_id
980: AND ORGANIZATION_ID = org_id
981: AND REVISION = itm_rev;
982: ELSE

Line 1055: l_rev MTL_ITEM_REVISIONS_B.REVISION%TYPE;

1051: rev_date IN OUT NOCOPY DATE,
1052: itm_rev IN OUT NOCOPY VARCHAR2
1053: )
1054: IS
1055: l_rev MTL_ITEM_REVISIONS_B.REVISION%TYPE;
1056:
1057: CURSOR ITEM_REV IS
1058: SELECT REVISION
1059: FROM MTL_ITEM_REVISIONS_B

Line 1059: FROM MTL_ITEM_REVISIONS_B

1055: l_rev MTL_ITEM_REVISIONS_B.REVISION%TYPE;
1056:
1057: CURSOR ITEM_REV IS
1058: SELECT REVISION
1059: FROM MTL_ITEM_REVISIONS_B
1060: WHERE INVENTORY_ITEM_ID = item_id
1061: AND ORGANIZATION_ID = org_id
1062: AND (
1063: (examine_type = 'ALL')