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.ZX_JA_EXTRACT_PKG dependencies on STANDARD

Line 405: DET.TRX_LINE_CLASS in ('STANDARD INVOICES','AP_CREDIT_MEMO', 'AP_DEBIT_MEMO') and

401: )
402: or
403: (DET.EXTRACT_SOURCE_LEDGER = 'AP' and
404: DET.POSTED_FLAG = 'Y' and
405: DET.TRX_LINE_CLASS in ('STANDARD INVOICES','AP_CREDIT_MEMO', 'AP_DEBIT_MEMO') and
406: substrb(DET.DOCUMENT_SUB_TYPE, 10,2) IN ('21','22', '23','24','25','26','27','28'))
407: );
408:
409: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 525: DET.TRX_LINE_CLASS IN ('STANDARD INVOICES', 'AP_CREDIT_MEMO', 'AP_DEBIT_MEMO') and

521:
522: DELETE from ZX_REP_TRX_DETAIL_T DET
523: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and
524: NOT (DET.EXTRACT_SOURCE_LEDGER = 'AP' and
525: DET.TRX_LINE_CLASS IN ('STANDARD INVOICES', 'AP_CREDIT_MEMO', 'AP_DEBIT_MEMO') and
526: substrb(DET.DOCUMENT_SUB_TYPE, 10, 2) in ('21','22','23','24','25','26','27','28')
527: );
528:
529: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 555: DET.TRX_LINE_CLASS IN (''STANDARD INVOICES'',''AP_CREDIT_MEMO'', ''AP_DEBIT_MEMO'') and

551: 'DELETE from ZX_REP_TRX_DETAIL_T DET
552: WHERE DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
553: NOT EXISTS (SELECT 1 FROM AP_INVOICES ai
554: WHERE DET.EXTRACT_SOURCE_LEDGER = ''AP'' and
555: DET.TRX_LINE_CLASS IN (''STANDARD INVOICES'',''AP_CREDIT_MEMO'', ''AP_DEBIT_MEMO'') and
556: (DET.APPLIED_TO_TRX_NUMBER = ai.invoice_num OR DET.TRX_NUMBER = ai.invoice_num) and
557: DET.BILLING_TRADING_PARTNER_ID = ai.vendor_id and
558: substrb(DET.DOCUMENT_SUB_TYPE,10,2) IN (''23'',''24'') '||
559: lp_gui_type_where ||

Line 561: /Bug 5439099 added the or condition check for trx number to accept standard invoices of type 23,24/

557: DET.BILLING_TRADING_PARTNER_ID = ai.vendor_id and
558: substrb(DET.DOCUMENT_SUB_TYPE,10,2) IN (''23'',''24'') '||
559: lp_gui_type_where ||
560: lp_reprint_where||')';
561: /*Bug 5439099 added the or condition check for trx number to accept standard invoices of type 23,24*/
562:
563: EXECUTE IMMEDIATE l_delete_sql_string;
564:
565: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 584: DET.TRX_LINE_CLASS IN ('STANDARD INVOICES', 'AP_CREDIT_MEMO', 'AP_DEBIT_MEMO') and