eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 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

Line 21484: FROM mtl_system_items

21480: l_batch_id NUMBER;
21481: --
21482: CURSOR c1 is
21483: SELECT serial_number_control_code
21484: FROM mtl_system_items
21485: WHERE inventory_item_id = p_source_instance_rec.inventory_item_id
21486: AND organization_id = p_source_instance_rec.vld_organization_id
21487: AND enabled_flag = 'Y'
21488: AND nvl (start_date_active, sysdate) <= sysdate

Line 21953: FROM mtl_system_items

21949: )
21950: IS
21951: CURSOR c1 is
21952: SELECT serial_number_control_code
21953: FROM mtl_system_items
21954: WHERE inventory_item_id = p_source_instance_rec.inventory_item_id
21955: AND organization_id = p_source_instance_rec.vld_organization_id
21956: AND nvl(comms_nl_trackable_flag, 'N') = 'Y'
21957: AND enabled_flag = 'Y'

Line 29259: ,mtl_system_items msi

29255: ,msi.primary_uom_code primary_uom_code
29256: ,mp.master_organization_id master_organization_id
29257: FROM bom_small_expl_temp bet
29258: ,bom_bill_of_materials bom
29259: ,mtl_system_items msi
29260: ,mtl_system_items msip
29261: ,mtl_parameters mp
29262: WHERE bet.group_id = p_group_id
29263: AND bet.plan_level > 0 -- Ignore Top Most

Line 29260: ,mtl_system_items msip

29256: ,mp.master_organization_id master_organization_id
29257: FROM bom_small_expl_temp bet
29258: ,bom_bill_of_materials bom
29259: ,mtl_system_items msi
29260: ,mtl_system_items msip
29261: ,mtl_parameters mp
29262: WHERE bet.group_id = p_group_id
29263: AND bet.plan_level > 0 -- Ignore Top Most
29264: AND bet.component_item_id = msi.inventory_item_id