DBA Data[Home] [Help]

APPS.INV_ITEM_INQ dependencies on MTL_SYSTEM_ITEMS_B

Line 1538: mtl_system_items_b msik

1534: FROM mtl_material_statuses_vl mmst,
1535: mtl_serial_numbers_temp msnt,
1536: mtl_material_transactions_temp mmtt,
1537: mtl_transaction_lots_temp mtlt,
1538: mtl_system_items_b msik
1539: WHERE mmtt.organization_id = p_organization_id
1540: AND mmtt.inventory_item_id = p_inventory_item_id
1541: AND msik.organization_id = mmtt.organization_id
1542: AND msik.inventory_item_id = mmtt.inventory_item_id

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

1547: ELSE
1548: /* All other Contexts */
1549: OPEN x_serial_attributes FOR
1550: SELECT mmst.status_code, msik.serial_status_enabled, mmst.status_id
1551: FROM mtl_material_statuses_vl mmst, mtl_serial_numbers msn, mtl_system_items_b msik
1552: WHERE msn.current_organization_id = p_organization_id
1553: AND msn.inventory_item_id = p_inventory_item_id
1554: AND msik.organization_id = msn.current_organization_id
1555: AND msik.inventory_item_id = msn.inventory_item_id