APPS.BOMPXINQ dependencies on MTL_SYSTEM_ITEMS

Line 440: from bom_bill_of_materials bom, mtl_system_items msi

436: 2,
437: alt_desg,
438: msi.bom_item_type,
439: msi.bom_item_type
440: from bom_bill_of_materials bom, mtl_system_items msi
441: where bom.assembly_item_id = item_id
442: and bom.organization_id = org_id
443: and nvl(alternate_bom_designator, 'NONE') =
444: nvl(alt_desg, 'NONE')

Line 525: from mtl_system_items msi, bom_bill_of_materials bbm

521:
522: FOR cr IN cur LOOP
523: select msi.primary_uom_code, msi.organization_id into
524: t_master_uom, t_master_org_id
525: from mtl_system_items msi, bom_bill_of_materials bbm
526: where cr.curCBSI = bbm.bill_sequence_id and
527: bbm.organization_id = msi.organization_id and
528: msi.inventory_item_id = cr.curCII;
529:

Line 531: from mtl_system_items msi

527: bbm.organization_id = msi.organization_id and
528: msi.inventory_item_id = cr.curCII;
529:
530: select msi.primary_uom_code into t_child_uom
531: from mtl_system_items msi
532: where msi.inventory_item_id = cr.curCII and
533: msi.organization_id = cr.curOI;
534:
535: /* Bug 2663515

Line 1021: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

1017:
1018: FUNCTION Get_Item_Name(P_item_id IN NUMBER,
1019: P_organization_id IN NUMBER)
1020: RETURN VARCHAR2 IS
1021: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1022: BEGIN
1023: SELECT concatenated_segments
1024: INTO l_item_name
1025: FROM mtl_system_items_kfv

Line 1025: FROM mtl_system_items_kfv

1021: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1022: BEGIN
1023: SELECT concatenated_segments
1024: INTO l_item_name
1025: FROM mtl_system_items_kfv
1026: WHERE inventory_item_id = P_item_id
1027: AND organization_id = P_organization_id;
1028: RETURN l_item_name;
1029: EXCEPTION

Line 1139: l_common_assembly_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

1135: WHERE inventory_item_id = P_assembly_item_id
1136: AND organization_id = P_organization_id;
1137:
1138: l_bill_details Bill_Details_CUR%ROWTYPE;
1139: l_common_assembly_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1140: l_common_org_code VARCHAR2(3);
1141: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1142: l_org_code VARCHAR2(3);
1143: l_cnt NUMBER;

Line 1141: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

1137:
1138: l_bill_details Bill_Details_CUR%ROWTYPE;
1139: l_common_assembly_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1140: l_common_org_code VARCHAR2(3);
1141: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1142: l_org_code VARCHAR2(3);
1143: l_cnt NUMBER;
1144: l_counter NUMBER;
1145: l_count NUMBER;

Line 1366: l_component_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

1362: l_cnt NUMBER;
1363: j NUMBER;
1364: k NUMBER;
1365: l NUMBER;
1366: l_component_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1367: l_locator_name MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE;
1368: BEGIN
1369: l_component_item_name := Get_Item_Name(P_component_item_id, P_organization_id);
1370:

Line 1625: FROM mtl_system_items

1621: WHERE organization_code = P_organization_code;
1622:
1623: CURSOR assembly_item_name_CUR IS
1624: SELECT inventory_item_id
1625: FROM mtl_system_items
1626: WHERE segment1 = P_assembly_item_name
1627: AND organization_id = l_organization_id;
1628: l_err_text VARCHAR2(2000);
1629: l_err_msg varchar2(2000);