APPS.GMD_AUTO_STEP_CALC dependencies on MTL_SYSTEM_ITEMS_KFV

Line 943: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;

939: X_temp_qty NUMBER;
940: X_item_id NUMBER;
941: X_from_uom mtl_units_of_measure.uom_code%TYPE;
942: X_to_uom mtl_units_of_measure.uom_code%TYPE;
943: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
944:
945: /* Cursor Definitions.
946: =====================*/
947: CURSOR Cur_get_material_lines (V_step_id NUMBER) IS

Line 978: FROM mtl_system_items_kfv

974:
975: -- NPD Conv.
976: CURSOR Cur_get_item IS
977: SELECT concatenated_segments
978: FROM mtl_system_items_kfv
979: WHERE inventory_item_id = X_item_id;
980:
981: /* Cursor records.
982: =====================*/

Line 1312: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;

1308: X_temp_qty NUMBER;
1309: X_item_id NUMBER;
1310: X_from_uom mtl_units_of_measure.uom_code%TYPE;
1311: X_to_uom mtl_units_of_measure.uom_code%TYPE;
1312: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
1313:
1314:
1315: /* Scaling realted variables */
1316: k NUMBER := 0;

Line 1341: FROM mtl_system_items_kfv

1337:
1338: -- NPD Conv.
1339: CURSOR Cur_get_item IS
1340: SELECT concatenated_segments
1341: FROM mtl_system_items_kfv
1342: WHERE inventory_item_id = X_item_id;
1343:
1344: /* Get all formulaline information */
1345: CURSOR Cur_get_formulaline_info IS

Line 1724: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;

1720: X_temp_qty NUMBER;
1721: X_item_id NUMBER;
1722: X_from_uom mtl_units_of_measure.uom_code%TYPE;
1723: X_to_uom mtl_units_of_measure.uom_code%TYPE;
1724: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
1725:
1726: /* Cursor Definitions.
1727: =====================*/
1728: CURSOR Cur_get_recipe_details IS

Line 1767: FROM mtl_system_items_kfv

1763: ;
1764:
1765: CURSOR Cur_get_item IS
1766: SELECT concatenated_segments
1767: FROM mtl_system_items_kfv
1768: WHERE inventory_item_id = X_item_id;
1769:
1770: --QZENG Bug 14197174 Added condition BASE_UOM_FLAG = 'Y' to fetch the base uom
1771: CURSOR Cur_get_std_um (V_uom_class VARCHAR2) IS