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_MOVE_VALIDATOR dependencies on MTL_SYSTEM_ITEMS

Line 476: FROM mtl_system_items msi,

472: AND wmti.transaction_type IN (WIP_CONSTANTS.COMP_TXN,
473: WIP_CONSTANTS.RET_TXN)
474: AND EXISTS
475: (SELECT 'X'
476: FROM mtl_system_items msi,
477: wip_discrete_jobs wdj
478: WHERE wdj.wip_entity_id = wmti.wip_entity_id
479: AND msi.inventory_item_id = wmti.primary_item_id
480: AND msi.organization_id = wmti.organization_id

Line 538: FROM mtl_system_items msi

534: AND wmti.transaction_type IN (WIP_CONSTANTS.COMP_TXN,
535: WIP_CONSTANTS.RET_TXN)
536: AND EXISTS
537: (SELECT 'X'
538: FROM mtl_system_items msi
539: WHERE msi.inventory_item_id = wmti.primary_item_id
540: AND msi.organization_id = wmti.organization_id
541: AND msi.revision_qty_control_code =
542: WIP_CONSTANTS.REVISION_CONTROLLED)

Line 590: FROM mtl_system_items msi

586: AND wmti.transaction_type IN (WIP_CONSTANTS.COMP_TXN,
587: WIP_CONSTANTS.RET_TXN)
588: AND EXISTS
589: (SELECT 'X'
590: FROM mtl_system_items msi
591: WHERE msi.inventory_item_id = wmti.primary_item_id
592: AND msi.organization_id = wmti.organization_id
593: AND msi.lot_control_code = WIP_CONSTANTS.LOT)
594: RETURNING wmti.transaction_id BULK COLLECT INTO enums;

Line 616: FROM mtl_system_items msi

612: AND wmti.transaction_type IN (WIP_CONSTANTS.COMP_TXN,
613: WIP_CONSTANTS.RET_TXN)
614: AND EXISTS
615: (SELECT 'X'
616: FROM mtl_system_items msi
617: WHERE msi.inventory_item_id = wmti.primary_item_id
618: AND msi.organization_id = wmti.organization_id
619: AND msi.lot_control_code = WIP_CONSTANTS.LOT)
620: AND EXISTS

Line 647: FROM mtl_system_items msi

643: WIP_CONSTANTS.LOTBASED)
644: AND wmti.transaction_type = WIP_CONSTANTS.COMP_TXN
645: AND EXISTS -- lot control
646: (SELECT 'X'
647: FROM mtl_system_items msi
648: WHERE msi.inventory_item_id = wmti.primary_item_id
649: AND msi.organization_id = wmti.organization_id
650: AND msi.lot_control_code = WIP_CONSTANTS.LOT)
651: -- This is the first time to complete this assembly to this lot number

Line 687: FROM mtl_system_items msi

683: WIP_CONSTANTS.LOTBASED)
684: AND wmti.transaction_type = WIP_CONSTANTS.COMP_TXN
685: AND EXISTS -- lot control and expiration date is user-defined
686: (SELECT 'X'
687: FROM mtl_system_items msi
688: WHERE msi.inventory_item_id = wmti.primary_item_id
689: AND msi.organization_id = wmti.organization_id
690: AND msi.lot_control_code = WIP_CONSTANTS.LOT
691: AND msi.shelf_life_code = WIP_CONSTANTS.USER_DEFINED_EXP)

Line 1568: mtl_system_items_kfv msik,

1564: wdj.completion_locator_id locID,
1565: mp.negative_inv_receipt_code negative_allow,
1566: msik.concatenated_segments assembly_name
1567: FROM wip_discrete_jobs wdj,
1568: mtl_system_items_kfv msik,
1569: mtl_parameters mp,
1570: wip_move_txn_interface wmti
1571: WHERE wdj.primary_item_id = msik.inventory_item_id
1572: AND wdj.organization_id = msik.organization_id

Line 1616: mtl_system_items_kfv msik,

1612: mp.negative_inv_receipt_code negative_allow,
1613: msik.concatenated_segments assembly_name
1614: FROM wip_repetitive_schedules wrs,
1615: wip_repetitive_items wri,
1616: mtl_system_items_kfv msik,
1617: mtl_parameters mp,
1618: wip_move_txn_interface wmti
1619: WHERE wmti.primary_item_id = msik.inventory_item_id
1620: AND wmti.organization_id = msik.organization_id

Line 1918: FROM mtl_system_items msi

1914: -- Derive PRIMARY_UOM from PRIMARY_ITEM_ID provided if PRIMARY_UOM is null
1915: UPDATE wip_move_txn_interface wmti
1916: SET wmti.primary_uom =
1917: (SELECT msi.primary_uom_code
1918: FROM mtl_system_items msi
1919: WHERE msi.organization_id = wmti.organization_id
1920: AND msi.inventory_item_id = wmti.primary_item_id)
1921: WHERE wmti.group_id = g_group_id
1922: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL

Line 1961: mtl_system_items msi

1957: wmti.program_application_id,
1958: wmti.program_id,
1959: wmti.program_update_date
1960: FROM wip_move_txn_interface wmti,
1961: mtl_system_items msi
1962: WHERE msi.organization_id = wmti.organization_id
1963: AND msi.inventory_item_id = wmti.primary_item_id
1964: AND wmti.group_id = g_group_id
1965: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL

Line 2828: FROM mtl_system_items msi

2824: AND wmti.transaction_type IN (WIP_CONSTANTS.RET_TXN,
2825: WIP_CONSTANTS.COMP_TXN)
2826: AND EXISTS -- Item flag was not set properly.
2827: (SELECT 'X'
2828: FROM mtl_system_items msi
2829: WHERE msi.inventory_item_id = wmti.primary_item_id
2830: AND msi.organization_id = wmti.organization_id
2831: AND (msi.inventory_item_flag = 'N' OR
2832: msi.mtl_transactions_enabled_flag = 'N'))