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_TDS_TAX_LINES_DETM_PKG dependencies on ZX_LINES

Line 250: -- tax lines in zx_lines for update event,

246: END IF;
247:
248: --
249: -- process cancel, provider generated and frozen
250: -- tax lines in zx_lines for update event,
251: -- insert these tax lines into detail tax lines
252: -- global temp table and mark them as cancel
253: --
254:

Line 744: (SELECT /+ INDEX(zl ZX_LINES_U1) /

740: AND rates.tax_rate_id = gt1.tax_rate_id
741: AND gt2.tax = rates.offset_tax
742: )
743: AND NOT EXISTS
744: (SELECT /*+ INDEX(zl ZX_LINES_U1) */
745: 1
746: FROM zx_rates_b rates,
747: zx_lines zl
748: WHERE zl.application_id = gt1.application_id

Line 747: zx_lines zl

743: AND NOT EXISTS
744: (SELECT /*+ INDEX(zl ZX_LINES_U1) */
745: 1
746: FROM zx_rates_b rates,
747: zx_lines zl
748: WHERE zl.application_id = gt1.application_id
749: AND zl.entity_code = gt1.entity_code
750: AND zl.event_class_code = gt1.event_class_code
751: AND zl.trx_id = gt1.trx_id

Line 765: FROM zx_lines

761: ORDER BY trx_id, trx_line_id, Tax_line_id;
762:
763: CURSOR get_tax_line_number_csr IS
764: SELECT NVL(MAX(tax_line_number), 0) + 1
765: FROM zx_lines
766: WHERE application_id = l_tax_line_rec.application_id
767: AND event_class_code = l_tax_line_rec.event_class_code
768: AND entity_code = l_tax_line_rec.entity_code
769: AND trx_id = l_tax_line_rec.trx_id

Line 1483: FROM zx_lines L

1479: (LGT.other_doc_line_amt, LGT.other_doc_line_tax_amt, LGT.other_doc_line_taxable_amt ) =
1480: (SELECT L.line_amt,
1481: L.tax_amt,
1482: L.taxable_amt
1483: FROM zx_lines L
1484: WHERE L.application_id = LGT.ref_doc_application_id
1485: AND L.event_class_code = LGT.ref_doc_event_class_code
1486: AND L.entity_code = LGT.ref_doc_entity_code
1487: AND L.trx_id = LGT.ref_doc_trx_id

Line 1498: AND EXISTS (SELECT /+ INDEX(L ZX_LINES_U1 ) / 'X'

1494: AND L.mrc_tax_line_flag = 'N' ) */
1495: WHERE ref_doc_application_id IS NOT NULL
1496: AND tax_event_type_code <> 'OVERRIDE_TAX'
1497: AND NVL(historical_flag, 'N') <> 'Y'
1498: AND EXISTS (SELECT /*+ INDEX(L ZX_LINES_U1 ) */ 'X'
1499: FROM zx_lines L
1500: WHERE L.application_id = LGT.ref_doc_application_id
1501: AND L.event_class_code = LGT.ref_doc_event_class_code
1502: AND L.entity_code = LGT.ref_doc_entity_code

Line 1499: FROM zx_lines L

1495: WHERE ref_doc_application_id IS NOT NULL
1496: AND tax_event_type_code <> 'OVERRIDE_TAX'
1497: AND NVL(historical_flag, 'N') <> 'Y'
1498: AND EXISTS (SELECT /*+ INDEX(L ZX_LINES_U1 ) */ 'X'
1499: FROM zx_lines L
1500: WHERE L.application_id = LGT.ref_doc_application_id
1501: AND L.event_class_code = LGT.ref_doc_event_class_code
1502: AND L.entity_code = LGT.ref_doc_entity_code
1503: AND L.trx_id = LGT.ref_doc_trx_id

Line 1775: zx_lines_s.NEXTVAL, -- tax_line_id,

1771: --End of Bug 7383041
1772: object_version_number
1773: )
1774: (SELECT
1775: zx_lines_s.NEXTVAL, -- tax_line_id,
1776: G.internal_organization_id,
1777: G.internal_org_location_id,
1778: G.application_id,
1779: G.entity_code,

Line 2041: FROM zx_lines L,

2037: FROM zx_taxes_b
2038: WHERE tax_id = L.tax_id) legal_reporting_status,
2039: --End of Bug 7383041
2040: 1
2041: FROM zx_lines L,
2042: zx_lines_det_factors G
2043: WHERE G.event_id = p_event_class_rec.event_id
2044: AND G.ref_doc_application_id IS NOT NULL
2045: AND (G.tax_event_type_code NOT IN ('OVERRIDE_TAX', 'UPDATE')

Line 2042: zx_lines_det_factors G

2038: WHERE tax_id = L.tax_id) legal_reporting_status,
2039: --End of Bug 7383041
2040: 1
2041: FROM zx_lines L,
2042: zx_lines_det_factors G
2043: WHERE G.event_id = p_event_class_rec.event_id
2044: AND G.ref_doc_application_id IS NOT NULL
2045: AND (G.tax_event_type_code NOT IN ('OVERRIDE_TAX', 'UPDATE')
2046: OR (G.tax_event_type_code ='UPDATE' AND

Line 2334: zx_lines_s.NEXTVAL, -- tax_line_id,

2330: --End of Bug 7383041
2331: object_version_number
2332: )
2333: (SELECT
2334: zx_lines_s.NEXTVAL, -- tax_line_id,
2335: G.internal_organization_id,
2336: G.internal_org_location_id,
2337: G.application_id,
2338: G.entity_code,

Line 2610: FROM zx_lines L,

2606: FROM zx_taxes_b
2607: WHERE tax_id = L.tax_id) legal_reporting_status,
2608: --End of Bug 7383041
2609: 1
2610: FROM zx_lines L,
2611: zx_lines_det_factors G
2612: WHERE G.event_id = p_event_class_rec.event_id
2613: AND G.ref_doc_application_id IS NOT NULL
2614: AND (G.tax_event_type_code NOT IN ('OVERRIDE_TAX', 'UPDATE')

Line 2611: zx_lines_det_factors G

2607: WHERE tax_id = L.tax_id) legal_reporting_status,
2608: --End of Bug 7383041
2609: 1
2610: FROM zx_lines L,
2611: zx_lines_det_factors G
2612: WHERE G.event_id = p_event_class_rec.event_id
2613: AND G.ref_doc_application_id IS NOT NULL
2614: AND (G.tax_event_type_code NOT IN ('OVERRIDE_TAX', 'UPDATE')
2615: OR (G.tax_event_type_code ='UPDATE' AND

Line 2926: zx_lines_det_factors G

2922: T.tax_status_code,
2923: T.tax_rate_code,
2924: T.tax_determine_date
2925: FROM zx_detail_tax_lines_gt T,
2926: zx_lines_det_factors G
2927: WHERE
2928: -- commented out for bug fix 5417887
2929: -- G.application_id = p_event_class_rec.application_id
2930: --AND G.event_class_code = p_event_class_rec.event_class_code

Line 2976: SELECT /+ index(L ZX_LINES_U1) / -- Added the hint as part of 6596182

2972: --
2973:
2974: MERGE INTO zx_detail_tax_lines_gt tax_line
2975: USING(
2976: SELECT /*+ index(L ZX_LINES_U1) */ -- Added the hint as part of 6596182
2977: G.internal_organization_id,
2978: G.internal_org_location_id,
2979: G.application_id,
2980: G.entity_code,

Line 3197: FROM zx_lines L,

3193: L.adjusted_doc_tax_line_id,
3194: L.cal_tax_amt,
3195: L.cal_tax_amt_tax_curr,
3196: L.cal_tax_amt_funcl_curr
3197: FROM zx_lines L,
3198: zx_lines_det_factors G
3199: WHERE
3200: -- commented out for bug fix 5417887
3201: -- G.application_id = p_event_class_rec.application_id

Line 3198: zx_lines_det_factors G

3194: L.cal_tax_amt,
3195: L.cal_tax_amt_tax_curr,
3196: L.cal_tax_amt_funcl_curr
3197: FROM zx_lines L,
3198: zx_lines_det_factors G
3199: WHERE
3200: -- commented out for bug fix 5417887
3201: -- G.application_id = p_event_class_rec.application_id
3202: --AND G.event_class_code = p_event_class_rec.event_class_code

Line 3232: -- tax_line_id = zx_lines_s.NEXTVAL,

3228: AND NVL(tax_line.tax_apportionment_line_number, 1) =
3229: NVL(temp.tax_apportionment_line_number, 1) )
3230: WHEN MATCHED THEN
3231: UPDATE SET
3232: -- tax_line_id = zx_lines_s.NEXTVAL,
3233: internal_organization_id = temp.internal_organization_id,
3234: internal_org_location_id = temp.internal_org_location_id,
3235: -- application_id = temp.application_id,
3236: -- entity_code = temp.entity_code,

Line 3723: zx_lines_s.NEXTVAL, -- tax_line_id,

3719: object_version_number,
3720: legal_reporting_status
3721: )
3722: VALUES(
3723: zx_lines_s.NEXTVAL, -- tax_line_id,
3724: temp.internal_organization_id,
3725: temp.internal_org_location_id,
3726: temp.application_id,
3727: temp.entity_code,

Line 4187: -- bug 14102214 using forceful hint ZX_LINES_N1 on cm_tax table

4183: -- p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4184: x_return_status OUT NOCOPY VARCHAR2,
4185: x_error_buffer OUT NOCOPY VARCHAR2)
4186: IS
4187: -- bug 14102214 using forceful hint ZX_LINES_N1 on cm_tax table
4188: CURSOR get_tax_amts IS
4189: SELECT det.unrounded_tax_amt
4190: ,det.tax_amt_tax_curr
4191: ,det.tax_amt_funcl_curr

Line 4206: ,(SELECT /+ INDEX(tax ZX_DETAIL_TAX_LINES_GT_U1) INDEX(cm_tax ZX_LINES_N1) /

4202: ,v.remain_line_amt
4203: ,v.orig_tax_amt
4204: ,v.orig_line_amt
4205: FROM zx_detail_tax_lines_gt det
4206: ,(SELECT /*+ INDEX(tax ZX_DETAIL_TAX_LINES_GT_U1) INDEX(cm_tax ZX_LINES_N1) */
4207: tax.tax_amt tax_amt
4208: ,tax.line_amt line_amt
4209: ,org_tax.tax_amt + NVL(SUM(cm_tax.tax_amt), 0) remain_amt
4210: ,org_tax.unrounded_tax_amt + NVL(SUM(cm_tax.unrounded_tax_amt), 0) remain_unrounded_amt

Line 4218: FROM zx_lines org_tax,

4214: ,tax.tax_line_id
4215: ,org_tax.line_amt + NVL(SUM(cm_tax.line_amt), 0) remain_line_amt
4216: ,org_tax.tax_amt orig_tax_amt
4217: ,org_tax.line_amt orig_line_amt
4218: FROM zx_lines org_tax,
4219: zx_lines cm_tax,
4220: zx_detail_tax_lines_gt tax
4221: WHERE
4222: -- commented out for bug fix 5417887

Line 4219: zx_lines cm_tax,

4215: ,org_tax.line_amt + NVL(SUM(cm_tax.line_amt), 0) remain_line_amt
4216: ,org_tax.tax_amt orig_tax_amt
4217: ,org_tax.line_amt orig_line_amt
4218: FROM zx_lines org_tax,
4219: zx_lines cm_tax,
4220: zx_detail_tax_lines_gt tax
4221: WHERE
4222: -- commented out for bug fix 5417887
4223: -- tax.application_id = p_event_class_rec.application_id

Line 4427: -- so use zx_transaction_lines_gt in stead of zx_lines_det_factors to retrieve

4423: l_detail_tax_lines_tbl ZX_TDS_CALC_SERVICES_PUB_PKG.detail_tax_lines_tbl_type;
4424: l_tax_index NUMBER;
4425:
4426: -- this procedure is added for PO eBTax uptake. PO calls eBtax only in GT mode,
4427: -- so use zx_transaction_lines_gt in stead of zx_lines_det_factors to retrieve
4428: -- the tax lines for unchanged the trx lines.
4429:
4430: CURSOR c_tx_ln_for_unchanged_trx_ln IS
4431: SELECT L.*

Line 4432: FROM zx_lines L,

4428: -- the tax lines for unchanged the trx lines.
4429:
4430: CURSOR c_tx_ln_for_unchanged_trx_ln IS
4431: SELECT L.*
4432: FROM zx_lines L,
4433: zx_transaction_lines_gt G
4434: WHERE /* -- commented out for bug fix 5417887
4435: G.application_id = p_event_class_rec.application_id
4436: AND G.event_class_code = p_event_class_rec.event_class_code