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 1309: , mtl_units_of_measure muom

1305: FROM
1306: po_line_locations_all poll
1307: , po_headers_all poh
1308: , po_lines_all pol
1309: , mtl_units_of_measure muom
1310: , po_releases_all por
1311: WHERE poll.po_header_id = poh.po_header_id
1312: AND poll.po_line_id = pol.po_line_id
1313: AND poh.po_header_id = pol.po_header_id

Line 2214: , uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE

2210: , tp_organization_id NUMBER
2211: , need_by_date DATE
2212: , quantity NUMBER
2213: , unit_of_measure PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE
2214: , uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2215: , primary_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2216: , primary_uom_quantity NUMBER
2217: , project_id NUMBER
2218: , task_id NUMBER

Line 2215: , primary_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE

2211: , need_by_date DATE
2212: , quantity NUMBER
2213: , unit_of_measure PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE
2214: , uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2215: , primary_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2216: , primary_uom_quantity NUMBER
2217: , project_id NUMBER
2218: , task_id NUMBER
2219: , status VARCHAR2(1)

Line 2386: FROM mtl_units_of_measure_vl

2382: BEGIN
2383:
2384: SELECT uom_code
2385: INTO l_osa_tbl(i).uom_code
2386: FROM mtl_units_of_measure_vl
2387: WHERE unit_of_measure = l_osa_tbl(i).unit_of_measure;
2388:
2389: l_osa_tbl(i).primary_uom_code := JMF_SHIKYU_UTIL.Get_Primary_Uom_Code
2390: ( l_osa_tbl(i).osa_item_id