APPS.POA_EDW_RCV_TXNS_F_SIZE dependencies on RCV_SHIPMENT_LINES

Line 17: RCV_SHIPMENT_LINES RSL,

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
20: RCV.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
21: AND RCV.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID

Line 151: from RCV_SHIPMENT_LINES

147:
148: CURSOR c_1A IS
149: SELECT avg(nvl(vsize(ITEM_REVISION), 0)),
150: avg(nvl(vsize(PACKING_SLIP), 0))
151: from RCV_SHIPMENT_LINES
152: where last_update_date between
153: p_from_date and p_to_date;
154:
155: CURSOR c_1B IS