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 115: FROM zx_rec_nrec_dist

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

Line 125: FROM zx_rec_nrec_dist

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

Line 396: SELECT zx_rec_nrec_dist_s.nextval INTO

392: IF NVL(p_rec_nrec_dist_tbl(i).summary_tax_line_id, -999999) <>
393: NVL(p_detail_tax_line_tbl(p_tax_line_index).summary_tax_line_id, -999999)
394: THEN
395:
396: SELECT zx_rec_nrec_dist_s.nextval INTO
397: p_rec_nrec_dist_tbl(i).rec_nrec_tax_dist_id FROM DUAL;
398:
399: END IF;
400:

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

402:
403:
404: p_rec_nrec_dist_tbl(i).reverse_flag:= 'Y';
405:
406: SELECT zx_rec_nrec_dist_s.nextval INTO l_tax_dist_id from dual;
407:
408: l_new_index:= i + l_total_count;
409: p_rec_nrec_dist_tbl(l_new_index):= p_rec_nrec_dist_tbl(i);
410: p_rec_nrec_dist_tbl(l_new_index).rec_nrec_tax_dist_id:= l_tax_dist_id;

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

462: -- -p_rec_nrec_dist_tbl(l_new_index).exchange_rate_variance;
463:
464: l_new_index:= l_new_index + l_total_count;
465:
466: SELECT zx_rec_nrec_dist_s.nextval INTO l_tax_dist_id from dual;
467:
468: p_rec_nrec_dist_tbl(l_new_index) := p_rec_nrec_dist_tbl(i);
469: p_rec_nrec_dist_tbl(l_new_index).rec_nrec_tax_dist_id := l_tax_dist_id;
470: p_rec_nrec_dist_tbl(l_new_index).freeze_flag := 'N';

Line 650: FROM zx_rec_nrec_dist

646: CURSOR get_maximum_tax_dist_num_csr (
647: c_tax_line_id NUMBER,
648: c_trx_line_dist_id NUMBER) IS
649: SELECT max(rec_nrec_tax_dist_number)
650: FROM zx_rec_nrec_dist
651: WHERE tax_line_id = c_tax_line_id
652: AND trx_line_dist_id = c_trx_line_dist_id;
653:
654: Cursor get_tax_distributions_cur IS

Line 655: SELECT * FROM zx_rec_nrec_dist

651: WHERE tax_line_id = c_tax_line_id
652: AND trx_line_dist_id = c_trx_line_dist_id;
653:
654: Cursor get_tax_distributions_cur IS
655: SELECT * FROM zx_rec_nrec_dist
656: WHERE trx_id = p_event_class_rec.trx_id
657: AND application_id = p_event_class_rec.application_id
658: AND entity_code = p_event_class_rec.entity_code
659: AND event_class_code = p_event_class_rec.event_class_code

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

693: i1 := i;
694: i:= i1 + 1;
695: p_rec_nrec_dist_tbl(i):= p_rec_nrec_dist_tbl(i1);
696:
697: SELECT zx_rec_nrec_dist_s.NEXTVAL INTO p_rec_nrec_dist_tbl(i).rec_nrec_tax_dist_id FROM DUAL;
698:
699: p_rec_nrec_dist_tbl(i).reversed_tax_dist_id:= p_rec_nrec_dist_tbl(i1).rec_nrec_tax_dist_id;
700: p_rec_nrec_dist_tbl(i).rec_nrec_tax_amt:= -p_rec_nrec_dist_tbl(i1).rec_nrec_tax_amt;
701: 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 822: FROM zx_rec_nrec_dist

818: WHERE tax_id = c_tax_id;
819:
820: CURSOR get_maximum_tax_dist_num_csr is
821: SELECT max(rec_nrec_tax_dist_number)
822: FROM zx_rec_nrec_dist
823: WHERE tax_line_id = p_detail_tax_line_tbl(p_tax_line_index).tax_line_id
824: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(
825: p_trx_line_dist_index);
826:

Line 1700: c_recovery_rate_id zx_rec_nrec_dist.recovery_rate_id%TYPE,

1696: WHERE tax_id = c_tax_id;
1697:
1698: -- Added for Bug#5508356
1699: CURSOR get_tax_account_entity_id_csr(
1700: c_recovery_rate_id zx_rec_nrec_dist.recovery_rate_id%TYPE,
1701: c_ledger_id zx_rec_nrec_dist.ledger_id%TYPE,
1702: c_internal_org_id zx_rec_nrec_dist.internal_organization_id%TYPE) IS
1703: SELECT tax_account_entity_id
1704: FROM zx_accounts

