DBA Data[Home] [Help]

APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on MTL_UNITS_OF_MEASURE

Line 1103: l_po_uom_code mtl_units_of_measure.uom_code%type;

1099: l_curr_qty_delivered NUMBER;
1100: l_quantity_in_queue NUMBER;
1101: l_scheduled_quantity NUMBER;
1102: l_usage_rate_or_amount NUMBER;
1103: l_po_uom_code mtl_units_of_measure.uom_code%type;
1104: l_interface_txn_id NUMBER;
1105: l_osp_item_id NUMBER;
1106: l_remaining_qty NUMBER;
1107:

Line 1178: from mtl_units_of_measure_vl uom

1174: /* Modified sql for performance bug 9552415 (FP 9398894) */
1175: begin
1176: select uom.uom_code
1177: into l_po_uom_code
1178: from mtl_units_of_measure_vl uom
1179: where uom.unit_of_measure =
1180: ( select PL.unit_meas_lookup_code
1181: from po_lines_all Pl
1182: where (pl.po_header_id,pl.po_line_id) =