APPS.POA_EDW_RCV_TXNS_F_SIZE dependencies on RCV_TRANSACTIONS

Line 18: RCV_TRANSACTIONS RCV

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
22: AND RCV.PO_LINE_LOCATION_ID = PLL.LINE_LOCATION_ID

Line 144: from RCV_TRANSACTIONS

140: avg(nvl(vsize(REASON_ID), 0)),
141: avg(nvl(vsize(VENDOR_LOT_NUM), 0)),
142: avg(nvl(vsize(RMA_REFERENCE), 0)),
143: avg(nvl(vsize(COMMENTS), 0))
144: from RCV_TRANSACTIONS
145: where last_update_date between
146: p_from_date and p_to_date;
147:
148: CURSOR c_1A IS