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_TRX_HEADERS_GT

Line 100: FROM ZX_TRX_HEADERS_GT Header

96: -- Start : Code added to get the First-Party-Org-Id -- bug#7530930
97: BEGIN
98: SELECT legal_entity_id , internal_organization_id
99: INTO l_le_id, l_ou_id
100: FROM ZX_TRX_HEADERS_GT Header
101: WHERE rownum = 1;
102: EXCEPTION
103: WHEN NO_DATA_FOUND THEN
104: IF (g_level_exception >= g_current_runtime_level ) THEN

Line 149: UPDATE zx_trx_headers_gt

145: validate_tax_attr (x_return_status);
146:
147: -- Update the validation_check_flag to N for problematic trxs
148: -- so that these trxs should not be picked up for tax processing
149: UPDATE zx_trx_headers_gt
150: SET validation_check_flag = 'N'
151: WHERE trx_id IN (SELECT DISTINCT trx_id FROM zx_validation_errors_gt);
152:
153: IF ( SQL%ROWCOUNT > 0 ) THEN

Line 157: 'Updated the validation_check_flag to N in Zx_Trx_Headers_GT for '||to_char(SQL%ROWCOUNT)||' trx(s).');

153: IF ( SQL%ROWCOUNT > 0 ) THEN
154: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
155: IF (g_level_statement >= g_current_runtime_level) THEN
156: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
157: 'Updated the validation_check_flag to N in Zx_Trx_Headers_GT for '||to_char(SQL%ROWCOUNT)||' trx(s).');
158: END IF;
159: END IF ;
160:
161: -- Printing Error Messages in Zx_Validation_Errors_Gt

Line 306: zx_trx_headers_gt header,

302: AND NOT EXISTS
303: (
304: SELECT 1
305: FROM
306: zx_trx_headers_gt header,
307: zx_evnt_cls_mappings evntmap,
308: FND_LOOKUPS LK,
309: JL_ZZ_AR_TX_FSC_CLS FSC
310: where

Line 361: zx_trx_headers_gt header,

357: AND NOT EXISTS
358: (
359: SELECT 1
360: FROM
361: zx_trx_headers_gt header,
362: zx_evnt_cls_mappings evntmap,
363: FND_LOOKUPS LK,
364: JL_ZZ_AR_TX_FSC_CLS FSC
365: where

Line 426: UPDATE ZX_TRX_HEADERS_GT Header

422: END IF;
423:
424: -- Defaulting the taxation country
425: -- Bugfix 3971179
426: UPDATE ZX_TRX_HEADERS_GT Header
427: SET default_taxation_country =
428: (SELECT
429: decode(syspa.global_attribute13,
430: 'ARGENTINA', 'AR',

Line 461: ZX_TRX_HEADERS_GT Header,

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(+)
465: AND TaxLines.tax_rate_code IS NOT NULL

Line 496: ZX_TRX_HEADERS_GT Header,

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(+)
500: AND TaxLines.tax_rate_id IS NOT NULL

Line 538: ZX_TRX_HEADERS_GT Header

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(+)
541: AND Taxlines.tax = Rates.tax(+)
542: AND ((Taxlines.tax_rate_code IS NOT NULL AND Taxlines.tax_rate_code = rates.tax_code)

Line 581: ZX_TRX_HEADERS_GT Header

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(+)
585: AND Taxlines.tax_status_code = Rates.tax_status_code(+)

Line 622: ZX_TRX_HEADERS_GT Header,

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
626: TaxLines.tax_amt IS NULL AND

Line 710: zx_trx_headers_gt header

706: FROM
707: zx_fc_product_fiscal_v fc,
708: mtl_item_categories mic,
709: zx_transaction_lines_gt lines ,
710: zx_trx_headers_gt header
711: WHERE
712: ((fc.country_code = Header.default_taxation_country
713: AND fc.country_code in ('AR', 'BR', 'CO'))
714: or

Line 815: FROM ZX_TRX_HEADERS_GT H,

811:
812: MERGE INTO ZX_TRANSACTION_LINES_GT Lines
813: USING (SELECT CTT.global_attribute4 output_tax_classification_code,
814: H.trx_id
815: FROM ZX_TRX_HEADERS_GT H,
816: RA_CUST_TRX_TYPES CTT,
817: AR_VAT_TAX VT
818: WHERE CTT.cust_trx_type_id = H.receivables_trx_type_id
819: AND CTT.org_id = VT.org_id

Line 1783: ZX_TRX_HEADERS_GT header,

1779: ELSE NULL
1780: END TAX_RATE_CODE_NOT_ACTIVE
1781:
1782: FROM
1783: ZX_TRX_HEADERS_GT header,
1784: ZX_EVNT_CLS_MAPPINGS evntmap,
1785: ZX_TRANSACTION_LINES_GT lines_gt,
1786: GL_SETS_OF_BOOKS gsob
1787:

Line 2145: ZX_TRX_HEADERS_GT header,

2141: ELSE 'N'
2142: END TAX_JUR_CODE_NA_FOR_LTE
2143:
2144: FROM
2145: ZX_TRX_HEADERS_GT header,
2146: ZX_REGIMES_B regime,
2147: ZX_TAXES_B tax,
2148: ZX_STATUS_B status,
2149: ZX_TRANSACTION_LINES_GT lines_gt,

Line 2448: FROM ZX_TRX_HEADERS_GT header,

2444: nvl(rate.effective_to, header.trx_date))
2445: THEN 'Y'
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

Line 2658: zx_trx_headers_gt header,

2654: 'N'
2655: END IMP_TAX_MISSING_IN_ADJUSTED_TO
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