APPS.CSI_ITEM_INSTANCE_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 2836: FROM mtl_system_items_b_kfv msi

2832: SELECT msi.concatenated_segments
2833: ,cii.instance_number
2834: INTO p_instance_header_tbl(tab_row).parent_asset_group
2835: ,p_instance_header_tbl(tab_row).parent_asset_number
2836: FROM mtl_system_items_b_kfv msi
2837: ,mtl_serial_numbers msn
2838: ,csi_item_instances cii
2839: ,mtl_object_genealogy mog
2840: WHERE msn.gen_object_id= mog.parent_object_id

Line 4900: from MTL_SYSTEM_ITEMS_B

4896: p_item_attribute_tbl(p_ins_count_rec.inv_count).master_organization_id := p_instance_rec.inv_master_organization_id;
4897: Begin
4898: select comms_nl_trackable_flag,primary_uom_code
4899: into l_trackable_flag,l_uom_code
4900: from MTL_SYSTEM_ITEMS_B
4901: where inventory_item_id = p_instance_rec.inventory_item_id
4902: and organization_id = p_instance_rec.inv_master_organization_id
4903: and enabled_flag = 'Y'
4904: and nvl (start_date_active, sysdate) <= sysdate

Line 4933: FROM mtl_system_items_b

4929: ,l_lot_control
4930: ,l_shelf_life_code
4931: ,l_eam_item_type
4932: ,l_equipment_type
4933: FROM mtl_system_items_b
4934: WHERE inventory_item_id = p_instance_rec.inventory_item_id
4935: AND organization_id = p_instance_rec.vld_organization_id
4936: AND enabled_flag = 'Y'
4937: AND nvl (start_date_active, sysdate) <= sysdate

Line 6172: from MTL_SYSTEM_ITEMS_B

6168: l_base_item_id := null;
6169: Begin
6170: select base_item_id
6171: into l_base_item_id
6172: from MTL_SYSTEM_ITEMS_B
6173: where inventory_item_id = p_instance_rec.inventory_item_id
6174: and organization_id = l_last_vld_organization_id;
6175: Exception
6176: when no_data_found then

Line 12553: FROM MTL_SYSTEM_ITEMS_B

12549: SELECT comms_nl_trackable_flag
12550: ,primary_uom_code
12551: INTO l_trackable_flag
12552: ,l_uom_code
12553: FROM MTL_SYSTEM_ITEMS_B
12554: WHERE inventory_item_id = l_get_instance_rec.inventory_item_id
12555: AND organization_id = l_get_instance_rec.inv_master_organization_id
12556: AND enabled_flag = 'Y'
12557: AND nvl (start_date_active, sysdate) <= sysdate

Line 12587: FROM MTL_SYSTEM_ITEMS_B

12583: ,l_lot_control
12584: ,l_shelf_life_code
12585: ,l_eam_item_type
12586: ,l_equipment_type
12587: FROM MTL_SYSTEM_ITEMS_B
12588: WHERE inventory_item_id = l_get_instance_rec.inventory_item_id
12589: AND organization_id = p_instance_rec.vld_organization_id
12590: AND enabled_flag = 'Y'
12591: AND nvl (start_date_active, sysdate) <= sysdate

Line 14446: from MTL_SYSTEM_ITEMS_B

14442: l_base_item_id := null;
14443: Begin
14444: select base_item_id
14445: into l_base_item_id
14446: from MTL_SYSTEM_ITEMS_B
14447: where inventory_item_id = l_get_instance_rec.inventory_item_id
14448: and organization_id = l_last_vld_organization_id;
14449: Exception
14450: when no_data_found then