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_TRL_MANAGE_TAX_PKG dependencies on ZX_DETAIL_TAX_LINES_GT

Line 468: --SELECT /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

464: MULTIPLE_JURISDICTIONS_FLAG,
465: LEGAL_REPORTING_STATUS,
466: ACCOUNT_SOURCE_TAX_RATE_ID)
467: -- bug#7504604: remove the index hint
468: --SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
469: --
470: SELECT
471: TAX_LINE_ID,
472: INTERNAL_ORGANIZATION_ID,

Line 774: FROM ZX_DETAIL_TAX_LINES_GT;

770: LAST_UPDATE_LOGIN,
771: MULTIPLE_JURISDICTIONS_FLAG,
772: LEGAL_REPORTING_STATUS,
773: ACCOUNT_SOURCE_TAX_RATE_ID
774: FROM ZX_DETAIL_TAX_LINES_GT;
775: -- commented out for bug fix 5417887
776: -- WHERE application_id = p_event_class_rec.application_id
777: -- AND entity_code = p_event_class_rec.entity_code
778: -- AND event_class_code = p_event_class_rec.event_class_code

Line 1031: (SELECT /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

1027: AND entity_code = p_event_class_rec.entity_code
1028: AND event_class_code = p_event_class_rec.event_class_code
1029: AND trx_id = p_event_class_rec.trx_id
1030: AND (tax_line_id IN
1031: (SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1032: tax_line_id
1033: FROM zx_detail_tax_lines_gt
1034: WHERE application_id = p_event_class_rec.application_id
1035: AND entity_code = p_event_class_rec.entity_code

Line 1033: FROM zx_detail_tax_lines_gt

1029: AND trx_id = p_event_class_rec.trx_id
1030: AND (tax_line_id IN
1031: (SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1032: tax_line_id
1033: FROM zx_detail_tax_lines_gt
1034: WHERE application_id = p_event_class_rec.application_id
1035: AND entity_code = p_event_class_rec.entity_code
1036: AND event_class_code = p_event_class_rec.event_class_code
1037: AND trx_id = p_event_class_rec.trx_id

Line 1053: (SELECT /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

1049: AND entity_code = p_event_class_rec.entity_code
1050: AND event_class_code = p_event_class_rec.event_class_code
1051: AND trx_id = p_event_class_rec.trx_id
1052: AND offset_link_to_tax_line_id IN
1053: (SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1054: tax_line_id
1055: FROM zx_detail_tax_lines_gt
1056: WHERE application_id = p_event_class_rec.application_id
1057: AND entity_code = p_event_class_rec.entity_code

Line 1055: FROM zx_detail_tax_lines_gt

1051: AND trx_id = p_event_class_rec.trx_id
1052: AND offset_link_to_tax_line_id IN
1053: (SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1054: tax_line_id
1055: FROM zx_detail_tax_lines_gt
1056: WHERE application_id = p_event_class_rec.application_id
1057: AND entity_code = p_event_class_rec.entity_code
1058: AND event_class_code = p_event_class_rec.event_class_code
1059: AND trx_id = p_event_class_rec.trx_id

Line 1078: (SELECT /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

1074: AND event_class_code = p_event_class_rec.event_class_code
1075: AND trx_id = p_event_class_rec.trx_id
1076: AND mrc_tax_line_flag = 'Y'
1077: AND (trx_line_id, trx_level_type, tax_line_number) IN
1078: (SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1079: trx_line_id, trx_level_type, tax_line_number
1080: FROM zx_detail_tax_lines_gt
1081: WHERE application_id = p_event_class_rec.application_id
1082: AND entity_code = p_event_class_rec.entity_code

Line 1080: FROM zx_detail_tax_lines_gt

1076: AND mrc_tax_line_flag = 'Y'
1077: AND (trx_line_id, trx_level_type, tax_line_number) IN
1078: (SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1079: trx_line_id, trx_level_type, tax_line_number
1080: FROM zx_detail_tax_lines_gt
1081: WHERE application_id = p_event_class_rec.application_id
1082: AND entity_code = p_event_class_rec.entity_code
1083: AND event_class_code = p_event_class_rec.event_class_code
1084: AND trx_id = p_event_class_rec.trx_id

Line 4163: UPDATE zx_detail_tax_lines_gt zlgt

4159: -- Before deleting summary tax lines, we need to preserve old
4160: -- summary_tax_line_id (for UPDATE case) if the same summarization
4161: -- criteria exist.
4162: --
4163: UPDATE zx_detail_tax_lines_gt zlgt
4164: SET summary_tax_line_id =
4165: ( SELECT summary_tax_line_id
4166: FROM zx_lines_summary summ
4167: -- bug fix 5417887

Line 4390: -- Private procedure to create zx_lines_summary from zx_detail_tax_lines_gt

4386: -- PRIVATE PROCEDURE
4387: -- create_summary_lines_crt_evnt
4388: --
4389: -- DESCRIPTION
4390: -- Private procedure to create zx_lines_summary from zx_detail_tax_lines_gt
4391: -- for tax_event_type of 'CREATE' or for tax_event_type of 'UPDATE'/'OVERRIDE'
4392: -- with retain_summ_tax_line_id_flag on event_class_rec of 'N'
4393: ------------------------------------------------------------------------------
4394: -- Bug 6456915 - associated_child_frozen_flag has been removed from grouping columns for summary tax lines

Line 4591: FROM (SELECT /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1)/

4587: pg_tax_xeptn_id_tbl,
4588: --pg_xeptn_rate_tbl,
4589: pg_mrc_tax_line_flag_tbl,
4590: pg_tax_only_line_flag_tbl
4591: FROM (SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1)*/
4592: application_id,
4593: entity_code,
4594: event_class_code,
4595: trx_id,

Line 4675: FROM zx_detail_tax_lines_gt

4671: tax_exception_id,
4672: --exception_rate,
4673: mrc_tax_line_flag,
4674: tax_only_line_flag
4675: FROM zx_detail_tax_lines_gt
4676: -- commented out for bug fix 5417887
4677: -- WHERE application_id = p_event_class_rec.application_id
4678: -- AND entity_code = p_event_class_rec.entity_code
4679: -- AND event_class_code = p_event_class_rec.event_class_code

Line 4812: SELECT /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

4808: --exception_rate,
4809: tax_only_line_flag );
4810:
4811: -- get the tax line id IN the same order of the summary tax line as IN the first query.
4812: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
4813: tax_line_id BULK COLLECT INTO pg_tax_line_id_tbl
4814: FROM zx_detail_tax_lines_gt
4815: -- commented out for bug fix 5417887
4816: -- WHERE application_id = p_event_class_rec.application_id

Line 4814: FROM zx_detail_tax_lines_gt

4810:
4811: -- get the tax line id IN the same order of the summary tax line as IN the first query.
4812: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
4813: tax_line_id BULK COLLECT INTO pg_tax_line_id_tbl
4814: FROM zx_detail_tax_lines_gt
4815: -- commented out for bug fix 5417887
4816: -- WHERE application_id = p_event_class_rec.application_id
4817: -- AND entity_code = p_event_class_rec.entity_code
4818: -- AND event_class_code = p_event_class_rec.event_class_code

Line 4933: UPDATE /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U2) /

4929: END LOOP;
4930:
4931: -- update the summary_tax_line_id column in the detail tax line table
4932: FORALL i IN 1.. pg_tax_line_id_tbl.COUNT
4933: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U2) */
4934: zx_detail_tax_lines_gt
4935: SET summary_tax_line_id = pg_detail_tax_smry_line_id_tbl(i)
4936: WHERE tax_line_id = pg_tax_line_id_tbl(i);
4937:

Line 4934: zx_detail_tax_lines_gt

4930:
4931: -- update the summary_tax_line_id column in the detail tax line table
4932: FORALL i IN 1.. pg_tax_line_id_tbl.COUNT
4933: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U2) */
4934: zx_detail_tax_lines_gt
4935: SET summary_tax_line_id = pg_detail_tax_smry_line_id_tbl(i)
4936: WHERE tax_line_id = pg_tax_line_id_tbl(i);
4937:
4938: -- insert the newly created summary tax lines

Line 5150: -- Private procedure to create zx_lines_summary from zx_detail_tax_lines_gt

5146: -- PRIVATE PROCEDURE
5147: -- create_summary_lines_upd_evnt
5148: --
5149: -- DESCRIPTION
5150: -- Private procedure to create zx_lines_summary from zx_detail_tax_lines_gt
5151: -- for tax_event_type of 'UPDATE' or 'OVERRIDE' with
5152: -- retain_summ_tax_line_id_flag on event_class_rec of 'Y'
5153: ------------------------------------------------------------------------------
5154: -- Bug 6456915 - associated_child_frozen_flag has been removed from grouping columns for summary tax lines