DBA Data[Home] [Help]

APPS.WSMPLBMI dependencies on MTL_SYSTEM_ITEMS_KFV

Line 5978: from bom_resource_equipments bre, mtl_system_items_kfv msik

5974: select decode(p_resource_serial_number,
5975: NULL, msik.concatenated_segments,
5976: msik.concatenated_segments||':'||p_resource_serial_number)
5977: into l_resource_instance
5978: from bom_resource_equipments bre, mtl_system_items_kfv msik
5979: where bre.inventory_item_id = msik.inventory_item_id
5980: and bre.organization_id = msik.organization_id
5981: and bre.resource_id = p_resource_id
5982: and bre.instance_id = p_resource_instance_id

Line 11601: mtl_system_items_kfv msik

11597: if(l_numErrRows <> 0) then
11598: select msik.concatenated_segments, mti.error_explanation
11599: bulk collect into l_itemNameTbl,l_errExplTbl
11600: from mtl_transactions_interface mti,
11601: mtl_system_items_kfv msik
11602: where mti.transaction_header_id = p_mtl_txn_hdr_id
11603: and mti.error_explanation is not null
11604: and mti.inventory_item_id = msik.inventory_item_id
11605: and mti.organization_id = msik.organization_id;