DBA Data[Home] [Help]

APPS.INV_ITEM_INQ dependencies on MTL_SYSTEM_ITEMS_B

Line 1462: mtl_system_items_b msik

1458: FROM mtl_material_statuses_vl mmst,
1459: mtl_serial_numbers_temp msnt,
1460: mtl_material_transactions_temp mmtt,
1461: mtl_transaction_lots_temp mtlt,
1462: mtl_system_items_b msik
1463: WHERE mmtt.organization_id = p_organization_id
1464: AND mmtt.inventory_item_id = p_inventory_item_id
1465: AND msik.organization_id = mmtt.organization_id
1466: AND msik.inventory_item_id = mmtt.inventory_item_id

Line 1475: FROM mtl_material_statuses_vl mmst, mtl_serial_numbers msn, mtl_system_items_b msik

1471: ELSE
1472: /* All other Contexts */
1473: OPEN x_serial_attributes FOR
1474: SELECT mmst.status_code, msik.serial_status_enabled, mmst.status_id
1475: FROM mtl_material_statuses_vl mmst, mtl_serial_numbers msn, mtl_system_items_b msik
1476: WHERE msn.current_organization_id = p_organization_id
1477: AND msn.inventory_item_id = p_inventory_item_id
1478: AND msik.organization_id = msn.current_organization_id
1479: AND msik.inventory_item_id = msn.inventory_item_id