5: (
6: STEP_ID NUMBER,
7: STEP_NO NUMBER,
8: STEP_QTY NUMBER,
9: STEP_QTY_UOM mtl_units_of_measure.uom_code%TYPE,
10: STEP_MASS_QTY NUMBER,
11: STEP_MASS_UOM mtl_units_of_measure.uom_code%TYPE,
12: STEP_VOL_QTY NUMBER,
13: STEP_VOL_UOM mtl_units_of_measure.uom_code%TYPE,
7: STEP_NO NUMBER,
8: STEP_QTY NUMBER,
9: STEP_QTY_UOM mtl_units_of_measure.uom_code%TYPE,
10: STEP_MASS_QTY NUMBER,
11: STEP_MASS_UOM mtl_units_of_measure.uom_code%TYPE,
12: STEP_VOL_QTY NUMBER,
13: STEP_VOL_UOM mtl_units_of_measure.uom_code%TYPE,
14: STEP_OTHER_QTY NUMBER,
15: STEP_OTHER_UOM mtl_units_of_measure.uom_code%TYPE
9: STEP_QTY_UOM mtl_units_of_measure.uom_code%TYPE,
10: STEP_MASS_QTY NUMBER,
11: STEP_MASS_UOM mtl_units_of_measure.uom_code%TYPE,
12: STEP_VOL_QTY NUMBER,
13: STEP_VOL_UOM mtl_units_of_measure.uom_code%TYPE,
14: STEP_OTHER_QTY NUMBER,
15: STEP_OTHER_UOM mtl_units_of_measure.uom_code%TYPE
16: );
17:
11: STEP_MASS_UOM mtl_units_of_measure.uom_code%TYPE,
12: STEP_VOL_QTY NUMBER,
13: STEP_VOL_UOM mtl_units_of_measure.uom_code%TYPE,
14: STEP_OTHER_QTY NUMBER,
15: STEP_OTHER_UOM mtl_units_of_measure.uom_code%TYPE
16: );
17:
18: TYPE work_step_rec_type IS RECORD
19: (
81: /* Costing would like ASQC on scaled formula qty */
82: TYPE costing_scale_rec_type IS RECORD
83: (
84: INVENTORY_ITEM_ID NUMBER,
85: ITEM_UM mtl_units_of_measure.uom_code%TYPE,
86: SCALE_FACTOR NUMBER
87: );
88:
89:
95: G_PROFILE_MASS_UM_TYPE VARCHAR2(80);
96: G_PROFILE_VOLUME_UM_TYPE VARCHAR2(80);
97: G_PROFILE_OTHER_UM_TYPE VARCHAR2(80);
98:
99: G_MASS_STD_UM mtl_units_of_measure.uom_class%TYPE;
100: G_VOL_STD_UM mtl_units_of_measure.uom_class%TYPE;
101: G_OTHER_STD_UM mtl_units_of_measure.uom_class%TYPE;
102:
103: G_OTHER_UM_TYPE_EXISTS BOOLEAN := FALSE;
96: G_PROFILE_VOLUME_UM_TYPE VARCHAR2(80);
97: G_PROFILE_OTHER_UM_TYPE VARCHAR2(80);
98:
99: G_MASS_STD_UM mtl_units_of_measure.uom_class%TYPE;
100: G_VOL_STD_UM mtl_units_of_measure.uom_class%TYPE;
101: G_OTHER_STD_UM mtl_units_of_measure.uom_class%TYPE;
102:
103: G_OTHER_UM_TYPE_EXISTS BOOLEAN := FALSE;
104:
97: G_PROFILE_OTHER_UM_TYPE VARCHAR2(80);
98:
99: G_MASS_STD_UM mtl_units_of_measure.uom_class%TYPE;
100: G_VOL_STD_UM mtl_units_of_measure.uom_class%TYPE;
101: G_OTHER_STD_UM mtl_units_of_measure.uom_class%TYPE;
102:
103: G_OTHER_UM_TYPE_EXISTS BOOLEAN := FALSE;
104:
105: