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 1636: mtl_system_items_kfv msik,

1632: wdj.completion_locator_id locID,
1633: mp.negative_inv_receipt_code negative_allow,
1634: msik.concatenated_segments assembly_name
1635: FROM wip_discrete_jobs wdj,
1636: mtl_system_items_kfv msik,
1637: mtl_parameters mp,
1638: wip_move_txn_interface wmti
1639: WHERE wdj.primary_item_id = msik.inventory_item_id
1640: AND wdj.organization_id = msik.organization_id

Line 1684: mtl_system_items_kfv msik,

1680: mp.negative_inv_receipt_code negative_allow,
1681: msik.concatenated_segments assembly_name
1682: FROM wip_repetitive_schedules wrs,
1683: wip_repetitive_items wri,
1684: mtl_system_items_kfv msik,
1685: mtl_parameters mp,
1686: wip_move_txn_interface wmti
1687: WHERE wmti.primary_item_id = msik.inventory_item_id
1688: AND wmti.organization_id = msik.organization_id

Line 1986: FROM mtl_system_items msi

1982: -- Derive PRIMARY_UOM from PRIMARY_ITEM_ID provided if PRIMARY_UOM is null
1983: UPDATE wip_move_txn_interface wmti
1984: SET wmti.primary_uom =
1985: (SELECT msi.primary_uom_code
1986: FROM mtl_system_items msi
1987: WHERE msi.organization_id = wmti.organization_id
1988: AND msi.inventory_item_id = wmti.primary_item_id)
1989: WHERE wmti.group_id = g_group_id
1990: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL

Line 2029: mtl_system_items msi

2025: wmti.program_application_id,
2026: wmti.program_id,
2027: wmti.program_update_date
2028: FROM wip_move_txn_interface wmti,
2029: mtl_system_items msi
2030: WHERE msi.organization_id = wmti.organization_id
2031: AND msi.inventory_item_id = wmti.primary_item_id
2032: AND wmti.group_id = g_group_id
2033: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL

Line 2896: FROM mtl_system_items msi

2892: AND wmti.transaction_type IN (WIP_CONSTANTS.RET_TXN,
2893: WIP_CONSTANTS.COMP_TXN)
2894: AND EXISTS -- Item flag was not set properly.
2895: (SELECT 'X'
2896: FROM mtl_system_items msi
2897: WHERE msi.inventory_item_id = wmti.primary_item_id
2898: AND msi.organization_id = wmti.organization_id
2899: AND (msi.inventory_item_flag = 'N' OR
2900: msi.mtl_transactions_enabled_flag = 'N'))