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_CORE_REP_EXTRACT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 234: from AP_INVOICE_DISTRIBUTIONS_ALL dist1

230: AND temp.extract_source_ledger = 'AP'
231: AND temp.entity_code = 'AP_INVOICES'
232: AND temp.application_id = 200
233: AND NOT EXISTS (select 1
234: from AP_INVOICE_DISTRIBUTIONS_ALL dist1
235: where dist1.invoice_distribution_id = temp.taxable_item_source_id
236: AND NVL(dist1.historical_flag,'N') = 'Y');
237:
238: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 249: FROM AP_INVOICE_DISTRIBUTIONS_ALL dist

245: IF P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEDGER_ID IS NULL THEN
246: UPDATE zx_rep_trx_detail_t dtl
247: SET (dtl.TAXABLE_AMT,dtl.TAXABLE_AMT_FUNCL_CURR)
248: = (SELECT dist.amount, nvl(dist.base_amount,dist.amount)
249: FROM AP_INVOICE_DISTRIBUTIONS_ALL dist
250: WHERE dist.invoice_distribution_id = dtl.taxable_item_source_id)
251: WHERE dtl.request_id = p_request_id
252: AND dtl.trx_line_class = 'PREPAY_APPLICATION'
253: AND dtl.extract_source_ledger = 'AP'

Line 258: from AP_INVOICE_DISTRIBUTIONS_ALL dist1

254: AND dtl.entity_code = 'AP_INVOICES'
255: AND dtl.application_id = 200
256: AND NVL(dtl.historical_flag,'N') = 'Y'
257: AND EXISTS (select 1
258: from AP_INVOICE_DISTRIBUTIONS_ALL dist1
259: where dist1.invoice_distribution_id = dtl.taxable_item_source_id
260: AND NVL(dist1.historical_flag,'N') = 'Y');
261:
262: ELSE

Line 267: FROM AP_INVOICE_DISTRIBUTIONS_ALL dist,

263:
264: UPDATE zx_rep_trx_detail_t dtl
265: SET (dtl.TAXABLE_AMT,dtl.TAXABLE_AMT_FUNCL_CURR)
266: = (SELECT sum(mc.amount), sum(nvl(mc.base_amount,mc.amount))
267: FROM AP_INVOICE_DISTRIBUTIONS_ALL dist,
268: AP_MC_INVOICE_DISTS mc
269: WHERE dtl.taxable_item_source_id = dist.invoice_distribution_id
270: AND dist.invoice_distribution_id = mc.invoice_distribution_id
271: AND mc.set_of_books_id = p_trl_global_variables_rec.reporting_ledger_id)

Line 279: from AP_INVOICE_DISTRIBUTIONS_ALL dist1

275: AND dtl.entity_code = 'AP_INVOICES'
276: AND dtl.application_id = 200
277: AND NVL(dtl.historical_flag,'N') = 'Y'
278: AND EXISTS (select 1
279: from AP_INVOICE_DISTRIBUTIONS_ALL dist1
280: where dist1.invoice_distribution_id = dtl.taxable_item_source_id
281: AND NVL(dist1.historical_flag,'N') = 'Y');
282:
283: END IF;

Line 430: from ap_invoice_distributions_all apd,

