DBA Data[Home] [Help]

APPS.JMF_PROCESS_SHIKYU_RCV_TRX_PVT dependencies on MTL_UNITS_OF_MEASURE_VL

Line 280: from MTL_UNITS_OF_MEASURE_VL

276: FOR i IN 1 .. l_rcv_pending_trx_tbl.COUNT LOOP
277: -- Get primary UOM code.
278: select UOM_CODE
279: into l_primary_uom_code
280: from MTL_UNITS_OF_MEASURE_VL
281: where UNIT_OF_MEASURE = l_rcv_pending_trx_tbl(i).primary_unit_of_measure;
282:
283: IF ( l_rcv_pending_trx_tbl(i).transaction_type = 'RECEIVE' OR
284: l_rcv_pending_trx_tbl(i).transaction_type = 'DELIVER' OR

Line 658: l_rcv_uom MTL_UNITS_OF_MEASURE_VL.UOM_CODE%Type;

654: l_api_version CONSTANT NUMBER := 1.0;
655:
656:
657: l_osa_item_primary_uom VARCHAR2(3);
658: l_rcv_uom MTL_UNITS_OF_MEASURE_VL.UOM_CODE%Type;
659: l_osa_primary_uom_receipt_qty NUMBER;
660:
661: l_osa_item_id NUMBER;
662: l_return_flag NUMBER;

Line 1305: from MTL_UNITS_OF_MEASURE_VL

1301:
1302: -- get UnitOfMeasure from UomCode for Shikyu component
1303: select UNIT_OF_MEASURE
1304: into l_shikyu_unit_of_measure
1305: from MTL_UNITS_OF_MEASURE_VL
1306: where UOM_CODE = l_shikyu_primary_uom;
1307:
1308: IF p_status <> 'DA_ERROR' THEN
1309: