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.ZX_TRD_INTERNAL_SERVICES_PVT dependencies on ZX_REC_NREC_DIST

Line 113: FROM zx_rec_nrec_dist

109: l_max_tax_dist_number NUMBER;
110:
111: CURSOR get_tax_distribution_cur is
112: SELECT *
113: FROM zx_rec_nrec_dist
114: WHERE NVL(reverse_flag,'N') = 'N'
115: AND tax_line_id = p_detail_tax_line_tbl(p_tax_line_index).tax_line_id
116: AND trx_line_dist_id =
117: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(

Line 123: FROM zx_rec_nrec_dist

119: ORDER BY rec_nrec_tax_dist_id, recoverable_flag;
120:
121: CURSOR get_maximum_tax_dist_num_csr is
122: SELECT max(rec_nrec_tax_dist_number)
123: FROM zx_rec_nrec_dist
124: WHERE tax_line_id = p_detail_tax_line_tbl(p_tax_line_index).tax_line_id
125: AND trx_line_dist_id =
126: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(
127: p_trx_line_dist_index);

Line 386: SELECT zx_rec_nrec_dist_s.nextval INTO

382: IF NVL(p_rec_nrec_dist_tbl(i).summary_tax_line_id, -999999) <>
383: NVL(p_detail_tax_line_tbl(p_tax_line_index).summary_tax_line_id, -999999)
384: THEN
385:
386: SELECT zx_rec_nrec_dist_s.nextval INTO
387: p_rec_nrec_dist_tbl(i).rec_nrec_tax_dist_id FROM DUAL;
388:
389: END IF;
390:

Line 396: SELECT zx_rec_nrec_dist_s.nextval INTO l_tax_dist_id from dual;

392:
393:
394: p_rec_nrec_dist_tbl(i).reverse_flag:= 'Y';
395:
396: SELECT zx_rec_nrec_dist_s.nextval INTO l_tax_dist_id from dual;
397:
398: l_new_index:= i + l_total_count;
399: p_rec_nrec_dist_tbl(l_new_index):= p_rec_nrec_dist_tbl(i);
400: p_rec_nrec_dist_tbl(l_new_index).rec_nrec_tax_dist_id:= l_tax_dist_id;

Line 456: SELECT zx_rec_nrec_dist_s.nextval INTO l_tax_dist_id from dual;

452: -- -p_rec_nrec_dist_tbl(l_new_index).exchange_rate_variance;
453:
454: l_new_index:= l_new_index + l_total_count;
455:
456: SELECT zx_rec_nrec_dist_s.nextval INTO l_tax_dist_id from dual;
457:
458: p_rec_nrec_dist_tbl(l_new_index) := p_rec_nrec_dist_tbl(i);
459: p_rec_nrec_dist_tbl(l_new_index).rec_nrec_tax_dist_id := l_tax_dist_id;
460: p_rec_nrec_dist_tbl(l_new_index).freeze_flag := 'N';

Line 596: FROM zx_rec_nrec_dist

592: CURSOR get_maximum_tax_dist_num_csr (
593: c_tax_line_id NUMBER,
594: c_trx_line_dist_id NUMBER) IS
595: SELECT max(rec_nrec_tax_dist_number)
596: FROM zx_rec_nrec_dist
597: WHERE tax_line_id = c_tax_line_id
598: AND trx_line_dist_id = c_trx_line_dist_id;
599:
600: Cursor get_tax_distributions_cur IS

Line 601: SELECT * FROM zx_rec_nrec_dist

597: WHERE tax_line_id = c_tax_line_id
598: AND trx_line_dist_id = c_trx_line_dist_id;
599:
600: Cursor get_tax_distributions_cur IS
601: SELECT * FROM zx_rec_nrec_dist
602: WHERE trx_id = p_event_class_rec.trx_id
603: AND application_id = p_event_class_rec.application_id
604: AND entity_code = p_event_class_rec.entity_code
605: AND event_class_code = p_event_class_rec.event_class_code

Line 643: SELECT zx_rec_nrec_dist_s.NEXTVAL INTO p_rec_nrec_dist_tbl(i).rec_nrec_tax_dist_id FROM DUAL;

639: i1 := i;
640: i:= i1 + 1;
641: p_rec_nrec_dist_tbl(i):= p_rec_nrec_dist_tbl(i1);
642:
643: SELECT zx_rec_nrec_dist_s.NEXTVAL INTO p_rec_nrec_dist_tbl(i).rec_nrec_tax_dist_id FROM DUAL;
644:
645: p_rec_nrec_dist_tbl(i).reversed_tax_dist_id:= p_rec_nrec_dist_tbl(i1).rec_nrec_tax_dist_id;
646: p_rec_nrec_dist_tbl(i).rec_nrec_tax_amt:= -p_rec_nrec_dist_tbl(i1).rec_nrec_tax_amt;
647: p_rec_nrec_dist_tbl(i).REC_NREC_TAX_AMT_TAX_CURR:= -p_rec_nrec_dist_tbl(i1).REC_NREC_TAX_AMT_TAX_CURR;

Line 766: FROM zx_rec_nrec_dist

762: WHERE tax_id = c_tax_id;
763:
764: CURSOR get_maximum_tax_dist_num_csr is
765: SELECT max(rec_nrec_tax_dist_number)
766: FROM zx_rec_nrec_dist
767: WHERE tax_line_id = p_detail_tax_line_tbl(p_tax_line_index).tax_line_id
768: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(
769: p_trx_line_dist_index);
770:

Line 1615: c_recovery_rate_id zx_rec_nrec_dist.recovery_rate_id%TYPE,

1611: WHERE tax_id = c_tax_id;
1612:
1613: -- bug 5508356
1614: CURSOR get_tax_account_entity_id_csr(
1615: c_recovery_rate_id zx_rec_nrec_dist.recovery_rate_id%TYPE,
1616: c_ledger_id zx_rec_nrec_dist.ledger_id%TYPE,
1617: c_internal_org_id zx_rec_nrec_dist.internal_organization_id%TYPE) IS
1618: SELECT tax_account_entity_id
1619: FROM zx_accounts

Line 1616: c_ledger_id zx_rec_nrec_dist.ledger_id%TYPE,

1612:
1613: -- bug 5508356
1614: CURSOR get_tax_account_entity_id_csr(
1615: c_recovery_rate_id zx_rec_nrec_dist.recovery_rate_id%TYPE,
1616: c_ledger_id zx_rec_nrec_dist.ledger_id%TYPE,
1617: c_internal_org_id zx_rec_nrec_dist.internal_organization_id%TYPE) IS
1618: SELECT tax_account_entity_id
1619: FROM zx_accounts
1620: WHERE tax_account_entity_id = c_recovery_rate_id

Line 1617: c_internal_org_id zx_rec_nrec_dist.internal_organization_id%TYPE) IS

