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_INVOICE_LINES_UTILITY_PKG dependencies on AP_INVOICE_LINES_ALL

Line 1260: debug_info := 'Select from ap_invoice_lines_all';

1256: current_calling_sequence :=
1257: 'AP_INVOICE_LINES_UTILITY_PKG.LINE_REFERRED_BY_CORR<-'
1258: ||p_Calling_Sequence;
1259:
1260: debug_info := 'Select from ap_invoice_lines_all';
1261:
1262: Select count(*)
1263: Into dummy
1264: From ap_invoice_lines_all AIL

Line 1264: From ap_invoice_lines_all AIL

1260: debug_info := 'Select from ap_invoice_lines_all';
1261:
1262: Select count(*)
1263: Into dummy
1264: From ap_invoice_lines_all AIL
1265: Where NVL(AIL.discarded_flag, 'N' ) <> 'Y'
1266: And NVL( AIL.cancelled_flag, 'N' ) <> 'Y'
1267: And AIL.corrected_inv_id = p_Invoice_Id
1268: And AIL.corrected_line_number = p_Line_Number;

Line 1935: FROM ap_invoice_lines_all

1931: BEGIN
1932:
1933: SELECT count(*)
1934: INTO l_count
1935: FROM ap_invoice_lines_all
1936: WHERE corrected_inv_id = p_invoice_id
1937: AND corrected_line_number = p_line_number
1938: AND line_type_lookup_code IN ('RETROITEM')
1939: AND line_source = 'PO PRICE ADJUSTMENT'

Line 1976: FROM ap_invoice_lines_all

1972: BEGIN
1973:
1974: SELECT 'Y'
1975: INTO is_po_price_adjustment
1976: FROM ap_invoice_lines_all
1977: WHERE invoice_id = p_invoice_id
1978: AND line_number = p_line_number
1979: AND line_type_lookup_code = 'RETROITEM'
1980: AND line_source = 'PO PRICE ADJUSTMENT'