DBA Data[Home] [Help]

APPS.AP_ETAX_UTILITY_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 750: FROM po_line_locations_all pll, po_headers_all ph, mtl_units_of_measure mum

746: l_doc_type VARCHAR2(20);
747:
748: CURSOR PO_Info_from_line_loc (c_po_line_location_Id IN NUMBER) IS
749: SELECT pll.org_id, pll.quantity, pll.po_header_id, nvl(ph.rate ,1), pll.po_release_id, mum.uom_code
750: FROM po_line_locations_all pll, po_headers_all ph, mtl_units_of_measure mum
751: WHERE pll.line_location_id = c_po_line_location_Id
752: AND pll.po_header_id = ph.po_header_id
753: AND pll.unit_meas_lookup_code = mum.unit_of_measure (+);
754:

Line 760: po_headers_all ph, mtl_units_of_measure mum

756: SELECT pll.org_id, pll.quantity, pll.line_location_id,
757: pll.po_header_id, nvl(ph.rate,1), pll.po_release_id, mum.uom_code,
758: pd.quantity_ordered, pll.price_override
759: FROM po_line_locations_all pll, po_distributions_all pd,
760: po_headers_all ph, mtl_units_of_measure mum
761: WHERE pd.po_distribution_id = c_po_dist_Id
762: AND pd.line_location_id = pll.line_location_id
763: AND pll.po_header_id = ph.po_header_id
764: AND pll.unit_meas_lookup_code = mum.unit_of_measure (+);