Line 1701: c_ledger_id zx_rec_nrec_dist.ledger_id%TYPE,

1697:
1698: -- Added for Bug#5508356
1699: CURSOR get_tax_account_entity_id_csr(
1700: c_recovery_rate_id zx_rec_nrec_dist.recovery_rate_id%TYPE,
1701: c_ledger_id zx_rec_nrec_dist.ledger_id%TYPE,
1702: c_internal_org_id zx_rec_nrec_dist.internal_organization_id%TYPE) IS
1703: SELECT tax_account_entity_id
1704: FROM zx_accounts
1705: WHERE tax_account_entity_id = c_recovery_rate_id

Line 1702: c_internal_org_id zx_rec_nrec_dist.internal_organization_id%TYPE) IS

1698: -- Added for Bug#5508356
1699: CURSOR get_tax_account_entity_id_csr(
1700: c_recovery_rate_id zx_rec_nrec_dist.recovery_rate_id%TYPE,
1701: c_ledger_id zx_rec_nrec_dist.ledger_id%TYPE,
1702: c_internal_org_id zx_rec_nrec_dist.internal_organization_id%TYPE) IS
1703: SELECT tax_account_entity_id
1704: FROM zx_accounts
1705: WHERE tax_account_entity_id = c_recovery_rate_id
1706: AND tax_account_entity_code = 'RATES'

Line 2548: SELECT zx_rec_nrec_dist_s.nextval INTO

2544:
2545: p_rec_nrec_dist_tbl(p_rnd_end_index):= p_rec_nrec_dist_tbl(p_rnd_end_index - 1);
2546:
2547: -- bug 5417252
2548: SELECT zx_rec_nrec_dist_s.nextval INTO
2549: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_tax_dist_id from dual;
2550:
2551: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_tax_dist_number :=
2552: p_rec_nrec_dist_tbl(p_rnd_end_index-1).rec_nrec_tax_dist_number + 1;

Line 2732: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;

2728:
2729: l_rounding_rule_code zx_taxes_b.rounding_rule_code%TYPE;
2730: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2731: l_precision zx_taxes_b.tax_precision%TYPE;
2732: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2733: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2734: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2735: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2736: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;

Line 2733: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;

2729: l_rounding_rule_code zx_taxes_b.rounding_rule_code%TYPE;
2730: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2731: l_precision zx_taxes_b.tax_precision%TYPE;
2732: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2733: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2734: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2735: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2736: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;
2737: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;

Line 2734: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;

2730: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2731: l_precision zx_taxes_b.tax_precision%TYPE;
2732: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2733: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2734: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2735: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2736: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;
2737: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;
2738: l_taxable_amt_tax_currency zx_rec_nrec_dist.taxable_amt_tax_curr%TYPE;

Line 2735: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;

2731: l_precision zx_taxes_b.tax_precision%TYPE;
2732: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2733: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2734: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2735: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2736: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;
2737: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;
2738: l_taxable_amt_tax_currency zx_rec_nrec_dist.taxable_amt_tax_curr%TYPE;
2739: l_tax_id zx_taxes_b.tax_id%TYPE;

Line 2736: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;

2732: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2733: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2734: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2735: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2736: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;
2737: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;
2738: l_taxable_amt_tax_currency zx_rec_nrec_dist.taxable_amt_tax_curr%TYPE;
2739: l_tax_id zx_taxes_b.tax_id%TYPE;
2740:

Line 2737: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;

2733: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2734: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2735: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2736: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;
2737: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;
2738: l_taxable_amt_tax_currency zx_rec_nrec_dist.taxable_amt_tax_curr%TYPE;
2739: l_tax_id zx_taxes_b.tax_id%TYPE;
2740:
2741: BEGIN

Line 2738: l_taxable_amt_tax_currency zx_rec_nrec_dist.taxable_amt_tax_curr%TYPE;

2734: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2735: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2736: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;
2737: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;
2738: l_taxable_amt_tax_currency zx_rec_nrec_dist.taxable_amt_tax_curr%TYPE;
2739: l_tax_id zx_taxes_b.tax_id%TYPE;
2740:
2741: BEGIN
2742: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 5175: FROM zx_rec_nrec_dist

5171: rec_nrec_tax_amt_funcl_curr,
5172: trx_line_dist_amt,
5173: def_rec_settlement_option_code,
5174: account_source_tax_rate_id
5175: FROM zx_rec_nrec_dist
5176: WHERE application_id =
5177: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
5178: p_trx_line_dist_index)
5179: AND entity_code =

Line 5248: UPDATE zx_rec_nrec_dist zd

