DBA Data[Home] [Help]

APPS.CSI_INV_DISCREPANCY_PKG dependencies on MTL_SYSTEM_ITEMS

Line 182: mtl_system_items msi

178: , moq.lot_number lot_number
179: , msi.primary_uom_code primary_uom_code
180: , SUM(moq.transaction_quantity) onhand_qty
181: From
182: mtl_system_items msi
183: , mtl_onhand_quantities moq
184: Where msi.inventory_item_id = moq.inventory_item_id
185: And msi.organization_id = moq.organization_id
186: And msi.serial_number_control_code in (1,6) -- No Serial control and at SO Issue Items

Line 291: From MTL_SYSTEM_ITEMS

287: v_nl_trackable := 'N';
288: Begin
289: Select comms_nl_trackable_flag
290: Into v_nl_trackable
291: From MTL_SYSTEM_ITEMS
292: Where inventory_item_id = inventory_item_id_mig(i)
293: And organization_id = v_mast_org_id; -- check should it be org. id
294: Exception
295: When No_Data_Found Then

Line 575: FROM mtl_system_items msi,

571: msn.lot_number lot_number,
572: msi.primary_uom_code uom_code,
573: msi.serial_number_control_code serial_code,
574: msi.lot_control_code lot_code
575: FROM mtl_system_items msi,
576: mtl_serial_numbers msn,
577: mtl_system_items_kfv msk
578: WHERE msi.inventory_item_id = msn.inventory_item_id
579: AND msi.organization_id = msn.current_organization_id

Line 577: mtl_system_items_kfv msk

573: msi.serial_number_control_code serial_code,
574: msi.lot_control_code lot_code
575: FROM mtl_system_items msi,
576: mtl_serial_numbers msn,
577: mtl_system_items_kfv msk
578: WHERE msi.inventory_item_id = msn.inventory_item_id
579: AND msi.organization_id = msn.current_organization_id
580: AND msi.inventory_item_id = msk.inventory_item_id
581: AND msi.organization_id = msk.organization_id

Line 587: mtl_system_items msi_mast

583: AND msn.current_status = 3
584: AND EXISTS (
585: SELECT '1'
586: FROM mtl_parameters mp,
587: mtl_system_items msi_mast
588: WHERE mp.organization_id = msi.organization_id
589: AND msi_mast.inventory_item_id = msi.inventory_item_id
590: AND msi_mast.organization_id = mp.master_organization_id)
591: -- AND nvl(msi_mast.comms_nl_trackable_flag,'N') = 'Y') --commented to query all the non-trackable items

Line 744: FROM MTL_SYSTEM_ITEMS

740: v_nl_trackable := 'N';
741: BEGIN
742: SELECT comms_nl_trackable_flag
743: INTO v_nl_trackable
744: FROM MTL_SYSTEM_ITEMS
745: WHERE inventory_item_id = srl_rec.inventory_item_id
746: AND organization_id = v_mast_org_id;
747: EXCEPTION
748: WHEN no_data_found THEN

Line 811: FROM MTL_SYSTEM_ITEMS_KFV

807: --
808: BEGIN
809: SELECT concatenated_segments
810: INTO v_item_name
811: FROM MTL_SYSTEM_ITEMS_KFV
812: WHERE inventory_item_id = srl_rec.inventory_item_id
813: AND organization_id = srl_rec.organization_id;
814: EXCEPTION
815: WHEN no_data_found THEN