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 490: mtl_item_revisions_b frm,

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

Line 491: mtl_item_revisions_b tom

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

Line 518: mtl_item_revisions_b frm,

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

Line 519: mtl_item_revisions_b tom

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

Line 538: FROM MTL_ITEM_REVISIONS_B mirb

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

Line 548: FROM MTL_ITEM_REVISIONS_B mirb

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

Line 1066: FROM MTL_ITEM_REVISIONS_B

1062: OR
1063: (
1064: (
1065: SELECT REVISION
1066: FROM MTL_ITEM_REVISIONS_B
1067: WHERE REVISION_ID = berd.FROM_REVISION_ID
1068: ) <=
1069: (
1070: SELECT

Line 1073: MTL_ITEM_REVISIONS_B mir

1069: (
1070: SELECT
1071: mir.REVISION
1072: FROM
1073: MTL_ITEM_REVISIONS_B mir
1074: WHERE
1075: mir.EFFECTIVITY_DATE =
1076: (
1077: SELECT

Line 1080: MTL_ITEM_REVISIONS_B mir1

1076: (
1077: SELECT
1078: MAX(mir1.EFFECTIVITY_DATE)
1079: FROM
1080: MTL_ITEM_REVISIONS_B mir1
1081: WHERE
1082: mir1.EFFECTIVITY_DATE <= TO_DATE(impl_date, 'YYYY/MM/DD HH24:MI:SS')
1083: AND mir1.INVENTORY_ITEM_ID = bsit.PARENT_ITEM_ID
1084: AND mir1.ORGANIZATION_ID = bsit.ORGANIZATION_ID

Line 1100: MTL_ITEM_REVISIONS_B mir

1096: (
1097: SELECT
1098: mir.REVISION
1099: FROM
1100: MTL_ITEM_REVISIONS_B mir
1101: WHERE
1102: mir.EFFECTIVITY_DATE =
1103: (
1104: SELECT

Line 1107: MTL_ITEM_REVISIONS_B mir1

1103: (
1104: SELECT
1105: MAX(mir1.EFFECTIVITY_DATE)
1106: FROM
1107: MTL_ITEM_REVISIONS_B mir1
1108: WHERE
1109: mir1.EFFECTIVITY_DATE <= TO_DATE(impl_date, 'YYYY/MM/DD HH24:MI:SS')
1110: AND mir1.INVENTORY_ITEM_ID = bsit.PARENT_ITEM_ID
1111: AND mir1.ORGANIZATION_ID = bsit.ORGANIZATION_ID

Line 1118: FROM MTL_ITEM_REVISIONS_B

1114: AND mir.ORGANIZATION_ID = bsit.ORGANIZATION_ID
1115: ) <=
1116: (
1117: SELECT REVISION
1118: FROM MTL_ITEM_REVISIONS_B
1119: WHERE REVISION_ID = berd.TO_REVISION_ID
1120: )
1121: )
1122: )