1613: -- bug 5508356
1614: CURSOR get_tax_account_entity_id_csr(
1615: c_recovery_rate_id zx_rec_nrec_dist.recovery_rate_id%TYPE,
1616: c_ledger_id zx_rec_nrec_dist.ledger_id%TYPE,
1617: c_internal_org_id zx_rec_nrec_dist.internal_organization_id%TYPE) IS
1618: SELECT tax_account_entity_id
1619: FROM zx_accounts
1620: WHERE tax_account_entity_id = c_recovery_rate_id
1621: AND tax_account_entity_code = 'RATES'

Line 2288: SELECT zx_rec_nrec_dist_s.nextval INTO

2284:
2285: p_rec_nrec_dist_tbl(p_rnd_end_index):= p_rec_nrec_dist_tbl(p_rnd_end_index - 1);
2286:
2287: -- bug 5417252
2288: SELECT zx_rec_nrec_dist_s.nextval INTO
2289: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_tax_dist_id from dual;
2290:
2291: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_tax_dist_number :=
2292: p_rec_nrec_dist_tbl(p_rnd_end_index-1).rec_nrec_tax_dist_number + 1;

Line 2463: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;

2459:
2460: l_rounding_rule_code zx_taxes_b.rounding_rule_code%TYPE;
2461: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2462: l_precision zx_taxes_b.tax_precision%TYPE;
2463: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2464: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2465: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2466: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2467: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;

Line 2464: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;

2460: l_rounding_rule_code zx_taxes_b.rounding_rule_code%TYPE;
2461: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2462: l_precision zx_taxes_b.tax_precision%TYPE;
2463: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2464: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2465: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2466: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2467: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;
2468: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;

Line 2465: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;

2461: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2462: l_precision zx_taxes_b.tax_precision%TYPE;
2463: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2464: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2465: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2466: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2467: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;
2468: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;
2469: l_taxable_amt_tax_currency zx_rec_nrec_dist.taxable_amt_tax_curr%TYPE;

Line 2466: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;

2462: l_precision zx_taxes_b.tax_precision%TYPE;
2463: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2464: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2465: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2466: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2467: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;
2468: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;
2469: l_taxable_amt_tax_currency zx_rec_nrec_dist.taxable_amt_tax_curr%TYPE;
2470: l_tax_id zx_taxes_b.tax_id%TYPE;

Line 2467: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;

2463: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2464: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2465: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2466: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2467: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;
2468: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;
2469: l_taxable_amt_tax_currency zx_rec_nrec_dist.taxable_amt_tax_curr%TYPE;
2470: l_tax_id zx_taxes_b.tax_id%TYPE;
2471:

Line 2468: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;

2464: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2465: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2466: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2467: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;
2468: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;
2469: l_taxable_amt_tax_currency zx_rec_nrec_dist.taxable_amt_tax_curr%TYPE;
2470: l_tax_id zx_taxes_b.tax_id%TYPE;
2471:
2472: BEGIN

