DBA Data[Home] [Help]

APPS.PO_REQIMP_S dependencies on MTL_UNITS_OF_MEASURE

Line 330: l_item_um2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

326: l_msg_data VARCHAR2(2000);
327: l_row_id ROWID;
328:
329:
330: l_item_um2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
331: l_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
332: l_tracking_qty_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
333: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
334:

Line 336: l_item_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

332: l_tracking_qty_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
333: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
334:
335:
336: l_item_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
337: l_item_um2_s MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
338: l_tracking_qty_ind_s MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
339: l_secondary_default_ind_s MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
340: l_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

Line 337: l_item_um2_s MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

333: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
334:
335:
336: l_item_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
337: l_item_um2_s MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
338: l_tracking_qty_ind_s MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
339: l_secondary_default_ind_s MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
340: l_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
341:

Line 340: l_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

336: l_item_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
337: l_item_um2_s MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
338: l_tracking_qty_ind_s MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
339: l_secondary_default_ind_s MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
340: l_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
341:
342: l_sec_qty_source NUMBER;
343:
344: Cursor Cr_int_req IS

Line 523: from mtl_units_of_measure

519: );
520:
521: select unit_of_measure
522: into l_unit_of_measure_s
523: from mtl_units_of_measure
524: where uom_code = l_item_um2_s;
525:
526: l_progress := '090';
527: