APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 165: --| mtl_units_of_measure of the select |

161: --| picked and recovered in a later |
162: --| Interlock run. |
163: --| 06/13/2006 vchu Fixed bug 5153959: |
164: --| Modified the join statement with |
165: --| mtl_units_of_measure of the select |
166: --| statement for inserting into the |
167: --| JMF_SUBCONTRACT_ORDERS_TEMP temp table |
168: --| (in Load_Subcontract_Orders) to take |
169: --| the unit_meas_lookup_code from the PO |

Line 1362: , mtl_units_of_measure muom

1358: FROM
1359: po_line_locations_all poll
1360: , po_headers_all poh
1361: , po_lines_all pol
1362: , mtl_units_of_measure muom
1363: , po_releases_all por
1364: WHERE poll.po_header_id = poh.po_header_id
1365: AND poll.po_line_id = pol.po_line_id
1366: AND poh.po_header_id = pol.po_header_id

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