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 243: -- tax lines in zx_lines for update event,

239: END IF;
240:
241: --
242: -- process cancel, provider generated and frozen
243: -- tax lines in zx_lines for update event,
244: -- insert these tax lines into detail tax lines
245: -- global temp table and mark them as cancel
246: --
247:

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

724: AND rates.tax_rate_id = gt1.tax_rate_id
725: AND gt2.tax = rates.offset_tax
726: )
727: AND NOT EXISTS
728: (SELECT /*+ INDEX(zl ZX_LINES_U1) */
729: 1
730: FROM zx_rates_b rates,
731: zx_lines zl
732: WHERE zl.application_id = gt1.application_id

Line 731: zx_lines zl

727: AND NOT EXISTS
728: (SELECT /*+ INDEX(zl ZX_LINES_U1) */
729: 1
730: FROM zx_rates_b rates,
731: zx_lines zl
732: WHERE zl.application_id = gt1.application_id
733: AND zl.entity_code = gt1.entity_code
734: AND zl.event_class_code = gt1.event_class_code
735: AND zl.trx_id = gt1.trx_id

Line 749: FROM zx_lines

745: ORDER BY trx_id, trx_line_id, Tax_line_id;
746:
747: CURSOR get_tax_line_number_csr IS
748: SELECT NVL(MAX(tax_line_number), 0) + 1
749: FROM zx_lines
750: WHERE application_id = l_tax_line_rec.application_id
751: AND event_class_code = l_tax_line_rec.event_class_code
752: AND entity_code = l_tax_line_rec.entity_code
753: AND trx_id = l_tax_line_rec.trx_id

Line 1455: FROM zx_lines L

1451: (LGT.other_doc_line_amt, LGT.other_doc_line_tax_amt, LGT.other_doc_line_taxable_amt ) =
1452: (SELECT L.line_amt,
1453: L.tax_amt,
1454: L.taxable_amt
1455: FROM zx_lines L
1456: WHERE L.application_id = LGT.ref_doc_application_id
1457: AND L.event_class_code = LGT.ref_doc_event_class_code
1458: AND L.entity_code = LGT.ref_doc_entity_code
1459: AND L.trx_id = LGT.ref_doc_trx_id

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

1466: AND L.mrc_tax_line_flag = 'N' ) */
1467: WHERE ref_doc_application_id IS NOT NULL
1468: AND tax_event_type_code <> 'OVERRIDE_TAX'
1469: AND NVL(historical_flag, 'N') <> 'Y'
1470: AND EXISTS (SELECT /*+ INDEX(L ZX_LINES_U1 ) */ 'X'
1471: FROM zx_lines L
1472: WHERE L.application_id = LGT.ref_doc_application_id
1473: AND L.event_class_code = LGT.ref_doc_event_class_code
1474: AND L.entity_code = LGT.ref_doc_entity_code

Line 1471: FROM zx_lines L

1467: WHERE ref_doc_application_id IS NOT NULL
1468: AND tax_event_type_code <> 'OVERRIDE_TAX'
1469: AND NVL(historical_flag, 'N') <> 'Y'
1470: AND EXISTS (SELECT /*+ INDEX(L ZX_LINES_U1 ) */ 'X'
1471: FROM zx_lines L
1472: WHERE L.application_id = LGT.ref_doc_application_id
1473: AND L.event_class_code = LGT.ref_doc_event_class_code
1474: AND L.entity_code = LGT.ref_doc_entity_code
1475: AND L.trx_id = LGT.ref_doc_trx_id

Line 1739: zx_lines_s.NEXTVAL, -- tax_line_id,

1735: --End of Bug 7383041
1736: object_version_number
1737: )
1738: (SELECT
1739: zx_lines_s.NEXTVAL, -- tax_line_id,
1740: G.internal_organization_id,
1741: G.internal_org_location_id,
1742: G.application_id,
1743: G.entity_code,

Line 2003: FROM zx_lines L,

1999: from zx_taxes_b
2000: where tax_id = L.tax_id) legal_reporting_status,
2001: --End of Bug 7383041
2002: 1
2003: FROM zx_lines L,
2004: zx_lines_det_factors G
2005: WHERE G.event_id = p_event_class_rec.event_id
2006: AND G.ref_doc_application_id IS NOT NULL
2007: AND (G.tax_event_type_code NOT IN ('OVERRIDE_TAX', 'UPDATE')

Line 2004: zx_lines_det_factors G

2000: where tax_id = L.tax_id) legal_reporting_status,
2001: --End of Bug 7383041
2002: 1
2003: FROM zx_lines L,
2004: zx_lines_det_factors G
2005: WHERE G.event_id = p_event_class_rec.event_id
2006: AND G.ref_doc_application_id IS NOT NULL
2007: AND (G.tax_event_type_code NOT IN ('OVERRIDE_TAX', 'UPDATE')
2008: OR (G.tax_event_type_code ='UPDATE' AND

Line 2313: zx_lines_det_factors G

2309: T.tax_status_code,
2310: T.tax_rate_code,
2311: T.tax_determine_date
2312: FROM zx_detail_tax_lines_gt T,
2313: zx_lines_det_factors G
2314: WHERE
2315: -- commented out for bug fix 5417887
2316: -- G.application_id = p_event_class_rec.application_id
2317: --AND G.event_class_code = p_event_class_rec.event_class_code

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

2359: --
2360:
2361: MERGE INTO zx_detail_tax_lines_gt tax_line
2362: USING(
2363: SELECT /*+ index(L ZX_LINES_U1) */ -- Added the hint as part of 6596182
2364: G.internal_organization_id,
2365: G.internal_org_location_id,
2366: G.application_id,
2367: G.entity_code,

Line 2584: FROM zx_lines L,

2580: L.adjusted_doc_tax_line_id,
2581: L.cal_tax_amt,
2582: L.cal_tax_amt_tax_curr,
2583: L.cal_tax_amt_funcl_curr
2584: FROM zx_lines L,
2585: zx_lines_det_factors G
2586: WHERE
2587: -- commented out for bug fix 5417887
2588: -- G.application_id = p_event_class_rec.application_id

Line 2585: zx_lines_det_factors G

2581: L.cal_tax_amt,
2582: L.cal_tax_amt_tax_curr,
2583: L.cal_tax_amt_funcl_curr
2584: FROM zx_lines L,
2585: zx_lines_det_factors G
2586: WHERE
2587: -- commented out for bug fix 5417887
2588: -- G.application_id = p_event_class_rec.application_id
2589: --AND G.event_class_code = p_event_class_rec.event_class_code

Line 2619: -- tax_line_id = zx_lines_s.NEXTVAL,

2615: AND NVL(tax_line.tax_apportionment_line_number, 1) =
2616: NVL(temp.tax_apportionment_line_number, 1) )
2617: WHEN MATCHED THEN
2618: UPDATE SET
2619: -- tax_line_id = zx_lines_s.NEXTVAL,
2620: internal_organization_id = temp.internal_organization_id,
2621: internal_org_location_id = temp.internal_org_location_id,
2622: -- application_id = temp.application_id,
2623: -- entity_code = temp.entity_code,

Line 3109: zx_lines_s.NEXTVAL, -- tax_line_id,

3105: adjusted_doc_tax_line_id,
3106: object_version_number
3107: )
3108: VALUES(
3109: zx_lines_s.NEXTVAL, -- tax_line_id,
3110: temp.internal_organization_id,
3111: temp.internal_org_location_id,
3112: temp.application_id,
3113: temp.entity_code,

Line 3585: FROM zx_lines org_tax,

3581: ,tax.tax_line_id
3582: ,org_tax.line_amt + NVL(SUM(cm_tax.line_amt), 0) remain_line_amt
3583: ,org_tax.tax_amt orig_tax_amt
3584: ,org_tax.line_amt orig_line_amt
3585: FROM zx_lines org_tax,
3586: zx_lines cm_tax,
3587: zx_detail_tax_lines_gt tax
3588: WHERE
3589: -- commented out for bug fix 5417887

Line 3586: zx_lines cm_tax,

3582: ,org_tax.line_amt + NVL(SUM(cm_tax.line_amt), 0) remain_line_amt
3583: ,org_tax.tax_amt orig_tax_amt
3584: ,org_tax.line_amt orig_line_amt
3585: FROM zx_lines org_tax,
3586: zx_lines cm_tax,
3587: zx_detail_tax_lines_gt tax
3588: WHERE
3589: -- commented out for bug fix 5417887
3590: -- tax.application_id = p_event_class_rec.application_id

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

3768: l_detail_tax_lines_tbl ZX_TDS_CALC_SERVICES_PUB_PKG.detail_tax_lines_tbl_type;
3769: l_tax_index NUMBER;
3770:
3771: -- this procedure is added for PO eBTax uptake. PO calls eBtax only in GT mode,
3772: -- so use zx_transaction_lines_gt in stead of zx_lines_det_factors to retrieve
3773: -- the tax lines for unchanged the trx lines.
3774:
3775: CURSOR c_tx_ln_for_unchanged_trx_ln IS
3776: SELECT L.*

Line 3777: FROM zx_lines L,

3773: -- the tax lines for unchanged the trx lines.
3774:
3775: CURSOR c_tx_ln_for_unchanged_trx_ln IS
3776: SELECT L.*
3777: FROM zx_lines L,
3778: zx_transaction_lines_gt G
3779: WHERE /* -- commented out for bug fix 5417887
3780: G.application_id = p_event_class_rec.application_id
3781: AND G.event_class_code = p_event_class_rec.event_class_code