eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POA_EDW_RCV_TXNS_F_SIZE dependencies on RCV_SHIPMENT_HEADERS

Line 16: RCV_SHIPMENT_HEADERS RSH,

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
20: RCV.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID

Line 164: from RCV_SHIPMENT_HEADERS

160: avg(nvl(vsize(RECEIPT_NUM), 0)),
161: avg(nvl(vsize(COMMENTS), 0)),
162: avg(nvl(vsize(WAYBILL_AIRBILL_NUM), 0)),
163: avg(nvl(vsize(BILL_OF_LADING), 0))
164: from RCV_SHIPMENT_HEADERS
165: where last_update_date between
166: p_from_date and p_to_date;
167:
168: