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.JAI_AP_IL_ORG_PKG dependencies on AP_INVOICE_LINES

Line 123: where exists (select 1 from ap_invoice_lines ap, jai_ap_invoice_lines jap

119: v_misc_line number(10);
120: BEGIN
121: Begin
122: select 1 into v_misc_line from dual
123: where exists (select 1 from ap_invoice_lines ap, jai_ap_invoice_lines jap
124: where jap.invoice_id = P_INVOICE_ID --:INV_SUM_FOLDER.INVOICE_ID
125: and jap.line_type_lookup_code = P_LOOKUP_CODE --:LINE_SUM_FOLDER.LINE_TYPE_LOOKUP_CODE
126: and jap.invoice_line_number = P_LINE_NUMBER --:LINE_SUM_FOLDER.LINE_NUMBER
127: and ap.invoice_id = jap.invoice_id

Line 157: where exists ( select 1 from jai_ap_invoice_lines jp where jp.invoice_id = P_INVOICE_ID and line_type_lookup_code ='MISCELLANEOUS' );

153: v_check number(10);
154: BEGIN
155: Begin
156: select 1 into v_check from dual
157: where exists ( select 1 from jai_ap_invoice_lines jp where jp.invoice_id = P_INVOICE_ID and line_type_lookup_code ='MISCELLANEOUS' );
158: Exception
159: When no_data_found then
160: v_check := 0;
161: End;

Line 187: select tax_category_id from jai_ap_invoice_lines

183: p_line_number NUMBER
184: )return number as
185: -- when user changes the tax_category_id
186: cursor get_trx_tax_ctg_id ( p_invoice_id NUMBER , p_line_number NUMBER) is
187: select tax_category_id from jai_ap_invoice_lines
188: where invoice_id =p_invoice_id
189: and invoice_line_number =p_line_number
190: and LINE_TYPE_LOOKUP_CODE = 'ITEM';
191: