DBA Data[Home] [Help]

APPS.INV_ITEM_INQ dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1410: mtl_system_items_kfv msik,

1406: OPEN x_lot_attributes FOR
1407: SELECT mmst.status_code, mmst.status_id,
1408: msik.shelf_life_code, msik.lot_status_enabled, mtlt.lot_expiration_date
1409: FROM mtl_material_statuses_vl mmst,
1410: mtl_system_items_kfv msik,
1411: mtl_transaction_lots_temp mtlt,
1412: mtl_material_transactions_temp mmtt
1413: WHERE mtlt.lot_number = p_lot_number
1414: AND mmtt.organization_id = p_organization_id

Line 1425: mtl_system_items_kfv msik,

1421: OPEN x_lot_attributes FOR
1422: SELECT mmst.status_code, mmst.status_id,
1423: msik.shelf_life_code, msik.lot_status_enabled, mln.expiration_date
1424: FROM mtl_material_statuses_vl mmst,
1425: mtl_system_items_kfv msik,
1426: mtl_lot_numbers mln
1427: WHERE mln.lot_number = p_lot_number
1428: AND mln.organization_id = p_organization_id
1429: AND msik.inventory_item_id = p_inventory_item_id