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.AP_INVOICES_UTILITY_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 1172: receipt_number RCV_SHIPMENT_HEADERS.RECEIPT_NUM%TYPE:= 'UNMATCHED'; --Bug 16413390

1168: *============================================================================*/
1169:
1170: FUNCTION get_receipt_number(l_invoice_id IN NUMBER)
1171: RETURN VARCHAR2 IS
1172: receipt_number RCV_SHIPMENT_HEADERS.RECEIPT_NUM%TYPE:= 'UNMATCHED'; --Bug 16413390
1173:
1174: CURSOR receipt_number_cursor IS
1175: SELECT DISTINCT(rsh.receipt_num)
1176: FROM ap_invoice_lines L,

Line 1178: rcv_shipment_headers RSH

1174: CURSOR receipt_number_cursor IS
1175: SELECT DISTINCT(rsh.receipt_num)
1176: FROM ap_invoice_lines L,
1177: rcv_transactions RTXN,
1178: rcv_shipment_headers RSH
1179: WHERE L.invoice_id = l_invoice_id
1180: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1181: FROM ap_invoice_lines AIL
1182: WHERE NVL( AIL.discarded_flag, 'N' ) <> 'Y'