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

Line 1498: l_comp_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

1494: l_pend_inc_in_cost_rollup NUMBER;
1495: l_pend_op_seq NUMBER;
1496:
1497: l_dummy VARCHAR2(10);
1498: l_comp_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1499:
1500: BEGIN
1501:
1502: l_Bo_Id := Bom_Globals.Get_Bo_Identifier;

Line 1519: from mtl_system_items_kfv item, bom_components_b comp

1515: THEN
1516:
1517: SELECT concatenated_segments
1518: into l_comp_name
1519: from mtl_system_items_kfv item, bom_components_b comp
1520: where item.inventory_item_id = comp.pk1_value
1521: and item.organization_id = comp.pk2_value
1522: and comp.component_sequence_id = p_src_comp_seq_id;
1523:

Line 1807: from mtl_system_items_kfv

1803: THEN --overlap exists
1804: x_Return_Status := FND_API.G_RET_STS_ERROR;
1805: SELECT concatenated_segments
1806: into l_comp_name
1807: from mtl_system_items_kfv
1808: where inventory_item_id = src_comp_details.component_item_id
1809: and organization_id = l_dest_org_id;
1810:
1811: SELECT concatenated_segments

Line 1813: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

1809: and organization_id = l_dest_org_id;
1810:
1811: SELECT concatenated_segments
1812: into l_dest_assy_item
1813: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
1814: where item.inventory_item_id = bom.assembly_item_id
1815: and item.organization_id = bom.organization_id
1816: and bom.bill_sequence_id = src_comp_details.bill_sequence_id;
1817:

Line 1860: from mtl_system_items_kfv

1856: x_Return_Status := FND_API.G_RET_STS_ERROR;
1857:
1858: SELECT concatenated_segments
1859: into l_comp_name
1860: from mtl_system_items_kfv
1861: where inventory_item_id = src_comp_details.component_item_id
1862: and organization_id = l_dest_org_id;
1863:
1864: SELECT concatenated_segments

Line 1866: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

1862: and organization_id = l_dest_org_id;
1863:
1864: SELECT concatenated_segments
1865: into l_dest_assy_item
1866: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
1867: where item.inventory_item_id = bom.assembly_item_id
1868: and item.organization_id = bom.organization_id
1869: and bom.bill_sequence_id = src_comp_details.bill_sequence_id;
1870:

Line 2124: from mtl_system_items_kfv item, bom_components_b comp

2120: THEN
2121:
2122: SELECT concatenated_segments
2123: into l_comp_name
2124: from mtl_system_items_kfv item, bom_components_b comp
2125: where item.inventory_item_id = comp.pk1_value
2126: and item.organization_id = comp.pk2_value
2127: and comp.component_sequence_id = p_src_comp_seq_id;
2128:

Line 2241: from mtl_system_items_kfv

2237: WHERE bill_sequence_id = dest_comp.bill_sequence_id;
2238:
2239: SELECT concatenated_segments
2240: into l_comp_name
2241: from mtl_system_items_kfv
2242: where inventory_item_id = src_comp.component_item_id
2243: and organization_id = l_dest_org_id;
2244:
2245: SELECT concatenated_segments

Line 2247: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

2243: and organization_id = l_dest_org_id;
2244:
2245: SELECT concatenated_segments
2246: into l_dest_assy_item
2247: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
2248: where item.inventory_item_id = bom.assembly_item_id
2249: and item.organization_id = bom.organization_id
2250: and bom.bill_sequence_id = src_comp.bill_sequence_id;
2251:

Line 2305: from mtl_system_items_kfv

2301: WHERE bill_sequence_id = dest_comp.bill_sequence_id;
2302:
2303: SELECT concatenated_segments
2304: into l_comp_name
2305: from mtl_system_items_kfv
2306: where inventory_item_id = src_comp.component_item_id
2307: and organization_id = l_dest_org_id;
2308:
2309: SELECT concatenated_segments

Line 2311: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

2307: and organization_id = l_dest_org_id;
2308:
2309: SELECT concatenated_segments
2310: into l_dest_assy_item
2311: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
2312: where item.inventory_item_id = bom.assembly_item_id
2313: and item.organization_id = bom.organization_id
2314: and bom.bill_sequence_id = src_comp.bill_sequence_id;
2315: