APPS.WIP_SO_RESERVATIONS dependencies on MTL_SYSTEM_ITEMS

Line 1448: FROM MTL_SYSTEM_ITEMS MSI,

1444: mmtt.demand_class,
1445: mtlt.lot_expiration_date,
1446: mmtt.transaction_temp_id,
1447: null --never an lpn associated with a non-lpn completion
1448: FROM MTL_SYSTEM_ITEMS MSI,
1449: MTL_TRANSACTION_LOTS_TEMP MTLT,
1450: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1451: WHERE mmtt.completion_transaction_id = cp_transaction_header_id
1452: AND mmtt.transaction_action_id = cp_transaction_action_id

Line 1560: FROM MTL_SYSTEM_ITEMS MSI,

1556: null,
1557: WLCL.lot_expiration_date,
1558: null,
1559: p_lpn_id
1560: FROM MTL_SYSTEM_ITEMS MSI,
1561: WIP_LPN_COMPLETIONS_LOTS WLCL,
1562: WIP_LPN_COMPLETIONS WLC
1563: WHERE wlc.header_id = cp_header_id
1564: AND wlc.transaction_source_type_id = 5 /* Job or Schedule */

Line 2051: from mtl_system_items msi

2047:
2048: x_return_status := FND_API.G_RET_STS_SUCCESS;
2049:
2050: select msi.replenish_to_order_flag into IS_ATO_ITEM
2051: from mtl_system_items msi
2052: where msi.organization_id = p_organization_id
2053: and msi.inventory_item_id = p_inventory_item_id;
2054:
2055: if (IS_ATO_ITEM = 'Y') then