APPS.CSI_ITEM_INSTANCE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 422: ,mtl_system_items msi

418: SELECT bet.component_item_id component_item_id
419: ,mp.master_organization_id master_organization_id
420: FROM bom_small_expl_temp bet
421: ,bom_bill_of_materials bom
422: ,mtl_system_items msi
423: ,mtl_system_items msip
424: ,mtl_parameters mp
425: WHERE bet.group_id = p_group_id
426: AND bet.plan_level > 0 -- Ignore Top Most

Line 423: ,mtl_system_items msip

419: ,mp.master_organization_id master_organization_id
420: FROM bom_small_expl_temp bet
421: ,bom_bill_of_materials bom
422: ,mtl_system_items msi
423: ,mtl_system_items msip
424: ,mtl_parameters mp
425: WHERE bet.group_id = p_group_id
426: AND bet.plan_level > 0 -- Ignore Top Most
427: AND bet.component_item_id = msi.inventory_item_id

Line 2586: FROM mtl_system_items_b_kfv msi

2582: THEN
2583: BEGIN
2584: SELECT msi.concatenated_segments
2585: INTO p_instance_header_tbl(tab_row).INVENTORY_ITEM_NAME
2586: FROM mtl_system_items_b_kfv msi
2587: ,csi_item_instances cii
2588: WHERE msi.inventory_item_id = p_instance_header_tbl(tab_row).inventory_item_id
2589: AND msi.organization_id = Nvl(p_instance_header_tbl(tab_row).vld_organization_id,cii.last_vld_organization_id)
2590: AND cii.instance_id = p_instance_header_tbl(tab_row).instance_id;

Line 2855: FROM mtl_system_items_b_kfv msi

2851: SELECT msi.concatenated_segments
2852: ,cii.instance_number
2853: INTO p_instance_header_tbl(tab_row).parent_asset_group
2854: ,p_instance_header_tbl(tab_row).parent_asset_number
2855: FROM mtl_system_items_b_kfv msi
2856: ,mtl_serial_numbers msn
2857: ,csi_item_instances cii
2858: ,mtl_object_genealogy mog
2859: WHERE msn.gen_object_id= mog.parent_object_id

Line 4931: from MTL_SYSTEM_ITEMS_B

4927: p_item_attribute_tbl(p_ins_count_rec.inv_count).master_organization_id := p_instance_rec.inv_master_organization_id;
4928: Begin
4929: select comms_nl_trackable_flag,primary_uom_code
4930: into l_trackable_flag,l_uom_code
4931: from MTL_SYSTEM_ITEMS_B
4932: where inventory_item_id = p_instance_rec.inventory_item_id
4933: and organization_id = p_instance_rec.inv_master_organization_id
4934: and enabled_flag = 'Y'
4935: and nvl (start_date_active, sysdate) <= sysdate

Line 4965: FROM mtl_system_items_b

4961: ,l_lot_control
4962: ,l_shelf_life_code
4963: ,l_eam_item_type
4964: ,l_equipment_type
4965: FROM mtl_system_items_b
4966: WHERE inventory_item_id = p_instance_rec.inventory_item_id
4967: AND organization_id = p_instance_rec.vld_organization_id
4968: AND enabled_flag = 'Y'
4969: AND nvl (start_date_active, sysdate) <= sysdate

Line 6236: from MTL_SYSTEM_ITEMS_B

6232: l_base_item_id := null;
6233: Begin
6234: select base_item_id
6235: into l_base_item_id
6236: from MTL_SYSTEM_ITEMS_B
6237: where inventory_item_id = p_instance_rec.inventory_item_id
6238: and organization_id = l_last_vld_organization_id;
6239: Exception
6240: when no_data_found then

Line 12896: FROM MTL_SYSTEM_ITEMS_B

12892: SELECT comms_nl_trackable_flag
12893: ,primary_uom_code
12894: INTO l_trackable_flag
12895: ,l_uom_code
12896: FROM MTL_SYSTEM_ITEMS_B
12897: WHERE inventory_item_id = l_get_instance_rec.inventory_item_id
12898: AND organization_id = l_get_instance_rec.inv_master_organization_id
12899: AND enabled_flag = 'Y'
12900: AND nvl (start_date_active, sysdate) <= sysdate

Line 12931: FROM MTL_SYSTEM_ITEMS_B

12927: ,l_lot_control
12928: ,l_shelf_life_code
12929: ,l_eam_item_type
12930: ,l_equipment_type
12931: FROM MTL_SYSTEM_ITEMS_B
12932: WHERE inventory_item_id = l_get_instance_rec.inventory_item_id
12933: AND organization_id = p_instance_rec.vld_organization_id
12934: AND enabled_flag = 'Y'
12935: AND nvl (start_date_active, sysdate) <= sysdate

Line 14546: FROM mtl_system_items

14542:
14543: BEGIN -- Bug 14163453
14544: SELECT nvl(shippable_item_flag,'N')
14545: INTO l_shippable_item_flag
14546: FROM mtl_system_items
14547: WHERE inventory_item_id = p_instance_rec.inventory_item_id
14548: AND organization_id = p_instance_rec.vld_organization_id;
14549: EXCEPTION
14550: WHEN NO_DATA_FOUND THEN

Line 14894: from MTL_SYSTEM_ITEMS_B

14890: l_base_item_id := null;
14891: Begin
14892: select base_item_id
14893: into l_base_item_id
14894: from MTL_SYSTEM_ITEMS_B
14895: where inventory_item_id = l_get_instance_rec.inventory_item_id
14896: and organization_id = l_last_vld_organization_id;
14897: Exception
14898: when no_data_found then

Line 22025: FROM mtl_system_items

22021: l_batch_id NUMBER;
22022: --
22023: CURSOR c1 is
22024: SELECT serial_number_control_code
22025: FROM mtl_system_items
22026: WHERE inventory_item_id = p_source_instance_rec.inventory_item_id
22027: AND organization_id = p_source_instance_rec.vld_organization_id
22028: AND enabled_flag = 'Y'
22029: AND nvl (start_date_active, sysdate) <= sysdate

Line 22498: FROM mtl_system_items

22494: )
22495: IS
22496: CURSOR c1 is
22497: SELECT serial_number_control_code
22498: FROM mtl_system_items
22499: WHERE inventory_item_id = p_source_instance_rec.inventory_item_id
22500: AND organization_id = p_source_instance_rec.vld_organization_id
22501: AND nvl(comms_nl_trackable_flag, 'N') = 'Y'
22502: AND enabled_flag = 'Y'

Line 29841: ,mtl_system_items msi

29837: ,msi.primary_uom_code primary_uom_code
29838: ,mp.master_organization_id master_organization_id
29839: FROM bom_small_expl_temp bet
29840: ,bom_bill_of_materials bom
29841: ,mtl_system_items msi
29842: ,mtl_system_items msip
29843: ,mtl_parameters mp
29844: WHERE bet.group_id = p_group_id
29845: AND bet.plan_level > 0 -- Ignore Top Most

Line 29842: ,mtl_system_items msip

29838: ,mp.master_organization_id master_organization_id
29839: FROM bom_small_expl_temp bet
29840: ,bom_bill_of_materials bom
29841: ,mtl_system_items msi
29842: ,mtl_system_items msip
29843: ,mtl_parameters mp
29844: WHERE bet.group_id = p_group_id
29845: AND bet.plan_level > 0 -- Ignore Top Most
29846: AND bet.component_item_id = msi.inventory_item_id