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.WIP_MOVPROC_PRIV dependencies on BOM_REVISIONS

Line 5885: BOM_revisions.GET_ITEM_REVISION_FN

5881: DECODE(msi.revision_qty_control_code, -- item_revision
5882: 1, NULL,
5883: 2, DECODE(br.purchase_item_id,
5884: wdj.primary_item_id, wdj.bom_revision,
5885: BOM_revisions.GET_ITEM_REVISION_FN
5886: ('EXCLUDE_OPEN_HOLD', -- eco_status
5887: 'ALL', -- examine_type
5888: br.ORGANIZATION_ID, -- org_id
5889: br.purchase_item_id, -- item_id

Line 6098: BOM_revisions.GET_ITEM_REVISION_FN

6094: DECODE(msi.revision_qty_control_code, -- item_revision
6095: 1, NULL,
6096: 2, DECODE(br.purchase_item_id,
6097: we.primary_item_id, wrs.bom_revision,
6098: BOM_revisions.GET_ITEM_REVISION_FN
6099: ('EXCLUDE_OPEN_HOLD', -- eco_status
6100: 'ALL', -- examine_type
6101: br.ORGANIZATION_ID, -- org_id
6102: br.purchase_item_id, -- item_id

Line 6295: MAX(BOM_revisions.GET_ITEM_REVISION_FN

6291: DECODE(max(msi.revision_qty_control_code), -- item_revision
6292: 1, NULL,
6293: 2, DECODE(MAX(br.purchase_item_id),
6294: MAX(wdj.primary_item_id), MAX(wdj.bom_revision),
6295: MAX(BOM_revisions.GET_ITEM_REVISION_FN
6296: ('EXCLUDE_OPEN_HOLD', -- eco_status
6297: 'ALL', -- examine_type
6298: br.ORGANIZATION_ID, -- org_id
6299: br.purchase_item_id, -- item_id

Line 6526: MAX(BOM_revisions.GET_ITEM_REVISION_FN

6522: DECODE(MAX(msi.revision_qty_control_code), -- item_revision
6523: 1, NULL,
6524: 2, DECODE(MAX(br.purchase_item_id),
6525: MAX(we.primary_item_id), MAX(wrs.bom_revision),
6526: MAX(BOM_revisions.GET_ITEM_REVISION_FN
6527: ('EXCLUDE_OPEN_HOLD', -- eco_status
6528: 'ALL', -- examine_type
6529: br.ORGANIZATION_ID, -- org_id
6530: br.purchase_item_id, -- item_id

Line 8094: bom_revisions.get_item_revision_fn

8090: wmti.primary_item_id, -- inventory_item_id
8091: -- Fixed bug 2387630
8092: DECODE(msi.revision_qty_control_code,
8093: WIP_CONSTANTS.REV, NVL(wdj.bom_revision,
8094: bom_revisions.get_item_revision_fn
8095: ('EXCLUDE_OPEN_HOLD', -- eco_status
8096: 'ALL', -- examine_type
8097: wmti.organization_id, -- org_id
8098: wmti.primary_item_id, -- item_id

Line 8231: bom_revisions.get_item_revision_fn

8227: wmti.primary_item_id, -- inventory_item_id
8228: -- Fixed bug 2387630
8229: DECODE(msi.revision_qty_control_code, -- revision
8230: WIP_CONSTANTS.REV, NVL(wrs.bom_revision,
8231: bom_revisions.get_item_revision_fn
8232: ('EXCLUDE_OPEN_HOLD', -- eco_status
8233: 'ALL', -- examine_type
8234: wmti.organization_id, -- org_id
8235: wmti.primary_item_id, -- item_id

Line 8604: bom_revisions.get_item_revision_fn

8600: wmti.reason_id,
8601: -- Fixed bug 2387630
8602: DECODE(msi.revision_qty_control_code, -- revision
8603: WIP_CONSTANTS.REV, NVL(wdj.bom_revision,
8604: bom_revisions.get_item_revision_fn
8605: ('EXCLUDE_OPEN_HOLD', -- eco_status
8606: 'ALL', -- examine_type
8607: wmti.organization_id, -- org_id
8608: wmti.primary_item_id, -- item_id

Line 8744: bom_revisions.get_item_revision_fn

8740: wmti.reason_id,
8741: -- Fixed bug 2387630
8742: DECODE(msi.revision_qty_control_code, -- revision
8743: WIP_CONSTANTS.REV, NVL(wrs.bom_revision,
8744: bom_revisions.get_item_revision_fn
8745: ('EXCLUDE_OPEN_HOLD', -- eco_status
8746: 'ALL', -- examine_type
8747: wmti.organization_id, -- org_id
8748: wmti.primary_item_id, -- item_id