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.JL_ZZ_TAX_VALIDATE_PKG dependencies on ZX_IMPORT_TAX_LINES_GT

Line 139: FROM zx_import_tax_lines_gt;

135:
136: -- Get the count of manual tax lines in global variable
137: SELECT Count(*)
138: INTO g_tax_lines_count
139: FROM zx_import_tax_lines_gt;
140:
141: validate_pfc_tbc (x_return_status);
142:
143: default_tax_attr (x_return_status);

Line 454: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines_gt

450: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR: Defaulting for Tax Regime Code and Tax');
451: END IF;
452:
453: -- Defaulting the Tax_regime_code and Tax if tax_rate_code is passed
454: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines_gt
455: USING (SELECT rates.tax_regime_code tax_regime_code,
456: rates.tax tax,
457: TaxLines.trx_id trx_id,
458: TaxLines.summary_tax_line_number summary_tax_line_number

Line 460: ZX_IMPORT_TAX_LINES_GT TaxLines,

456: rates.tax tax,
457: TaxLines.trx_id trx_id,
458: TaxLines.summary_tax_line_number summary_tax_line_number
459: FROM
460: ZX_IMPORT_TAX_LINES_GT TaxLines,
461: ZX_TRX_HEADERS_GT Header,
462: AR_VAT_TAX rates
463: WHERE
464: TaxLines.tax_rate_code = rates.tax_code(+)

Line 489: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines_gt

485: 'DML performed on rows(1):'||SQL%ROWCOUNT);
486: END IF;
487:
488: -- Defaulting the Tax_regime_code and Tax if tax_rate_id is passed
489: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines_gt
490: USING (SELECT rates.tax_regime_code tax_regime_code,
491: rates.tax tax,
492: TaxLines.trx_id trx_id,
493: TaxLines.summary_tax_line_number summary_tax_line_number

Line 495: ZX_IMPORT_TAX_LINES_GT TaxLines,

491: rates.tax tax,
492: TaxLines.trx_id trx_id,
493: TaxLines.summary_tax_line_number summary_tax_line_number
494: FROM
495: ZX_IMPORT_TAX_LINES_GT TaxLines,
496: ZX_TRX_HEADERS_GT Header,
497: AR_VAT_TAX rates
498: WHERE
499: TaxLines.tax_rate_id = rates.vat_tax_id(+)

Line 531: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines_gt

527: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
528: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR: Defaulting for Tax Status Code');
529: END IF;
530:
531: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines_gt
532: USING (SELECT Rates.tax_status_code tax_status_code,
533: TaxLines.trx_id trx_id,
534: TaxLines.summary_tax_line_number summary_tax_line_number
535: FROM

Line 536: ZX_IMPORT_TAX_LINES_GT TaxLines,

532: USING (SELECT Rates.tax_status_code tax_status_code,
533: TaxLines.trx_id trx_id,
534: TaxLines.summary_tax_line_number summary_tax_line_number
535: FROM
536: ZX_IMPORT_TAX_LINES_GT TaxLines,
537: AR_VAT_TAX Rates,
538: ZX_TRX_HEADERS_GT Header
539: WHERE
540: Taxlines.tax_regime_Code = Rates.tax_regime_code(+)

Line 572: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines_gt

568: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
569: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR: Defaulting for Tax Rate Code, Tax Rate Id, Percentage Rate');
570: END IF;
571:
572: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines_gt
573: USING (SELECT Rates.tax_code,
574: Rates.vat_tax_id,
575: Rates.tax_rate,
576: TaxLines.trx_id,

Line 580: ZX_IMPORT_TAX_LINES_GT TaxLines,

576: TaxLines.trx_id,
577: TaxLines.summary_tax_line_number
578: FROM
579: AR_VAT_TAX Rates,
580: ZX_IMPORT_TAX_LINES_GT TaxLines,
581: ZX_TRX_HEADERS_GT Header
582: WHERE
583: Taxlines.tax_regime_Code = Rates.tax_regime_code(+)
584: AND Taxlines.tax = Rates.tax(+)

Line 613: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines_gt

609: 'DML performed on rows:'||SQL%ROWCOUNT);
610: END IF;
611:
612: -- Default tax amount if it is NULL and tax rate is specified
613: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines_gt
614: USING (SELECT
615: TaxLines.tax_rate,
616: TaxLines.tax_amt_included_flag,
617: TaxLines.trx_id,

Line 621: ZX_IMPORT_TAX_LINES_GT TaxLines,

617: TaxLines.trx_id,
618: Lines.line_amt,
619: TaxLines.summary_tax_line_number
620: FROM
621: ZX_IMPORT_TAX_LINES_GT TaxLines,
622: ZX_TRX_HEADERS_GT Header,
623: ZX_TRANSACTION_LINES_GT Lines
624: WHERE
625: Taxlines.tax_line_allocation_flag = 'N' AND

Line 2150: ZX_IMPORT_TAX_LINES_GT taxlines_gt,

2146: ZX_REGIMES_B regime,
2147: ZX_TAXES_B tax,
2148: ZX_STATUS_B status,
2149: ZX_TRANSACTION_LINES_GT lines_gt,
2150: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2151: ZX_SUBSCRIPTION_DETAILS sd_reg,
2152: ZX_SUBSCRIPTION_DETAILS sd_tax,
2153: ZX_SUBSCRIPTION_DETAILS sd_status
2154:

Line 2450: ZX_IMPORT_TAX_LINES_GT taxlines_gt,

2446: ELSE 'N' END,
2447: 'N') TAX_RATE_PERCENTAGE_INVALID
2448: FROM ZX_TRX_HEADERS_GT header,
2449: ZX_RATES_B rate ,
2450: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2451: ZX_TRANSACTION_LINES_GT lines_gt,
2452: ZX_SUBSCRIPTION_DETAILS sd_rates
2453: WHERE taxlines_gt.trx_id = header.trx_id
2454: AND taxlines_gt.application_id = Header.application_id

Line 2660: zx_import_tax_lines_gt taxlines_gt

2656: /* end bug 3676878 */
2657: FROM
2658: zx_trx_headers_gt header,
2659: zx_transaction_lines_gt lines_gt,
2660: zx_import_tax_lines_gt taxlines_gt
2661: WHERE
2662: taxlines_gt.application_id = header.application_id
2663: AND taxlines_gt.entity_code = header.entity_code
2664: AND taxlines_gt.event_class_code = header.event_class_code