DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 793: FROM po_requisition_lines_all prl,po_line_types_b plt, mtl_units_of_measure mom, po_lines_all pol

789: ,req_line_ip_category_id
790: ,req_line_uom
791: ,req_group_line_id
792: ,req_ship_to_location_id
793: FROM po_requisition_lines_all prl,po_line_types_b plt, mtl_units_of_measure mom, po_lines_all pol
794: WHERE prl.requisition_line_id = l_req_line_id
795: AND prl.line_type_id = plt.line_type_id
796: AND mom.unit_of_measure (+) = prl.unit_meas_lookup_code
797: AND pol.po_header_id(+) = prl.blanket_po_header_id AND pol.line_num(+) = prl.blanket_po_line_num;