5244: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied',
5245: 'Updating Tax_Apportionment_Line_Number in the tax distributions of Applied_From Doc...');
5246: END IF;
5247:
5248: UPDATE zx_rec_nrec_dist zd
5249: SET tax_apportionment_line_number =
5250: (SELECT tax_apportionment_line_number
5251: FROM zx_lines zl
5252: WHERE zl.tax_line_id = zd.tax_line_id)

Line 5401: FROM zx_rec_nrec_dist

5397: rec_nrec_rate,
5398: rec_nrec_tax_dist_id,
5399: def_rec_settlement_option_code,
5400: account_source_tax_rate_id
5401: FROM zx_rec_nrec_dist
5402: WHERE application_id =
5403: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
5404: p_trx_line_dist_index)
5405: AND entity_code =

Line 5475: UPDATE zx_rec_nrec_dist zd

5471: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted',
5472: 'Updating Tax_Apportionment_Line_Number in the tax distributions of Adjusted Doc...');
5473: END IF;
5474:
5475: UPDATE zx_rec_nrec_dist zd
5476: SET tax_apportionment_line_number =
5477: (SELECT tax_apportionment_line_number
5478: FROM zx_lines zl
5479: WHERE zl.tax_line_id = zd.tax_line_id)

Line 5587: FROM zx_rec_nrec_dist

5583: rec_nrec_rate,
5584: orig_rec_nrec_rate,
5585: rec_rate_result_id,
5586: recovery_rate_id
5587: FROM zx_rec_nrec_dist
5588: WHERE application_id =
5589: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(
5590: p_trx_line_dist_index)
5591: AND entity_code =

Line 5634: FROM zx_rec_nrec_dist

5630: WHERE tax_id = c_tax_id;
5631:
5632: CURSOR get_maximum_tax_dist_num_csr is
5633: SELECT max(rec_nrec_tax_dist_number)
5634: FROM zx_rec_nrec_dist
5635: WHERE tax_line_id = p_detail_tax_line_tbl(p_tax_line_index).tax_line_id
5636: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(p_trx_line_dist_index);
5637:
5638: l_rec_nrec_tax_dist_number NUMBER;

Line 6441: UPDATE zx_rec_nrec_dist_gt gt

6437:
6438: -- Bug 11808769,For PO matched invoices, where quantity, price is NULL from purchase order,stamp AMOUNT as value for variance columns
6439: -- ref_per_trx_curr_unit_nr_amt, ref_doc_per_unit_nrec_tax_amt
6440:
6441: UPDATE zx_rec_nrec_dist_gt gt
6442: SET per_trx_curr_unit_nr_amt =
6443: -- Bugfix 5218651: for amount based matching, when dist qty is 0 or null, return rec_nrec_tax_amt as per unit nr amount
6444: DECODE(gt.trx_line_dist_qty*gt.unit_price,0, NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt),
6445: NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt)/(gt.trx_line_dist_qty * gt.unit_price * (1 - (ZX_TRD_SERVICES_PUB_PKG.g_retained_value/100)))),

Line 6463: FROM zx_rec_nrec_dist dist

6459: DECODE(gt.ref_doc_trx_line_dist_qty*dist.unit_price, 0, NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt),
6460: NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt)/(gt.ref_doc_trx_line_dist_qty*dist.unit_price))),
6461: DECODE(Nvl(gt.ref_doc_trx_line_dist_qty,0), 0, NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt)/dist.trx_line_dist_amt,
6462: NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt)/gt.ref_doc_trx_line_dist_qty)
6463: FROM zx_rec_nrec_dist dist
6464: WHERE dist.application_id = gt.ref_doc_application_id
6465: AND dist.entity_code = gt.ref_doc_entity_code
6466: AND dist.event_class_code = gt.ref_doc_event_class_code
6467: AND dist.trx_id = gt.ref_doc_trx_id

Line 6485: UPDATE zx_rec_nrec_dist_gt gt

6481: AND mrc_tax_dist_flag = 'N';
6482:
6483: -- update ref_doc_unit_price if it is null (PO has no tax)
6484: --
6485: UPDATE zx_rec_nrec_dist_gt gt
6486: SET ref_doc_unit_price =
6487: (SELECT unit_price
6488: FROM zx_lines_det_factors line
6489: WHERE line.application_id = gt.ref_doc_application_id

Line 6515: UPDATE zx_rec_nrec_dist_gt gt

6511: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors',
6512: 'Flow - retainage release invoice');
6513: END IF;
6514:
6515: UPDATE zx_rec_nrec_dist_gt gt
6516: SET per_trx_curr_unit_nr_amt =
6517: -- Bugfix 5218651: for amount based matching, when dist qty is 0 or null, return rec_nrec_tax_amt as per unit nr amount
6518: DECODE(gt.trx_line_dist_qty*gt.unit_price,0, NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt),
6519: NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt)/(gt.trx_line_dist_qty * gt.unit_price * (ZX_TRD_SERVICES_PUB_PKG.g_retained_value/100))),

