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 6014: BOM_revisions.GET_ITEM_REVISION_FN

6010: DECODE(msi.revision_qty_control_code, -- item_revision
6011: 1, NULL,
6012: 2, DECODE(br.purchase_item_id,
6013: wdj.primary_item_id, wdj.bom_revision,
6014: BOM_revisions.GET_ITEM_REVISION_FN
6015: ('EXCLUDE_OPEN_HOLD', -- eco_status
6016: 'ALL', -- examine_type
6017: br.ORGANIZATION_ID, -- org_id
6018: br.purchase_item_id, -- item_id

Line 6234: BOM_revisions.GET_ITEM_REVISION_FN

6230: DECODE(msi.revision_qty_control_code, -- item_revision
6231: 1, NULL,
6232: 2, DECODE(br.purchase_item_id,
6233: we.primary_item_id, wrs.bom_revision,
6234: BOM_revisions.GET_ITEM_REVISION_FN
6235: ('EXCLUDE_OPEN_HOLD', -- eco_status
6236: 'ALL', -- examine_type
6237: br.ORGANIZATION_ID, -- org_id
6238: br.purchase_item_id, -- item_id

Line 6438: MAX(BOM_revisions.GET_ITEM_REVISION_FN

6434: DECODE(max(msi.revision_qty_control_code), -- item_revision
6435: 1, NULL,
6436: 2, DECODE(MAX(br.purchase_item_id),
6437: MAX(wdj.primary_item_id), MAX(wdj.bom_revision),
6438: MAX(BOM_revisions.GET_ITEM_REVISION_FN
6439: ('EXCLUDE_OPEN_HOLD', -- eco_status
6440: 'ALL', -- examine_type
6441: br.ORGANIZATION_ID, -- org_id
6442: br.purchase_item_id, -- item_id

Line 6676: MAX(BOM_revisions.GET_ITEM_REVISION_FN

6672: DECODE(MAX(msi.revision_qty_control_code), -- item_revision
6673: 1, NULL,
6674: 2, DECODE(MAX(br.purchase_item_id),
6675: MAX(we.primary_item_id), MAX(wrs.bom_revision),
6676: MAX(BOM_revisions.GET_ITEM_REVISION_FN
6677: ('EXCLUDE_OPEN_HOLD', -- eco_status
6678: 'ALL', -- examine_type
6679: br.ORGANIZATION_ID, -- org_id
6680: br.purchase_item_id, -- item_id

Line 8305: bom_revisions.get_item_revision_fn

8301: wmti.primary_item_id, -- inventory_item_id
8302: -- Fixed bug 2387630
8303: DECODE(msi.revision_qty_control_code,
8304: WIP_CONSTANTS.REV, NVL(wdj.bom_revision,
8305: bom_revisions.get_item_revision_fn
8306: ('EXCLUDE_OPEN_HOLD', -- eco_status
8307: 'ALL', -- examine_type
8308: wmti.organization_id, -- org_id
8309: wmti.primary_item_id, -- item_id

Line 8442: bom_revisions.get_item_revision_fn

8438: wmti.primary_item_id, -- inventory_item_id
8439: -- Fixed bug 2387630
8440: DECODE(msi.revision_qty_control_code, -- revision
8441: WIP_CONSTANTS.REV, NVL(wrs.bom_revision,
8442: bom_revisions.get_item_revision_fn
8443: ('EXCLUDE_OPEN_HOLD', -- eco_status
8444: 'ALL', -- examine_type
8445: wmti.organization_id, -- org_id
8446: wmti.primary_item_id, -- item_id

Line 8852: bom_revisions.get_item_revision_fn

8848: wmti.reason_id reason_id,
8849: -- Fixed bug 2387630
8850: DECODE(msi.revision_qty_control_code, -- revision
8851: WIP_CONSTANTS.REV, NVL(wdj.bom_revision,
8852: bom_revisions.get_item_revision_fn
8853: ('EXCLUDE_OPEN_HOLD', -- eco_status
8854: 'ALL', -- examine_type
8855: wmti.organization_id, -- org_id
8856: wmti.primary_item_id, -- item_id

Line 8999: bom_revisions.get_item_revision_fn

8995: wmti.reason_id reason_id,
8996: -- Fixed bug 2387630
8997: DECODE(msi.revision_qty_control_code, -- revision
8998: WIP_CONSTANTS.REV, NVL(wrs.bom_revision,
8999: bom_revisions.get_item_revision_fn
9000: ('EXCLUDE_OPEN_HOLD', -- eco_status
9001: 'ALL', -- examine_type
9002: wmti.organization_id, -- org_id
9003: wmti.primary_item_id, -- item_id