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_LINES_DET_FACTORS

Line 183: -- Check : Trx Line should exist in ZX_Lines_Det_Factors --

179: l_trx_line_exist := 'N';
180:
181: -- Run the preventive check for Payables only Application_Id 200
182: IF p_event_class_rec.application_id = 200 THEN
183: -- Check : Trx Line should exist in ZX_Lines_Det_Factors --
184: IF (g_level_statement >= g_current_runtime_level ) THEN
185: FND_LOG.STRING(g_level_statement,
186: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines',
187: 'Executing Trx Line Exists Validation : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24:MM:SS'));

Line 199: FROM zx_lines_det_factors zldf

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
202: AND zldf.event_class_code = zlgt.event_class_code
203: AND zldf.trx_id = zlgt.trx_id

Line 1060: FROM zx_lines_det_factors

1056: AND TRX_ID = p_event_class_rec.trx_id
1057: AND (DELETE_FLAG = 'Y' OR
1058: (TRX_LINE_ID, trx_level_type) IN
1059: (SELECT TRX_LINE_ID, trx_level_type
1060: FROM zx_lines_det_factors
1061: WHERE application_id = p_event_class_rec.application_id
1062: AND entity_code = p_event_class_rec.entity_code
1063: AND event_class_code = p_event_class_rec.event_class_code
1064: AND trx_id = p_event_class_rec.trx_id

Line 1072: FROM zx_lines_det_factors

1068: ); */
1069: -- bug fix 5417887
1070: DELETE FROM ZX_LINES tax
1071: WHERE EXISTS (SELECT 1
1072: FROM zx_lines_det_factors
1073: WHERE application_id = tax.application_id
1074: AND entity_code = tax.entity_code
1075: AND event_class_code = tax.event_class_code
1076: AND trx_id = tax.trx_id

Line 1082: FROM zx_lines_det_factors

1078: )
1079: AND (tax.DELETE_FLAG = 'Y' OR
1080: (tax.TRX_LINE_ID, tax.trx_level_type) IN
1081: (SELECT TRX_LINE_ID, trx_level_type
1082: FROM zx_lines_det_factors
1083: WHERE application_id = tax.application_id
1084: AND entity_code = tax.entity_code
1085: AND event_class_code = tax.event_class_code
1086: AND trx_id = tax.trx_id

Line 1229: FROM zx_lines_det_factors line

1225: */
1226:
1227: DELETE FROM zx_lines_summary tax
1228: WHERE EXISTS (SELECT 1
1229: FROM zx_lines_det_factors line
1230: WHERE tax.application_id = line.application_id
1231: AND tax.event_class_code = line.event_class_code
1232: AND tax.entity_code = line.entity_code
1233: AND tax.trx_id = line.trx_id

Line 1396: FROM zx_lines_det_factors

1392:
1393: DELETE FROM zx_rec_nrec_dist dist
1394: WHERE EXISTS (
1395: SELECT 1
1396: FROM zx_lines_det_factors
1397: WHERE application_id = dist.application_id
1398: AND entity_code = dist.entity_code
1399: AND event_class_code = dist.event_class_code
1400: AND trx_id = dist.trx_id

Line 3098: -- FROM zx_lines_det_factors

3094: -- AND (Process_For_Recovery_Flag = 'Y' OR
3095: -- Item_Dist_Changed_Flag = 'Y')
3096: -- AND EXISTS
3097: -- (SELECT 1
3098: -- FROM zx_lines_det_factors
3099: -- WHERE APPLICATION_ID = L.application_id
3100: -- AND ENTITY_CODE = L.entity_code
3101: -- AND EVENT_CLASS_CODE = L.event_class_code
3102: -- AND TRX_ID = L.trx_id

Line 3115: (SELECT /+ use_hash(ZX_LINES_DET_FACTORS) / TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE

3111: AND application_id = p_event_class_rec.application_id
3112: AND entity_code = p_event_class_rec.entity_code
3113: AND event_class_code = p_event_class_rec.event_class_code
3114: AND (trx_id, trx_line_id, trx_level_type) IN
3115: (SELECT /*+ use_hash(ZX_LINES_DET_FACTORS) */ TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE
3116: FROM zx_lines_det_factors
3117: WHERE application_id = p_event_class_rec.application_id
3118: AND entity_code = p_event_class_rec.entity_code
3119: AND event_class_code = p_event_class_rec.event_class_code

Line 3116: FROM zx_lines_det_factors

3112: AND entity_code = p_event_class_rec.entity_code
3113: AND event_class_code = p_event_class_rec.event_class_code
3114: AND (trx_id, trx_line_id, trx_level_type) IN
3115: (SELECT /*+ use_hash(ZX_LINES_DET_FACTORS) */ TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE
3116: FROM zx_lines_det_factors
3117: WHERE application_id = p_event_class_rec.application_id
3118: AND entity_code = p_event_class_rec.entity_code
3119: AND event_class_code = p_event_class_rec.event_class_code
3120: AND event_id = p_event_class_rec.event_id

Line 3152: (SELECT /+ use_hash(ZX_LINES_DET_FACTORS) / TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE

3148: AND application_id = p_event_class_rec.application_id
3149: AND entity_code = p_event_class_rec.entity_code
3150: AND event_class_code = p_event_class_rec.event_class_code
3151: AND (trx_id, trx_line_id, trx_level_type) IN
3152: (SELECT /*+ use_hash(ZX_LINES_DET_FACTORS) */ TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE
3153: FROM zx_lines_det_factors
3154: WHERE application_id = p_event_class_rec.application_id
3155: AND entity_code = p_event_class_rec.entity_code
3156: AND event_class_code = p_event_class_rec.event_class_code

Line 3153: FROM zx_lines_det_factors

3149: AND entity_code = p_event_class_rec.entity_code
3150: AND event_class_code = p_event_class_rec.event_class_code
3151: AND (trx_id, trx_line_id, trx_level_type) IN
3152: (SELECT /*+ use_hash(ZX_LINES_DET_FACTORS) */ TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE
3153: FROM zx_lines_det_factors
3154: WHERE application_id = p_event_class_rec.application_id
3155: AND entity_code = p_event_class_rec.entity_code
3156: AND event_class_code = p_event_class_rec.event_class_code
3157: AND event_id = p_event_class_rec.event_id

Line 3201: FROM zx_lines_det_factors

3197: AND (process_for_recovery_flag = 'Y' OR
3198: item_dist_changed_flag = 'Y')
3199: AND EXISTS
3200: (SELECT 1
3201: FROM zx_lines_det_factors
3202: WHERE application_id = zl.application_id
3203: AND entity_code = zl.entity_code
3204: AND event_class_code = zl.event_class_code
3205: AND trx_id = zl.trx_id

Line 3288: from zx_lines_det_factors

3284: x_return_status := FND_API.G_RET_STS_SUCCESS;
3285:
3286: select trx_id, trx_line_id, trx_level_type
3287: bulk collect into pg_trx_id_tab, pg_trx_line_id_tab ,pg_trx_level_type_tab
3288: from zx_lines_det_factors
3289: where application_id = p_event_class_rec.application_id
3290: and entity_code = p_event_class_rec.entity_code
3291: and event_class_code = p_event_class_rec.event_class_code
3292: and event_id = p_event_class_rec.event_id;

Line 3326: ( select 1 from zx_lines_det_factors

3322: WHERE application_id = p_event_class_rec.application_id
3323: AND entity_code = p_event_class_rec.entity_code
3324: AND event_class_code = p_event_class_rec.event_class_code
3325: /*AND exists
3326: ( select 1 from zx_lines_det_factors
3327: where application_id = l.application_id
3328: and entity_code = l.entity_code
3329: and event_class_code = l.event_class_code
3330: and trx_id = l.trx_id

Line 3367: ( select 1 from zx_lines_det_factors

3363: WHERE application_id = p_event_class_rec.application_id
3364: AND entity_code = p_event_class_rec.entity_code
3365: AND event_class_code = p_event_class_rec.event_class_code
3366: AND exists
3367: ( select 1 from zx_lines_det_factors
3368: where application_id = S.application_id
3369: and entity_code = S.entity_code
3370: and event_class_code = S.event_class_code
3371: and trx_id = S.trx_id

Line 5715: FROM zx_lines_det_factors line

5711: -- AND entity_code = p_event_class_rec.entity_code
5712: -- AND event_class_code = p_event_class_rec.event_class_code
5713: -- AND trx_id = p_event_class_rec.trx_id
5714: EXISTS (SELECT 1
5715: FROM zx_lines_det_factors line
5716: WHERE tax.application_id = line.application_id
5717: AND tax.event_class_code = line.event_class_code
5718: AND tax.entity_code = line.entity_code
5719: AND tax.trx_id = line.trx_id

Line 5861: FROM zx_lines_det_factors line

5857: -- AND event_class_code = p_event_class_rec.event_class_code
5858: -- AND trx_id = p_event_class_rec.trx_id
5859: WHERE EXISTS (
5860: SELECT 1
5861: FROM zx_lines_det_factors line
5862: WHERE tax.application_id = line.application_id
5863: AND tax.event_class_code = line.event_class_code
5864: AND tax.entity_code = line.entity_code
5865: AND tax.trx_id = line.trx_id

Line 6179: FROM zx_lines_det_factors line

6175: -- AND event_class_code = p_event_class_rec.event_class_code
6176: -- AND trx_id = p_event_class_rec.trx_id
6177: WHERE EXISTS (
6178: SELECT 1
6179: FROM zx_lines_det_factors line
6180: WHERE tax.application_id = line.application_id
6181: AND tax.event_class_code = line.event_class_code
6182: AND tax.entity_code = line.entity_code
6183: AND tax.trx_id = line.trx_id

Line 6325: FROM zx_lines_det_factors line

6321: -- AND event_class_code = p_event_class_rec.event_class_code
6322: -- AND trx_id = p_event_class_rec.trx_id
6323: WHERE EXISTS (
6324: SELECT 1
6325: FROM zx_lines_det_factors line
6326: WHERE tax.application_id = line.application_id
6327: AND tax.event_class_code = line.event_class_code
6328: AND tax.entity_code = line.entity_code
6329: AND tax.trx_id = line.trx_id