426: END IF;
427:
428: update zx_rep_actg_ext_t act
429: set act.period_name = (select apd.period_name
430: from ap_invoice_distributions_all apd,
431: zx_rep_trx_detail_t dtl
432: where dtl.trx_id = apd.invoice_id
433: and dtl.TAXABLE_ITEM_SOURCE_ID = apd.invoice_distribution_id
434: and act.detail_tax_line_id = dtl.detail_tax_line_id

Line 451: ap_invoice_distributions_all ap_dist,

447: SET ext.numeric1 =
448: (SELECT sum(nvl(lnk.UNROUNDED_accounted_DR,0)-nvl(lnk.UNROUNDED_accounted_CR,0))
449: FROM zx_rep_trx_detail_t dtl,
450: zx_rep_actg_ext_t act_ext,
451: ap_invoice_distributions_all ap_dist,
452: po_distributions_all pod,
453: xla_ae_headers aeh,
454: xla_ae_lines ael,
455: xla_distribution_links lnk

Line 494: FROM AP_INVOICE_DISTRIBUTIONS_ALL item,

490: dtl.TAXABLE_AMT_FUNCL_CURR = 0
491: WHERE dtl.request_id = p_request_id
492: AND NOT EXISTS
493: (SELECT /*+ FIRST_ROWS(1) */ 1
494: FROM AP_INVOICE_DISTRIBUTIONS_ALL item,
495: AP_INVOICE_DISTRIBUTIONS_ALL tax
496: WHERE tax.DETAIL_TAX_DIST_ID = DTL.ACTG_SOURCE_ID
497: AND item.PERIOD_NAME = tax.PERIOD_NAME
498: AND item.INVOICE_ID = tax.INVOICE_ID

Line 495: AP_INVOICE_DISTRIBUTIONS_ALL tax

491: WHERE dtl.request_id = p_request_id
492: AND NOT EXISTS
493: (SELECT /*+ FIRST_ROWS(1) */ 1
494: FROM AP_INVOICE_DISTRIBUTIONS_ALL item,
495: AP_INVOICE_DISTRIBUTIONS_ALL tax
496: WHERE tax.DETAIL_TAX_DIST_ID = DTL.ACTG_SOURCE_ID
497: AND item.PERIOD_NAME = tax.PERIOD_NAME
498: AND item.INVOICE_ID = tax.INVOICE_ID
499: and item.ORG_ID = tax.ORG_ID

Line 564: AP_INVOICE_DISTRIBUTIONS_ALL AP_DIST,

560: + NVL(( SELECT sum(nvl(lnk.UNROUNDED_accounted_DR,0)-nvl(lnk.UNROUNDED_accounted_CR,0)) *
561: decode(sign(nvl(dtl1.taxable_amt_funcl_curr,0)),0,1,sign(nvl(dtl1.taxable_amt_funcl_curr,0)))
562: FROM zx_rep_trx_detail_t dtl2,
563: zx_rep_actg_ext_t act_ext,
564: AP_INVOICE_DISTRIBUTIONS_ALL AP_DIST,
565: xla_distribution_links lnk,
566: xla_ae_headers aeh,
567: xla_ae_lines ael
568: WHERE ap_dist.invoice_id=dtl2.trx_id

Line 595: AP_INVOICE_DISTRIBUTIONS_ALL AP_DIST,

591: + NVL(( SELECT sum(nvl(lnk.UNROUNDED_ENTERED_DR,0)-nvl(lnk.UNROUNDED_ENTERED_CR,0)) *
592: decode(sign(nvl(dtl1.taxable_amt,0)),0,1,sign(nvl(dtl1.taxable_amt,0)))
593: FROM zx_rep_trx_detail_t dtl2,
594: zx_rep_actg_ext_t act_ext,
595: AP_INVOICE_DISTRIBUTIONS_ALL AP_DIST,
596: xla_distribution_links lnk,
597: xla_ae_headers aeh,
598: xla_ae_lines ael
599: WHERE ap_dist.invoice_id=dtl2.trx_id

Line 643: from ap_invoice_distributions_all ap_dist

639: SET dtl1.taxable_amt_funcl_curr =
640: decode(sign(nvl(dtl1.taxable_amt_funcl_curr,0)),0,1,sign(nvl(dtl1.taxable_amt_funcl_curr,0)))
641: *
642: abs((select SUM(NVL(ap_dist.base_amount, ap_dist.amount))
643: from ap_invoice_distributions_all ap_dist
644: where ap_dist.invoice_distribution_id = dtl1.taxable_item_source_id)
645: + NVL((select SUM(NVL(ap_dist1.base_amount, ap_dist1.amount))
646: from ap_invoice_distributions_all ap_dist1
647: where ap_dist1.invoice_id=dtl1.trx_id

Line 646: from ap_invoice_distributions_all ap_dist1

642: abs((select SUM(NVL(ap_dist.base_amount, ap_dist.amount))
643: from ap_invoice_distributions_all ap_dist
644: where ap_dist.invoice_distribution_id = dtl1.taxable_item_source_id)
645: + NVL((select SUM(NVL(ap_dist1.base_amount, ap_dist1.amount))
646: from ap_invoice_distributions_all ap_dist1
647: where ap_dist1.invoice_id=dtl1.trx_id
648: and ap_dist1.invoice_line_number=dtl1.trx_line_id
649: and ap_dist1.related_id=dtl1.taxable_item_source_id
650: and AP_DIST1.INVOICE_DISTRIBUTION_ID <> AP_DIST1.RELATED_ID

Line 656: from ap_invoice_distributions_all ap_dist

652: dtl1.taxable_amt =
653: decode(sign(nvl(dtl1.taxable_amt,0)),0,1,sign(nvl(dtl1.taxable_amt,0)))
654: *
655: abs((select SUM(ap_dist.amount)
656: from ap_invoice_distributions_all ap_dist
657: where ap_dist.invoice_distribution_id = dtl1.taxable_item_source_id)
658: + NVL((select SUM(ap_dist1.amount)
659: from ap_invoice_distributions_all ap_dist1
660: where ap_dist1.invoice_id=dtl1.trx_id

Line 659: from ap_invoice_distributions_all ap_dist1

655: abs((select SUM(ap_dist.amount)
656: from ap_invoice_distributions_all ap_dist
657: where ap_dist.invoice_distribution_id = dtl1.taxable_item_source_id)
658: + NVL((select SUM(ap_dist1.amount)
659: from ap_invoice_distributions_all ap_dist1
660: where ap_dist1.invoice_id=dtl1.trx_id
661: and ap_dist1.invoice_line_number=dtl1.trx_line_id
662: and ap_dist1.related_id=dtl1.taxable_item_source_id
663: and ap_dist1.invoice_distribution_id <> ap_dist1.related_id

Line 684: FROM AP_INVOICE_DISTRIBUTIONS_ALL AP_DIST

680: -- This update added to populate recovery rate for migrated AP invoices --
681: UPDATE ZX_REP_TRX_DETAIL_T DTL
682: SET DTL.TAX_RECOVERY_RATE =
683: ( SELECT AP_DIST.REC_NREC_RATE
684: FROM AP_INVOICE_DISTRIBUTIONS_ALL AP_DIST
685: WHERE AP_DIST.INVOICE_ID=DTL.TRX_ID
686: AND AP_DIST.DETAIL_TAX_DIST_ID =DTL.ACTG_SOURCE_ID
687: AND AP_DIST.LINE_TYPE_LOOKUP_CODE IN ('REC_TAX','NONREC_TAX')
688: --AND AP_DIST.HISTORICAL_FLAG = 'Y' -- Commented the condition for Bug#12878223