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.FV_CROSS_DOC_REF dependencies on RCV_SHIPMENT_LINES

Line 1233: AND EXISTS(SELECT 1 FROM rcv_shipment_lines rsl,rcv_shipment_headers rsh

1229: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id )
1230: AND TRUNC(rsh.creation_date) = NVL( vp_rec_date,TRUNC(rsh.creation_date))))
1231: OR EXISTS (SELECT 1 FROM po_distributions pd
1232: WHERE pd.po_distribution_id = aid.po_distribution_id
1233: AND EXISTS(SELECT 1 FROM rcv_shipment_lines rsl,rcv_shipment_headers rsh
1234: WHERE rsl.po_line_location_id = pd.line_location_id
1235: AND rsl.shipment_header_id = rsh.shipment_header_id
1236: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id )
1237: AND TRUNC(rsh.creation_date) = NVL( vp_rec_date,TRUNC(rsh.creation_date))))))

Line 1255: AND EXISTS(SELECT 1 FROM rcv_shipment_lines rsl,rcv_shipment_headers rsh

1251: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id )
1252: AND TRUNC(rsh.creation_date) = NVL( vp_rec_date,TRUNC(rsh.creation_date))))
1253: OR EXISTS (SELECT 1 FROM po_distributions pd
1254: WHERE pd.po_distribution_id = aid.po_distribution_id
1255: AND EXISTS(SELECT 1 FROM rcv_shipment_lines rsl,rcv_shipment_headers rsh
1256: WHERE rsl.po_line_location_id = pd.line_location_id
1257: AND rsl.shipment_header_id = rsh.shipment_header_id
1258: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id )
1259: AND TRUNC(rsh.creation_date) = NVL( vp_rec_date,TRUNC(rsh.creation_date))))));