DBA Data[Home] [Help]

APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on MTL_UNITS_OF_MEASURE_VL

Line 2453: , uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE

2449: , tp_organization_id NUMBER
2450: , need_by_date DATE
2451: , quantity NUMBER
2452: , unit_of_measure PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE
2453: , uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2454: , primary_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2455: , primary_uom_quantity NUMBER
2456: , project_id NUMBER
2457: , task_id NUMBER

Line 2454: , primary_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE

2450: , need_by_date DATE
2451: , quantity NUMBER
2452: , unit_of_measure PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE
2453: , uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2454: , primary_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2455: , primary_uom_quantity NUMBER
2456: , project_id NUMBER
2457: , task_id NUMBER
2458: , status VARCHAR2(1)

Line 2625: FROM mtl_units_of_measure_vl

2621: BEGIN
2622:
2623: SELECT uom_code
2624: INTO l_osa_tbl(i).uom_code
2625: FROM mtl_units_of_measure_vl
2626: WHERE unit_of_measure = l_osa_tbl(i).unit_of_measure;
2627:
2628: l_osa_tbl(i).primary_uom_code := JMF_SHIKYU_UTIL.Get_Primary_Uom_Code
2629: ( l_osa_tbl(i).osa_item_id