APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on ZX_TRX_HEADERS_GT

Line 252: UPDATE ZX_TRX_HEADERS_GT Header

248: END IF;
249:
250: -- Defaulting the taxation country
251: -- Bugfix 3971179
252: UPDATE ZX_TRX_HEADERS_GT Header
253: SET default_taxation_country =
254: (SELECT
255: decode(syspa.global_attribute13,
256: 'ARGENTINA', 'AR',

Line 291: ZX_TRX_HEADERS_GT Header,

287: rates.tax tax,
288: TaxLines.trx_id trx_id
289: FROM
290: ZX_IMPORT_TAX_LINES_GT TaxLines,
291: ZX_TRX_HEADERS_GT Header,
292: AR_VAT_TAX_ALL_B rates
293: WHERE
294: TaxLines.tax_rate_code = rates.tax_code(+)
295: AND Header.trx_date between nvl(rates.start_date,Header.trx_date)

Line 330: ZX_TRX_HEADERS_GT Header

326: TaxLines.trx_id trx_id
327: FROM
328: ZX_IMPORT_TAX_LINES_GT TaxLines,
329: ZX_STATUS_B Status,
330: ZX_TRX_HEADERS_GT Header
331: WHERE
332: Status.tax_regime_code = TaxLines.tax_regime_code
333: AND Status.tax = TaxLines.tax
334: AND Status.default_status_flag = 'Y'

Line 356: ZX_TRX_HEADERS_GT Header

352: SET tax_status_code =
353: (SELECT tax_status_code
354: FROM
355: ZX_STATUS_B Status,
356: ZX_TRX_HEADERS_GT Header
357: WHERE
358: Status.tax_regime_code = TaxLines.tax_regime_code
359: AND Status.tax = TaxLines.tax
360: AND Status.default_status_flag = 'Y'

Line 391: ZX_TRX_HEADERS_GT Header

387: TaxLines.trx_id
388: FROM
389: AR_VAT_TAX_ALL_B Rates,
390: ZX_IMPORT_TAX_LINES_GT TaxLines,
391: ZX_TRX_HEADERS_GT Header
392: WHERE
393: Taxlines.tax_regime_Code = Rates.tax_regime_code
394: AND Taxlines.tax = Rates.tax
395: AND Taxlines.tax_status_code = Rates.tax_status_code

Line 509: zx_trx_headers_gt header

505: FROM
506: zx_fc_product_fiscal_v fc,
507: mtl_item_categories mic,
508: zx_transaction_lines_gt lines ,
509: zx_trx_headers_gt header
510: WHERE
511: ((fc.country_code = Header.default_taxation_country
512: AND fc.country_code in ('AR', 'BR', 'CO'))
513: or

Line 620: FROM ZX_TRX_HEADERS_GT H,

616:
617: MERGE INTO ZX_TRANSACTION_LINES_GT Lines
618: USING (SELECT CTT.global_attribute4 output_tax_classification_code,
619: H.trx_id
620: FROM ZX_TRX_HEADERS_GT H,
621: RA_CUST_TRX_TYPES_ALL CTT,
622: AR_VAT_TAX_ALL_B VT
623: WHERE CTT.cust_trx_type_id = H.receivables_trx_type_id
624: AND CTT.org_id = VT.org_id

Line 1941: ZX_TRX_HEADERS_GT header,

1937: ELSE NULL
1938: END TAX_JUR_CODE_NA_FOR_LTE
1939:
1940: FROM
1941: ZX_TRX_HEADERS_GT header,
1942: ZX_EVNT_CLS_MAPPINGS evntmap,
1943: ZX_REGIMES_B regime ,
1944: ZX_TAXES_B tax ,
1945: ZX_STATUS_B status ,

Line 2219: zx_trx_headers_gt header,

2215: 'N'
2216: END IMP_TAX_MISSING_IN_ADJUSTED_TO
2217: /* end bug 3676878 */
2218: FROM
2219: zx_trx_headers_gt header,
2220: zx_transaction_lines_gt lines_gt,
2221: zx_import_tax_lines_gt imptaxes_gt
2222: WHERE
2223: imptaxes_gt.application_id = header.application_id