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.EGO_ICC_STRUCTURE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1622: from mtl_system_items_kfv where inventory_item_id = comp.PK1_VALUE

1618: l_return_val := 1;
1619: begin
1620:
1621: select concatenated_segments into G_COMP_ITEM_NAME
1622: from mtl_system_items_kfv where inventory_item_id = comp.PK1_VALUE
1623: and organization_id = comp.pk2_value;
1624:
1625: /* UT Fix: Modified query to use ass_item_id instead of comp_item_id. */
1626: select revision_label into G_EFF_FROM

Line 1826: from mtl_system_items_kfv where inventory_item_id = p_inventory_item_id and organization_id = p_organization_id;

1822: where inventory_item_id = p_inventory_item_id
1823: and organization_id = p_organization_id;
1824: l_stmt_no := 80;
1825: select concatenated_segments into G_ASSY_ITEM_NAME
1826: from mtl_system_items_kfv where inventory_item_id = p_inventory_item_id and organization_id = p_organization_id;
1827: l_stmt_no := 90;
1828: populate_item_rev_details(p_inventory_item_id,p_organization_id);
1829: l_stmt_no := 100;
1830: l_ins_cntr := 0;

Line 1852: from mtl_system_items_kfv where inventory_item_id = component.component_item_id

1848: --Return;
1849: End If;
1850: l_stmt_no := 140;
1851: select concatenated_segments into G_COMP_ITEM_NAME
1852: from mtl_system_items_kfv where inventory_item_id = component.component_item_id
1853: and organization_id = p_organization_id;
1854: l_stmt_no := 150;
1855: if v_icc_comp_tbl.exists(component.component_item_id) then
1856: x_Return_Status := 1;

Line 2437: from mtl_system_items_kfv where inventory_item_id = p_inventory_item_id and organization_id = p_organization_id;

2433: and organization_id = p_organization_id;
2434:
2435: l_stmt_no := 80;
2436: select concatenated_segments into G_ASSY_ITEM_NAME
2437: from mtl_system_items_kfv where inventory_item_id = p_inventory_item_id and organization_id = p_organization_id;
2438: l_stmt_no := 90;
2439: populate_item_rev_details(p_inventory_item_id,p_organization_id);
2440: l_stmt_no := 100;
2441: if v_item_revisions_tbl.exists(v_rev_index(p_revision_id)-1) then

Line 2462: from mtl_system_items_kfv where inventory_item_id = component.component_item_id

2458: --Return;
2459: End If;
2460: l_stmt_no := 130;
2461: select concatenated_segments into G_COMP_ITEM_NAME
2462: from mtl_system_items_kfv where inventory_item_id = component.component_item_id
2463: and organization_id = p_organization_id;
2464: l_stmt_no := 140;
2465: if v_icc_comp_tbl.exists(component.component_item_id) then
2466: x_Return_Status := 1;