DBA Data[Home] [Help]

APPS.POA_EDW_RCV_TXNS_F_SIZE dependencies on PO_LINES_ALL

Line 14: PO_LINES_ALL POL,

10:
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

Line 174: from po_lines_all

170: SELECT avg(nvl(vsize(item_id), 0)),
171: avg(nvl(vsize(item_description), 0)),
172: avg(nvl(vsize(category_id), 0)),
173: avg(nvl(vsize(vendor_product_num), 0))
174: from po_lines_all
175: where last_update_date between
176: p_from_date and p_to_date;
177:
178: CURSOR c_3 IS