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 197: FROM zx_detail_tax_lines_gt zlgt

193: 'N' trx_line_exist,
194: trx_id
195: INTO l_trx_line_exist,
196: l_trx_id
197: FROM zx_detail_tax_lines_gt zlgt
198: WHERE NOT EXISTS (SELECT /*first_rows(1)*/ 1
199: FROM zx_lines_det_factors zldf
200: WHERE zldf.application_id = zlgt.application_id
201: AND zldf.entity_code = zlgt.entity_code

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

543: MULTIPLE_JURISDICTIONS_FLAG,
544: LEGAL_REPORTING_STATUS,
545: ACCOUNT_SOURCE_TAX_RATE_ID)
546: -- bug#7504604: remove the index hint
547: --SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
548: --
549: SELECT
550: TAX_LINE_ID,
551: INTERNAL_ORGANIZATION_ID,

Line 853: FROM ZX_DETAIL_TAX_LINES_GT;

849: LAST_UPDATE_LOGIN,
850: MULTIPLE_JURISDICTIONS_FLAG,
851: LEGAL_REPORTING_STATUS,
852: ACCOUNT_SOURCE_TAX_RATE_ID
853: FROM ZX_DETAIL_TAX_LINES_GT;
854:
855: l_row_count := SQL%ROWCOUNT;
856:
857: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

