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.WMS_WIP_INTEGRATION dependencies on MTL_SYSTEM_ITEMS

Line 1862: FROM mtl_system_items

1858:
1859: BEGIN
1860: SELECT lot_control_code, shelf_life_code
1861: INTO l_lot_control_code, l_shelf_life_code
1862: FROM mtl_system_items
1863: WHERE inventory_item_id = l_item_id
1864: AND organization_id = l_org_id;
1865:
1866: IF l_lot_control_code = 1 THEN

Line 2164: mtl_system_items_kfv msik,

2160: wip_requirement_operations wro,
2161: wip_repetitive_schedules wrs,
2162: mtl_txn_request_lines mtrl,
2163: mtl_material_transactions_temp mmtt,
2164: mtl_system_items_kfv msik,
2165: wip_entities we
2166: WHERE msik.inventory_item_id = we.primary_item_id
2167: AND msik.organization_id = we.organization_id
2168: AND we.wip_entity_id = wrs.wip_entity_id

Line 2385: mtl_system_items_kfv msik,

2381: bom_departments bd,
2382: wip_requirement_operations wro,
2383: wip_repetitive_schedules wrs,
2384: mtl_material_transactions_temp mmtt,
2385: mtl_system_items_kfv msik,
2386: wip_entities we
2387: WHERE msik.inventory_item_id = we.primary_item_id
2388: AND msik.organization_id = we.organization_id
2389: AND we.wip_entity_id = wrs.wip_entity_id

Line 2596: mtl_system_items msi,

2592: l_xfr_lpn_id,
2593: l_content_lpn_id,
2594: l_lpn_controlled_flag
2595: FROM
2596: mtl_system_items msi,
2597: mtl_material_transactions_temp mmtt,
2598: mtl_secondary_inventories msin
2599: WHERE mmtt.transaction_temp_id = p_temp_id
2600: AND mmtt.organization_id = msi.organization_id