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.

[Home] [Help]

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:

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

533:
534: DELETE from ZX_REP_TRX_DETAIL_T DET
535: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and
536: NOT (DET.EXTRACT_SOURCE_LEDGER = 'AP' and
537: DET.TRX_LINE_CLASS IN ('STANDARD INVOICES', 'AP_CREDIT_MEMO', 'AP_DEBIT_MEMO') and
538: substrb(DET.DOCUMENT_SUB_TYPE, 10, 2) in ('21','22','23','24','25','26','27','28')
539: );
540:
541: IF ( g_level_statement>= g_current_runtime_level ) THEN

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

563: 'DELETE from ZX_REP_TRX_DETAIL_T DET
564: WHERE DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
565: NOT EXISTS (SELECT 1 FROM AP_INVOICES ai
566: WHERE DET.EXTRACT_SOURCE_LEDGER = ''AP'' and
567: DET.TRX_LINE_CLASS IN (''STANDARD INVOICES'',''AP_CREDIT_MEMO'', ''AP_DEBIT_MEMO'') and
568: (DET.APPLIED_TO_TRX_NUMBER = ai.invoice_num OR DET.TRX_NUMBER = ai.invoice_num) and
569: DET.BILLING_TRADING_PARTNER_ID = ai.vendor_id and
570: substrb(DET.DOCUMENT_SUB_TYPE,10,2) IN (''23'',''24'') '||
571: lp_gui_type_where ||

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

569: DET.BILLING_TRADING_PARTNER_ID = ai.vendor_id and
570: substrb(DET.DOCUMENT_SUB_TYPE,10,2) IN (''23'',''24'') '||
571: lp_gui_type_where ||
572: lp_reprint_where||')';
573: /*Bug 5439099 added the or condition check for trx number to accept standard invoices of type 23,24*/
574:
575: EXECUTE IMMEDIATE l_delete_sql_string;
576:
577: IF ( g_level_statement>= g_current_runtime_level ) THEN

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