DBA Data[Home] [Help]

APPS.BOMPCMBM dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1293: l_comp_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

1289: l_pend_inc_in_cost_rollup NUMBER;
1290: l_pend_op_seq NUMBER;
1291:
1292: l_dummy VARCHAR2(10);
1293: l_comp_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1294:
1295: BEGIN
1296:
1297: l_Bo_Id := Bom_Globals.Get_Bo_Identifier;

Line 1314: from mtl_system_items_kfv item, bom_components_b comp

1310: THEN
1311:
1312: SELECT concatenated_segments
1313: into l_comp_name
1314: from mtl_system_items_kfv item, bom_components_b comp
1315: where item.inventory_item_id = comp.pk1_value
1316: and item.organization_id = comp.pk2_value
1317: and comp.component_sequence_id = p_src_comp_seq_id;
1318:

Line 1602: from mtl_system_items_kfv

1598: THEN --overlap exists
1599: x_Return_Status := FND_API.G_RET_STS_ERROR;
1600: SELECT concatenated_segments
1601: into l_comp_name
1602: from mtl_system_items_kfv
1603: where inventory_item_id = src_comp_details.component_item_id
1604: and organization_id = l_dest_org_id;
1605:
1606: SELECT concatenated_segments

Line 1608: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

1604: and organization_id = l_dest_org_id;
1605:
1606: SELECT concatenated_segments
1607: into l_dest_assy_item
1608: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
1609: where item.inventory_item_id = bom.assembly_item_id
1610: and item.organization_id = bom.organization_id
1611: and bom.bill_sequence_id = src_comp_details.bill_sequence_id;
1612:

Line 1655: from mtl_system_items_kfv

1651: x_Return_Status := FND_API.G_RET_STS_ERROR;
1652:
1653: SELECT concatenated_segments
1654: into l_comp_name
1655: from mtl_system_items_kfv
1656: where inventory_item_id = src_comp_details.component_item_id
1657: and organization_id = l_dest_org_id;
1658:
1659: SELECT concatenated_segments

Line 1661: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

1657: and organization_id = l_dest_org_id;
1658:
1659: SELECT concatenated_segments
1660: into l_dest_assy_item
1661: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
1662: where item.inventory_item_id = bom.assembly_item_id
1663: and item.organization_id = bom.organization_id
1664: and bom.bill_sequence_id = src_comp_details.bill_sequence_id;
1665:

Line 1830: from mtl_system_items_kfv item, bom_components_b comp

1826: THEN
1827:
1828: SELECT concatenated_segments
1829: into l_comp_name
1830: from mtl_system_items_kfv item, bom_components_b comp
1831: where item.inventory_item_id = comp.pk1_value
1832: and item.organization_id = comp.pk2_value
1833: and comp.component_sequence_id = p_src_comp_seq_id;
1834:

Line 1949: from mtl_system_items_kfv

1945: WHERE bill_sequence_id = dest_comp.bill_sequence_id;
1946:
1947: SELECT concatenated_segments
1948: into l_comp_name
1949: from mtl_system_items_kfv
1950: where inventory_item_id = src_comp.component_item_id
1951: and organization_id = l_dest_org_id;
1952:
1953: SELECT concatenated_segments

Line 1955: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

1951: and organization_id = l_dest_org_id;
1952:
1953: SELECT concatenated_segments
1954: into l_dest_assy_item
1955: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
1956: where item.inventory_item_id = bom.assembly_item_id
1957: and item.organization_id = bom.organization_id
1958: and bom.bill_sequence_id = src_comp.bill_sequence_id;
1959:

Line 2013: from mtl_system_items_kfv

2009: WHERE bill_sequence_id = dest_comp.bill_sequence_id;
2010:
2011: SELECT concatenated_segments
2012: into l_comp_name
2013: from mtl_system_items_kfv
2014: where inventory_item_id = src_comp.component_item_id
2015: and organization_id = l_dest_org_id;
2016:
2017: SELECT concatenated_segments

Line 2019: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

2015: and organization_id = l_dest_org_id;
2016:
2017: SELECT concatenated_segments
2018: into l_dest_assy_item
2019: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
2020: where item.inventory_item_id = bom.assembly_item_id
2021: and item.organization_id = bom.organization_id
2022: and bom.bill_sequence_id = src_comp.bill_sequence_id;
2023: