APPS.POA_EDW_RCV_TXNS_F_SIZE dependencies on PO_LINE_LOCATIONS_ALL

Line 15: PO_LINE_LOCATIONS_ALL PLL,

11: select count(*) into p_num_rows
12: from
13: PO_HEADERS_ALL POH,
14: PO_LINES_ALL POL,
15: PO_LINE_LOCATIONS_ALL PLL,
16: RCV_SHIPMENT_HEADERS RSH,
17: RCV_SHIPMENT_LINES RSL,
18: RCV_TRANSACTIONS RCV
19: WHERE

Line 180: from po_line_locations_all

176: p_from_date and p_to_date;
177:
178: CURSOR c_3 IS
179: SELECT avg(nvl(vsize(ship_to_organization_id), 0))
180: from po_line_locations_all
181: where last_update_date between
182: p_from_date and p_to_date;
183:
184: CURSOR c_4 IS