APPS.ZX_JG_EXTRACT_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 655: zx_rep_trx_detail_t itf

651: itf.tax_amt_funcl_curr
652: FROM gl_je_headers header,
653: gl_je_lines trx_line,
654: gl_je_lines tax_line,
655: zx_rep_trx_detail_t itf
656: WHERE header.je_header_id = c_trx_id
657: AND tax_line.je_header_id = header.je_header_id
658: AND tax_line.je_line_num = c_tax_line_id
659: AND tax_line.je_header_id = trx_line.je_header_id

Line 1626: FROM zx_rep_trx_detail_t

1622: tax_amt_funcl_curr,
1623: tax_rate_id,
1624: extract_source_ledger,
1625: ledger_id
1626: FROM zx_rep_trx_detail_t
1627: WHERE request_id = c_request_id
1628: AND extract_source_ledger = c_source_ledger;
1629:
1630: BEGIN

Line 1763: FROM zx_rep_trx_detail_t itf

1759: itf.taxable_amt,
1760: itf.taxable_amt_funcl_curr,
1761: itf.tax_amt,
1762: itf.tax_amt_funcl_curr
1763: FROM zx_rep_trx_detail_t itf
1764: WHERE itf.request_id = g_request_id
1765: and itf.extract_source_ledger = 'GL'
1766: and itf.application_id = 101
1767: and itf.entity_code = 'GL_JE_LINES'

Line 1901: FROM zx_rep_trx_detail_t trl_tmp,

1897: NVL(zx_dist.RECOVERABLE_FLAG,'N'),
1898: zx_dist.rec_nrec_tax_dist_id,
1899: trl_tmp.detail_tax_line_id
1900: ) AS tax_line_change
1901: FROM zx_rep_trx_detail_t trl_tmp,
1902: zx_rep_actg_ext_t act,
1903: zx_rec_nrec_dist zx_dist,
1904: xla_distribution_links lnk,
1905: xla_ae_headers aeh,

Line 1961: FROM zx_rep_trx_detail_t trl_tmp,

1957: NVL(zx_dist.RECOVERABLE_FLAG,'N'),
1958: zx_dist.rec_nrec_tax_dist_id,
1959: trl_tmp.detail_tax_line_id
1960: ) AS tax_line_change
1961: FROM zx_rep_trx_detail_t trl_tmp,
1962: zx_rep_actg_ext_t act,
1963: zx_rec_nrec_dist zx_dist,
1964: ap_invoice_distributions_all ap_dist,
1965: ap_prepay_app_dists pre_dist,