APPS.BOMPXINQ dependencies on MTL_SYSTEM_ITEMS

Line 378: from BOM_SMALL_EXPL_TEMP BET, bom_bill_of_materials bbm, mtl_system_items msi1, mtl_system_items msi2

374: BET.common_bill_sequence_id curCBSI,
375: msi1.organization_id t_master_org_id,
376: msi1.primary_uom_code t_master_uom,
377: msi2.primary_uom_code t_child_uom
378: from BOM_SMALL_EXPL_TEMP BET, bom_bill_of_materials bbm, mtl_system_items msi1, mtl_system_items msi2
379: where BET.bill_sequence_id <> BET.common_bill_sequence_id
380: and bbm.bill_sequence_id = BET.common_bill_sequence_id
381: and msi1.inventory_item_id = BET.component_item_id
382: and msi1.organization_id = bbm.organization_id

Line 454: from bom_bill_of_materials bom, mtl_system_items msi

450: 2,
451: alt_desg,
452: msi.bom_item_type,
453: msi.bom_item_type
454: from bom_bill_of_materials bom, mtl_system_items msi
455: where bom.assembly_item_id = item_id
456: and bom.organization_id = org_id
457: and nvl(alternate_bom_designator, 'NONE') =
458: nvl(alt_desg, 'NONE')

Line 545: from mtl_system_items msi, bom_bill_of_materials bbm

541:
542: /* Bug 9355186 - This information in queried in cursor cur
543: select msi.primary_uom_code, msi.organization_id into
544: t_master_uom, t_master_org_id
545: from mtl_system_items msi, bom_bill_of_materials bbm
546: where cr.curCBSI = bbm.bill_sequence_id and
547: bbm.organization_id = msi.organization_id and
548: msi.inventory_item_id = cr.curCII;
549:

Line 551: from mtl_system_items msi

547: bbm.organization_id = msi.organization_id and
548: msi.inventory_item_id = cr.curCII;
549:
550: select msi.primary_uom_code into t_child_uom
551: from mtl_system_items msi
552: where msi.inventory_item_id = cr.curCII and
553: msi.organization_id = cr.curOI;
554: */
555:

Line 1065: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

1061:
1062: FUNCTION Get_Item_Name(P_item_id IN NUMBER,
1063: P_organization_id IN NUMBER)
1064: RETURN VARCHAR2 IS
1065: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1066: BEGIN
1067: SELECT concatenated_segments
1068: INTO l_item_name
1069: FROM mtl_system_items_kfv

Line 1069: FROM mtl_system_items_kfv

1065: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1066: BEGIN
1067: SELECT concatenated_segments
1068: INTO l_item_name
1069: FROM mtl_system_items_kfv
1070: WHERE inventory_item_id = P_item_id
1071: AND organization_id = P_organization_id;
1072: RETURN l_item_name;
1073: EXCEPTION

Line 1183: l_common_assembly_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

1179: WHERE inventory_item_id = P_assembly_item_id
1180: AND organization_id = P_organization_id;
1181:
1182: l_bill_details Bill_Details_CUR%ROWTYPE;
1183: l_common_assembly_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1184: l_common_org_code VARCHAR2(3);
1185: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1186: l_org_code VARCHAR2(3);
1187: l_cnt NUMBER;

Line 1185: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

1181:
1182: l_bill_details Bill_Details_CUR%ROWTYPE;
1183: l_common_assembly_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1184: l_common_org_code VARCHAR2(3);
1185: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1186: l_org_code VARCHAR2(3);
1187: l_cnt NUMBER;
1188: l_counter NUMBER;
1189: l_count NUMBER;

Line 1410: l_component_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

1406: l_cnt NUMBER;
1407: j NUMBER;
1408: k NUMBER;
1409: l NUMBER;
1410: l_component_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1411: l_locator_name MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE;
1412: BEGIN
1413: l_component_item_name := Get_Item_Name(P_component_item_id, P_organization_id);
1414:

Line 1669: FROM mtl_system_items

1665: WHERE organization_code = P_organization_code;
1666:
1667: CURSOR assembly_item_name_CUR IS
1668: SELECT inventory_item_id
1669: FROM mtl_system_items
1670: WHERE segment1 = P_assembly_item_name
1671: AND organization_id = l_organization_id;
1672: l_err_text VARCHAR2(2000);
1673: l_err_msg varchar2(2000);