Line 6537: FROM zx_rec_nrec_dist dist

6533: DECODE(gt.ref_doc_trx_line_dist_qty*dist.unit_price, 0, NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt),
6534: (NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt))*(ZX_TRD_SERVICES_PUB_PKG.g_retained_value/100)/(gt.ref_doc_trx_line_dist_qty*dist.unit_price*(ZX_TRD_SERVICES_PUB_PKG.g_retained_value/100)))),
6535: DECODE(Nvl(gt.ref_doc_trx_line_dist_qty,0), 0, NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt)/dist.trx_line_dist_amt,
6536: NVL(dist.unrounded_rec_nrec_tax_amt, dist.rec_nrec_tax_amt)/gt.ref_doc_trx_line_dist_qty)
6537: FROM zx_rec_nrec_dist dist
6538: WHERE dist.application_id = gt.ref_doc_application_id
6539: AND dist.entity_code = gt.ref_doc_entity_code
6540: AND dist.event_class_code = gt.ref_doc_event_class_code
6541: AND dist.trx_id = gt.ref_doc_trx_id

Line 6559: UPDATE zx_rec_nrec_dist_gt gt

6555: AND mrc_tax_dist_flag = 'N';
6556:
6557: -- update ref_doc_unit_price if it is null (PO has no tax)
6558: --
6559: UPDATE zx_rec_nrec_dist_gt gt
6560: SET ref_doc_unit_price =
6561: (SELECT unit_price
6562: FROM zx_lines_det_factors line
6563: WHERE line.application_id = gt.ref_doc_application_id

Line 6589: UPDATE zx_rec_nrec_dist_gt gt

6585: END IF;
6586:
6587: -- Bug 10069028, As per PM, use unrounded_rec_nrec_tax_amt for variance calculation
6588:
6589: UPDATE zx_rec_nrec_dist_gt gt
6590: SET per_trx_curr_unit_nr_amt =
6591: -- Bugfix 5218651: for amount based matching, when dist qty is 0 or null, return rec_nrec_tax_amt as per unit nr amount
6592: DECODE(gt.trx_line_dist_qty*gt.unit_price,0, NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt),
6593: NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt)/(gt.trx_line_dist_qty*gt.unit_price)),

Line 6611: FROM zx_rec_nrec_dist dist

6607: DECODE(gt.ref_doc_trx_line_dist_qty*dist.unit_price, 0, NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt),
6608: NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt)/(gt.ref_doc_trx_line_dist_qty*dist.unit_price))),
6609: DECODE(Nvl(gt.ref_doc_trx_line_dist_qty,0), 0, NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt)/dist.trx_line_dist_amt,
6610: NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt)/gt.ref_doc_trx_line_dist_qty)
6611: FROM zx_rec_nrec_dist dist
6612: WHERE dist.application_id = gt.ref_doc_application_id
6613: AND dist.entity_code = gt.ref_doc_entity_code
6614: AND dist.event_class_code = gt.ref_doc_event_class_code
6615: AND dist.trx_id = gt.ref_doc_trx_id

Line 6636: UPDATE zx_rec_nrec_dist_gt gt

6632: --
6633: -- Bug 10406032, update ref_per_trx_curr_unit_nr_amt and ref_doc_per_unit_nrec_tax_amt to 0 if PO has no tax.
6634: -- Bug 14648916, update per_trx_curr_unit_nr_amt and per_unit_nrec_tax_amt based on rounded rec_nrec_tax_amt
6635:
6636: UPDATE zx_rec_nrec_dist_gt gt
6637: SET ref_doc_unit_price =
6638: (SELECT unit_price
6639: FROM zx_lines_det_factors line
6640: WHERE line.application_id = gt.ref_doc_application_id

Line 6766: SELECT zx_rec_nrec_dist_s.NEXTVAL INTO

6762: p_rec_nrec_dist_tbl(p_rnd_end_index) := p_rec_nrec_dist_tbl(j);
6763:
6764: -- set MRC related columns
6765: --
6766: SELECT zx_rec_nrec_dist_s.NEXTVAL INTO
6767: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_tax_dist_id FROM DUAL;
6768:
6769: p_rec_nrec_dist_tbl(p_rnd_end_index).unrounded_rec_nrec_tax_amt :=
6770: p_rec_nrec_dist_tbl(j).unrounded_rec_nrec_tax_amt *