APPS.WMS_WIP_INTEGRATION dependencies on MTL_SYSTEM_ITEMS

Line 1892: FROM mtl_system_items

1888:
1889: BEGIN
1890: SELECT lot_control_code, shelf_life_code
1891: INTO l_lot_control_code, l_shelf_life_code
1892: FROM mtl_system_items
1893: WHERE inventory_item_id = l_item_id
1894: AND organization_id = l_org_id;
1895:
1896: IF l_lot_control_code = 1 THEN

Line 2194: mtl_system_items_kfv msik,

2190: wip_requirement_operations wro,
2191: wip_repetitive_schedules wrs,
2192: mtl_txn_request_lines mtrl,
2193: mtl_material_transactions_temp mmtt,
2194: mtl_system_items_kfv msik,
2195: wip_entities we
2196: WHERE msik.inventory_item_id = we.primary_item_id
2197: AND msik.organization_id = we.organization_id
2198: AND we.wip_entity_id = wrs.wip_entity_id

Line 2415: mtl_system_items_kfv msik,

2411: bom_departments bd,
2412: wip_requirement_operations wro,
2413: wip_repetitive_schedules wrs,
2414: mtl_material_transactions_temp mmtt,
2415: mtl_system_items_kfv msik,
2416: wip_entities we
2417: WHERE msik.inventory_item_id = we.primary_item_id
2418: AND msik.organization_id = we.organization_id
2419: AND we.wip_entity_id = wrs.wip_entity_id

Line 2626: mtl_system_items msi,

2622: l_xfr_lpn_id,
2623: l_content_lpn_id,
2624: l_lpn_controlled_flag
2625: FROM
2626: mtl_system_items msi,
2627: mtl_material_transactions_temp mmtt,
2628: mtl_secondary_inventories msin
2629: WHERE mmtt.transaction_temp_id = p_temp_id
2630: AND mmtt.organization_id = msi.organization_id