DBA Data[Home] [Help]

APPS.CSI_DEBUG_PKG dependencies on MTL_SYSTEM_ITEMS

Line 195: FROM mtl_system_items_vl

191: l_item_rec.wip_supply_type,
192: l_item_rec.make_buy_code,
193: l_item_rec.inventory_flag,
194: l_item_rec.inv_transactable_flag
195: FROM mtl_system_items_vl
196: WHERE inventory_item_id = p_item_id
197: AND organization_id = p_organization_id;
198:
199: cache_item_rec(p_item_rec => l_item_rec);

Line 1607: mtl_system_items msi

1603:
1604: CURSOR wip_txn_cur(p_wip_entity_id IN number, p_organization_id IN number) IS
1605: SELECT mmt.transaction_id
1606: FROM mtl_material_transactions mmt,
1607: mtl_system_items msi
1608: WHERE mmt.transaction_source_type_id = 5
1609: AND mmt.organization_id = p_organization_id
1610: AND mmt.transaction_source_id = p_wip_entity_id
1611: AND msi.inventory_item_id = mmt.inventory_item_id