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_IMPLODER_PUB dependencies on MTL_ITEM_REVISIONS_B

Line 267: FROM MTL_ITEM_REVISIONS_B mirb

263: DECODE( BIC.FROM_END_ITEM_REV_ID
264: ,NULL ,NULL
265: ,(
266: SELECT mirb.REVISION
267: FROM MTL_ITEM_REVISIONS_B mirb
268: WHERE mirb.REVISION_ID = BIC.FROM_END_ITEM_REV_ID
269: ) ) FROM_END_ITEM_REVISION,
270: DECODE( BIC.TO_END_ITEM_REV_ID
271: ,NULL ,NULL

Line 274: FROM MTL_ITEM_REVISIONS_B mirb

270: DECODE( BIC.TO_END_ITEM_REV_ID
271: ,NULL ,NULL
272: ,(
273: SELECT mirb.REVISION
274: FROM MTL_ITEM_REVISIONS_B mirb
275: WHERE mirb.REVISION_ID = BIC.TO_END_ITEM_REV_ID
276: ) ) TO_END_ITEM_REVISION ,
277: BBM.EFFECTIVITY_CONTROL EFFECTIVITY_CONTROL
278: FROM

Line 404: MTL_ITEM_REVISIONS_B MIRB

400: BIC.FROM_END_ITEM_REV_ID IS NOT NULL
401: AND ( SELECT
402: MIRB.REVISION
403: FROM
404: MTL_ITEM_REVISIONS_B MIRB
405: WHERE
406: MIRB.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
407: AND MIRB.ORGANIZATION_ID = MSI.ORGANIZATION_ID
408: AND MIRB.REVISION_ID = BIC.FROM_END_ITEM_REV_ID

Line 413: MTL_ITEM_REVISIONS_B MIRB

409: ) <=
410: (SELECT
411: MAX(MIRB.REVISION)
412: FROM
413: MTL_ITEM_REVISIONS_B MIRB
414: WHERE
415: MIRB.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
416: AND MIRB.ORGANIZATION_ID = MSI.ORGANIZATION_ID
417: AND MIRB.EFFECTIVITY_DATE <= to_date(c_implosion_date, 'YYYY/MM/DD HH24:MI:SS') )

Line 426: MTL_ITEM_REVISIONS_B MIRB

422: OR
423: ( SELECT
424: MIRB.REVISION
425: FROM
426: MTL_ITEM_REVISIONS_B MIRB
427: WHERE
428: MIRB.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
429: AND MIRB.ORGANIZATION_ID = MSI.ORGANIZATION_ID
430: AND MIRB.REVISION_ID = BIC.TO_END_ITEM_REV_ID

Line 435: MTL_ITEM_REVISIONS_B MIRB

431: ) >=
432: (SELECT
433: MAX(MIRB.REVISION)
434: FROM
435: MTL_ITEM_REVISIONS_B MIRB
436: WHERE
437: MIRB.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
438: AND MIRB.ORGANIZATION_ID = MSI.ORGANIZATION_ID
439: AND MIRB.EFFECTIVITY_DATE <= to_date(c_implosion_date, 'YYYY/MM/DD HH24:MI:SS') )

Line 492: mtl_item_revisions_b frm,

488: )
489: )
490: ) disable_date
491: from
492: mtl_item_revisions_b frm,
493: mtl_item_revisions_b tom
494: where
495: frm.revision_id = bic.component_item_revision_id
496: and tom.revision_id(+) <> frm.revision_id

Line 493: mtl_item_revisions_b tom

489: )
490: ) disable_date
491: from
492: mtl_item_revisions_b frm,
493: mtl_item_revisions_b tom
494: where
495: frm.revision_id = bic.component_item_revision_id
496: and tom.revision_id(+) <> frm.revision_id
497: and frm.effectivity_date < tom.effectivity_date(+)

Line 520: mtl_item_revisions_b frm,

