DBA Data[Home] [Help]

APPS.RCV_AVAILABILITY dependencies on PO_LINE_LOCATIONS_ALL

Line 167: FROM po_line_locations_all pll,

163: SELECT sum(pod.quantity_ordered) quantity,
164: pol.item_id,
165: pol.unit_meas_lookup_code unit_of_measure,
166: si.primary_unit_of_measure
167: FROM po_line_locations_all pll,
168: po_lines_all pol,
169: po_distributions_all pod,
170: mtl_system_items si
171: WHERE pll.line_location_id = p_supply_demand_line_id

Line 956: FROM po_line_locations_all pll,

952: * Change all the table to base tables.
953: */
954: SELECT 'Y'
955: INTO x_valid_status
956: FROM po_line_locations_all pll,
957: po_lines_all pol,
958: po_headers_all poh
959: WHERE pol.po_header_id = poh.po_header_id
960: AND pll.po_line_id = pol.po_line_id