Line 2469: l_taxable_amt_tax_currency zx_rec_nrec_dist.taxable_amt_tax_curr%TYPE;

2465: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2466: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2467: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;
2468: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;
2469: l_taxable_amt_tax_currency zx_rec_nrec_dist.taxable_amt_tax_curr%TYPE;
2470: l_tax_id zx_taxes_b.tax_id%TYPE;
2471:
2472: BEGIN
2473: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 4774: FROM zx_rec_nrec_dist

4770: rec_nrec_tax_amt_funcl_curr,
4771: trx_line_dist_amt,
4772: def_rec_settlement_option_code,
4773: account_source_tax_rate_id
4774: FROM zx_rec_nrec_dist
4775: WHERE application_id =
4776: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
4777: p_trx_line_dist_index)
4778: AND entity_code =

Line 4931: FROM zx_rec_nrec_dist

4927: rec_nrec_rate,
4928: rec_nrec_tax_dist_id,
4929: def_rec_settlement_option_code,
4930: account_source_tax_rate_id
4931: FROM zx_rec_nrec_dist
4932: WHERE application_id =
4933: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
4934: p_trx_line_dist_index)
4935: AND entity_code =

Line 5047: FROM zx_rec_nrec_dist

5043: rec_nrec_tax_dist_id,
5044: rec_nrec_rate,
5045: orig_rec_nrec_rate,
5046: rec_rate_result_id
5047: FROM zx_rec_nrec_dist
5048: WHERE application_id =
5049: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(
5050: p_trx_line_dist_index)
5051: AND entity_code =

Line 5076: FROM zx_rec_nrec_dist

5072: ORDER BY rec_nrec_tax_dist_id, recoverable_flag;
5073:
5074: CURSOR get_maximum_tax_dist_num_csr is
5075: SELECT max(rec_nrec_tax_dist_number)
5076: FROM zx_rec_nrec_dist
5077: WHERE tax_line_id = p_detail_tax_line_tbl(p_tax_line_index).tax_line_id
5078: AND trx_line_dist_id =
5079: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(p_trx_line_dist_index);
5080:

Line 5696: UPDATE zx_rec_nrec_dist_gt gt

5692:
5693: -- Bugfix 5035461: added recoverable_flag and reverse_flag condition in
5694: -- the subquery.
5695:
5696: UPDATE zx_rec_nrec_dist_gt gt
5697: SET per_trx_curr_unit_nr_amt =
5698: -- Bugfix 5218651: for amount based matching, when dist qty is 0 or null, return rec_nrec_tax_amt as per unit nr amount
5699: DECODE(gt.trx_line_dist_qty*gt.unit_price,0, gt.rec_nrec_tax_amt,
5700: gt.rec_nrec_tax_amt/(gt.trx_line_dist_qty*gt.unit_price)),

Line 5717: FROM zx_rec_nrec_dist dist

5713: DECODE(gt.ref_doc_trx_line_dist_qty*dist.unit_price, 0, dist.rec_nrec_tax_amt,
5714: dist.rec_nrec_tax_amt/(gt.ref_doc_trx_line_dist_qty*dist.unit_price))),
5715: DECODE(gt.ref_doc_trx_line_dist_qty, 0, dist.rec_nrec_tax_amt,
5716: dist.rec_nrec_tax_amt/gt.ref_doc_trx_line_dist_qty)
5717: FROM zx_rec_nrec_dist dist
5718: WHERE dist.application_id = gt.ref_doc_application_id
5719: AND dist.entity_code = gt.ref_doc_entity_code
5720: AND dist.event_class_code = gt.ref_doc_event_class_code
5721: AND dist.trx_id = gt.ref_doc_trx_id

Line 5739: UPDATE zx_rec_nrec_dist_gt gt

5735: AND mrc_tax_dist_flag = 'N';
5736:
5737: -- update ref_doc_unit_price if it is null (PO has no tax)
5738: --
5739: UPDATE zx_rec_nrec_dist_gt gt
5740: SET ref_doc_unit_price =
5741: (SELECT unit_price
5742: FROM zx_lines_det_factors line
5743: WHERE line.application_id = gt.ref_doc_application_id

Line 5859: SELECT zx_rec_nrec_dist_s.NEXTVAL INTO

5855: p_rec_nrec_dist_tbl(p_rnd_end_index) := p_rec_nrec_dist_tbl(j);
5856:
5857: -- set MRC related columns
5858: --
5859: SELECT zx_rec_nrec_dist_s.NEXTVAL INTO
5860: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_tax_dist_id FROM DUAL;
5861:
5862: p_rec_nrec_dist_tbl(p_rnd_end_index).unrounded_rec_nrec_tax_amt :=
5863: p_rec_nrec_dist_tbl(j).unrounded_rec_nrec_tax_amt *