DBA Data[Home] [Help]

APPS.GMD_AUTO_STEP_CALC dependencies on MTL_SYSTEM_ITEMS_KFV

Line 939: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;

935: X_temp_qty NUMBER;
936: X_item_id NUMBER;
937: X_from_uom mtl_units_of_measure.uom_code%TYPE;
938: X_to_uom mtl_units_of_measure.uom_code%TYPE;
939: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
940:
941: /* Cursor Definitions.
942: =====================*/
943: CURSOR Cur_get_material_lines (V_step_id NUMBER) IS

Line 972: FROM mtl_system_items_kfv

968:
969: -- NPD Conv.
970: CURSOR Cur_get_item IS
971: SELECT concatenated_segments
972: FROM mtl_system_items_kfv
973: WHERE inventory_item_id = X_item_id;
974:
975: /* Cursor records.
976: =====================*/

Line 1306: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;

1302: X_temp_qty NUMBER;
1303: X_item_id NUMBER;
1304: X_from_uom mtl_units_of_measure.uom_code%TYPE;
1305: X_to_uom mtl_units_of_measure.uom_code%TYPE;
1306: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
1307:
1308:
1309: /* Scaling realted variables */
1310: k NUMBER := 0;

Line 1335: FROM mtl_system_items_kfv

1331:
1332: -- NPD Conv.
1333: CURSOR Cur_get_item IS
1334: SELECT concatenated_segments
1335: FROM mtl_system_items_kfv
1336: WHERE inventory_item_id = X_item_id;
1337:
1338: /* Get all formulaline information */
1339: CURSOR Cur_get_formulaline_info IS

Line 1718: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;

1714: X_temp_qty NUMBER;
1715: X_item_id NUMBER;
1716: X_from_uom mtl_units_of_measure.uom_code%TYPE;
1717: X_to_uom mtl_units_of_measure.uom_code%TYPE;
1718: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
1719:
1720: /* Cursor Definitions.
1721: =====================*/
1722: CURSOR Cur_get_recipe_details IS

Line 1761: FROM mtl_system_items_kfv

1757: ;
1758:
1759: CURSOR Cur_get_item IS
1760: SELECT concatenated_segments
1761: FROM mtl_system_items_kfv
1762: WHERE inventory_item_id = X_item_id;
1763:
1764: CURSOR Cur_get_std_um (V_uom_class VARCHAR2) IS
1765: SELECT uom_code