[Home] [Help]
1143:
1144: l_stmt_num := 153;
1145: -- bugfix 1765389
1146: -- Validation of p_primary_uom.
1147: -- If p_primary_uom in WLMTI is null, then populate it from mtl_system_items.
1148: -- ST : Serial Support Project ---
1149: -- Query up the serial number control code also in this existing query...
1150: SELECT msi.primary_uom_code,
1151: msi.serial_number_control_code
1150: SELECT msi.primary_uom_code,
1151: msi.serial_number_control_code
1152: INTO l_primary_uom,
1153: l_serial_ctrl_code
1154: FROM mtl_system_items msi,
1155: wip_discrete_jobs wdj
1156: WHERE wdj.wip_entity_id = l_wip_entity_id
1157: AND wdj.primary_item_id = msi.inventory_item_id
1158: AND msi.organization_id = wdj.organization_id;
5083:
5084: --***VJ Changed for Performance Upgrade***--
5085: SELECT msi.primary_uom_code
5086: INTO l_uom
5087: FROM mtl_system_items msi
5088: WHERE msi.inventory_item_id = l_primary_item_id
5089: AND msi.organization_id = p_org_id;
5090: --***VJ End Changes***--
5091: l_stmt_num := 495;
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
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;