DBA Data[Home] [Help]

APPS.AP_ETAX_UTILITY_PKG dependencies on PO_HEADERS_ALL

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

904: l_api_name CONSTANT VARCHAR2(100) := 'Get_PO_Info';
905:
906: CURSOR PO_Info_from_line_loc (c_po_line_location_Id IN NUMBER) IS
907: SELECT pll.org_id, pll.quantity, pll.po_header_id, nvl(ph.rate ,1), pll.po_release_id, mum.uom_code
908: FROM po_line_locations_all pll, po_headers_all ph, mtl_units_of_measure mum
909: WHERE pll.line_location_id = c_po_line_location_Id
910: AND pll.po_header_id = ph.po_header_id
911: AND pll.unit_meas_lookup_code = mum.unit_of_measure (+);
912:

Line 918: po_headers_all ph, mtl_units_of_measure mum

914: SELECT pll.org_id, pll.quantity, pll.line_location_id,
915: pll.po_header_id, nvl(ph.rate,1), pll.po_release_id, mum.uom_code,
916: pd.quantity_ordered, pll.price_override
917: FROM po_line_locations_all pll, po_distributions_all pd,
918: po_headers_all ph, mtl_units_of_measure mum
919: WHERE pd.po_distribution_id = c_po_dist_Id
920: AND pd.line_location_id = pll.line_location_id
921: AND pll.po_header_id = ph.po_header_id
922: AND pll.unit_meas_lookup_code = mum.unit_of_measure (+);