1098: AND entity_code = p_event_class_rec.entity_code
1099: AND event_class_code = p_event_class_rec.event_class_code
1100: AND trx_id = p_event_class_rec.trx_id
1101: AND (tax_line_id IN
1102: (SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1103: tax_line_id
1104: FROM zx_detail_tax_lines_gt
1105: WHERE application_id = p_event_class_rec.application_id
1106: AND entity_code = p_event_class_rec.entity_code

Line 1104: FROM zx_detail_tax_lines_gt

1100: AND trx_id = p_event_class_rec.trx_id
1101: AND (tax_line_id IN
1102: (SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1103: tax_line_id
1104: FROM zx_detail_tax_lines_gt
1105: WHERE application_id = p_event_class_rec.application_id
1106: AND entity_code = p_event_class_rec.entity_code
1107: AND event_class_code = p_event_class_rec.event_class_code
1108: AND trx_id = p_event_class_rec.trx_id

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

1120: AND entity_code = p_event_class_rec.entity_code
1121: AND event_class_code = p_event_class_rec.event_class_code
1122: AND trx_id = p_event_class_rec.trx_id
1123: AND offset_link_to_tax_line_id IN
1124: (SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1125: tax_line_id
1126: FROM zx_detail_tax_lines_gt
1127: WHERE application_id = p_event_class_rec.application_id
1128: AND entity_code = p_event_class_rec.entity_code

Line 1126: FROM zx_detail_tax_lines_gt

1122: AND trx_id = p_event_class_rec.trx_id
1123: AND offset_link_to_tax_line_id IN
1124: (SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1125: tax_line_id
1126: FROM zx_detail_tax_lines_gt
1127: WHERE application_id = p_event_class_rec.application_id
1128: AND entity_code = p_event_class_rec.entity_code
1129: AND event_class_code = p_event_class_rec.event_class_code
1130: AND trx_id = p_event_class_rec.trx_id

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

1145: AND event_class_code = p_event_class_rec.event_class_code
1146: AND trx_id = p_event_class_rec.trx_id
1147: AND mrc_tax_line_flag = 'Y'
1148: AND (trx_line_id, trx_level_type, tax_line_number) IN
1149: (SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1150: trx_line_id, trx_level_type, tax_line_number
1151: FROM zx_detail_tax_lines_gt
1152: WHERE application_id = p_event_class_rec.application_id
1153: AND entity_code = p_event_class_rec.entity_code

Line 1151: FROM zx_detail_tax_lines_gt

1147: AND mrc_tax_line_flag = 'Y'
1148: AND (trx_line_id, trx_level_type, tax_line_number) IN
1149: (SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1150: trx_line_id, trx_level_type, tax_line_number
1151: FROM zx_detail_tax_lines_gt
1152: WHERE application_id = p_event_class_rec.application_id
1153: AND entity_code = p_event_class_rec.entity_code
1154: AND event_class_code = p_event_class_rec.event_class_code
1155: AND trx_id = p_event_class_rec.trx_id

Line 4430: UPDATE zx_detail_tax_lines_gt zlgt

4426: -- Before deleting summary tax lines, we need to preserve old
4427: -- summary_tax_line_id (for UPDATE case) if the same summarization
4428: -- criteria exist.
4429: --
4430: UPDATE zx_detail_tax_lines_gt zlgt
4431: SET summary_tax_line_id =
4432: ( SELECT summary_tax_line_id
4433: FROM zx_lines_summary summ
4434: -- bug fix 5417887

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

4653: -- PRIVATE PROCEDURE
4654: -- create_summary_lines_crt_evnt
4655: --
4656: -- DESCRIPTION
4657: -- Private procedure to create zx_lines_summary from zx_detail_tax_lines_gt
4658: -- for tax_event_type of 'CREATE' or for tax_event_type of 'UPDATE'/'OVERRIDE'
4659: -- with retain_summ_tax_line_id_flag on event_class_rec of 'N'
4660: ------------------------------------------------------------------------------
4661: -- Bug 6456915 - associated_child_frozen_flag has been removed from grouping columns for summary tax lines

Line 4861: -- FROM (SELECT /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1)/

4857: --pg_xeptn_rate_tbl,
4858: pg_mrc_tax_line_flag_tbl,
4859: pg_tax_only_line_flag_tbl
4860: -- bug#7581211: remove the index hint
4861: -- FROM (SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1)*/
4862: FROM (SELECT
4863: application_id,
4864: entity_code,
4865: event_class_code,

Line 4947: FROM zx_detail_tax_lines_gt

4943: tax_exception_id,
4944: --exception_rate,
4945: mrc_tax_line_flag,
4946: tax_only_line_flag
4947: FROM zx_detail_tax_lines_gt
4948: -- commented out for bug fix 5417887
4949: -- WHERE application_id = p_event_class_rec.application_id
4950: -- AND entity_code = p_event_class_rec.entity_code
4951: -- AND event_class_code = p_event_class_rec.event_class_code

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

5080: --exception_rate,
5081: tax_only_line_flag );
5082:
5083: -- get the tax line id IN the same order of the summary tax line as IN the first query.
5084: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
5085: tax_line_id BULK COLLECT INTO pg_tax_line_id_tbl
5086: FROM zx_detail_tax_lines_gt
5087: -- commented out for bug fix 5417887
5088: -- WHERE application_id = p_event_class_rec.application_id

Line 5086: FROM zx_detail_tax_lines_gt

5082:
5083: -- get the tax line id IN the same order of the summary tax line as IN the first query.
5084: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
5085: tax_line_id BULK COLLECT INTO pg_tax_line_id_tbl
5086: FROM zx_detail_tax_lines_gt
5087: -- commented out for bug fix 5417887
5088: -- WHERE application_id = p_event_class_rec.application_id
5089: -- AND entity_code = p_event_class_rec.entity_code
5090: -- AND event_class_code = p_event_class_rec.event_class_code

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

5207: END LOOP;
5208:
5209: -- update the summary_tax_line_id column in the detail tax line table
5210: FORALL i IN 1.. pg_tax_line_id_tbl.COUNT
5211: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U2) */
5212: zx_detail_tax_lines_gt
5213: SET summary_tax_line_id = pg_detail_tax_smry_line_id_tbl(i)
5214: WHERE tax_line_id = pg_tax_line_id_tbl(i);
5215:

Line 5212: zx_detail_tax_lines_gt

5208:
5209: -- update the summary_tax_line_id column in the detail tax line table
5210: FORALL i IN 1.. pg_tax_line_id_tbl.COUNT
5211: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U2) */
5212: zx_detail_tax_lines_gt
5213: SET summary_tax_line_id = pg_detail_tax_smry_line_id_tbl(i)
5214: WHERE tax_line_id = pg_tax_line_id_tbl(i);
5215:
5216: -- insert the newly created summary tax lines

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

5424: -- PRIVATE PROCEDURE
5425: -- create_summary_lines_upd_evnt
5426: --
5427: -- DESCRIPTION
5428: -- Private procedure to create zx_lines_summary from zx_detail_tax_lines_gt
5429: -- for tax_event_type of 'UPDATE' or 'OVERRIDE' with
5430: -- retain_summ_tax_line_id_flag on event_class_rec of 'Y'
5431: ------------------------------------------------------------------------------
5432: -- Bug 6456915 - associated_child_frozen_flag has been removed from grouping columns for summary tax lines