516: )
517: )
518: ) disable_date
519: from
520: mtl_item_revisions_b frm,
521: mtl_item_revisions_b tom
522: where
523: frm.revision_id = bic.component_item_revision_id
524: and tom.revision_id(+) <> frm.revision_id

Line 521: mtl_item_revisions_b tom

517: )
518: ) disable_date
519: from
520: mtl_item_revisions_b frm,
521: mtl_item_revisions_b tom
522: where
523: frm.revision_id = bic.component_item_revision_id
524: and tom.revision_id(+) <> frm.revision_id
525: and frm.effectivity_date < tom.effectivity_date(+)

Line 540: FROM MTL_ITEM_REVISIONS_B mirb

536: bitt.FROM_END_ITEM_REVISION IS NOT NULL
537: and bitt.FROM_END_ITEM_REVISION <=
538: (
539: SELECT mirb.REVISION
540: FROM MTL_ITEM_REVISIONS_B mirb
541: WHERE mirb.REVISION_ID = bic.COMPONENT_ITEM_REVISION_ID
542: )
543: )
544: and

Line 550: FROM MTL_ITEM_REVISIONS_B mirb

546: bitt.TO_END_ITEM_REVISION IS NULL
547: or bitt.TO_END_ITEM_REVISION >=
548: (
549: SELECT mirb.REVISION
550: FROM MTL_ITEM_REVISIONS_B mirb
551: WHERE mirb.REVISION_ID = bic.COMPONENT_ITEM_REVISION_ID
552: )
553: )
554: ) -- end of rev effective fixed rev parent

Line 1074: FROM MTL_ITEM_REVISIONS_B

1070: OR
1071: (
1072: (
1073: SELECT REVISION
1074: FROM MTL_ITEM_REVISIONS_B
1075: WHERE REVISION_ID = berd.FROM_REVISION_ID
1076: ) <=
1077: (
1078: SELECT

Line 1081: MTL_ITEM_REVISIONS_B mir

1077: (
1078: SELECT
1079: mir.REVISION
1080: FROM
1081: MTL_ITEM_REVISIONS_B mir
1082: WHERE
1083: mir.EFFECTIVITY_DATE =
1084: (
1085: SELECT

Line 1088: MTL_ITEM_REVISIONS_B mir1

1084: (
1085: SELECT
1086: MAX(mir1.EFFECTIVITY_DATE)
1087: FROM
1088: MTL_ITEM_REVISIONS_B mir1
1089: WHERE
1090: mir1.EFFECTIVITY_DATE <= TO_DATE(impl_date, 'YYYY/MM/DD HH24:MI:SS')
1091: AND mir1.INVENTORY_ITEM_ID = bsit.PARENT_ITEM_ID
1092: AND mir1.ORGANIZATION_ID = bsit.ORGANIZATION_ID

Line 1108: MTL_ITEM_REVISIONS_B mir

1104: (
1105: SELECT
1106: mir.REVISION
1107: FROM
1108: MTL_ITEM_REVISIONS_B mir
1109: WHERE
1110: mir.EFFECTIVITY_DATE =
1111: (
1112: SELECT

Line 1115: MTL_ITEM_REVISIONS_B mir1

1111: (
1112: SELECT
1113: MAX(mir1.EFFECTIVITY_DATE)
1114: FROM
1115: MTL_ITEM_REVISIONS_B mir1
1116: WHERE
1117: mir1.EFFECTIVITY_DATE <= TO_DATE(impl_date, 'YYYY/MM/DD HH24:MI:SS')
1118: AND mir1.INVENTORY_ITEM_ID = bsit.PARENT_ITEM_ID
1119: AND mir1.ORGANIZATION_ID = bsit.ORGANIZATION_ID

Line 1126: FROM MTL_ITEM_REVISIONS_B

1122: AND mir.ORGANIZATION_ID = bsit.ORGANIZATION_ID
1123: ) <=
1124: (
1125: SELECT REVISION
1126: FROM MTL_ITEM_REVISIONS_B
1127: WHERE REVISION_ID = berd.TO_REVISION_ID
1128: )
1129: )
1130: )