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 989: FROM zx_lines_det_factors

985: AND TRX_ID = p_event_class_rec.trx_id
986: AND (DELETE_FLAG = 'Y' OR
987: (TRX_LINE_ID, trx_level_type) IN
988: (SELECT TRX_LINE_ID, trx_level_type
989: FROM zx_lines_det_factors
990: WHERE application_id = p_event_class_rec.application_id
991: AND entity_code = p_event_class_rec.entity_code
992: AND event_class_code = p_event_class_rec.event_class_code
993: AND trx_id = p_event_class_rec.trx_id

Line 1001: FROM zx_lines_det_factors

997: ); */
998: -- bug fix 5417887
999: DELETE FROM ZX_LINES tax
1000: WHERE EXISTS (SELECT 1
1001: FROM zx_lines_det_factors
1002: WHERE application_id = tax.application_id
1003: AND entity_code = tax.entity_code
1004: AND event_class_code = tax.event_class_code
1005: AND trx_id = tax.trx_id

Line 1011: FROM zx_lines_det_factors

1007: )
1008: AND (tax.DELETE_FLAG = 'Y' OR
1009: (tax.TRX_LINE_ID, tax.trx_level_type) IN
1010: (SELECT TRX_LINE_ID, trx_level_type
1011: FROM zx_lines_det_factors
1012: WHERE application_id = tax.application_id
1013: AND entity_code = tax.entity_code
1014: AND event_class_code = tax.event_class_code
1015: AND trx_id = tax.trx_id

Line 1157: FROM zx_lines_det_factors line

1153: */
1154:
1155: DELETE FROM zx_lines_summary tax
1156: WHERE EXISTS (SELECT 1
1157: FROM zx_lines_det_factors line
1158: WHERE tax.application_id = line.application_id
1159: AND tax.event_class_code = line.event_class_code
1160: AND tax.entity_code = line.entity_code
1161: AND tax.trx_id = line.trx_id

Line 1248: FROM zx_lines_det_factors

1244:
1245: DELETE FROM ZX_REC_NREC_DIST dist
1246: WHERE EXISTS (
1247: SELECT 1
1248: FROM zx_lines_det_factors
1249: WHERE APPLICATION_ID = dist.application_id
1250: AND ENTITY_CODE = dist.entity_code
1251: AND EVENT_CLASS_CODE = dist.event_class_code
1252: AND TRX_ID = dist.trx_id

Line 2835: FROM zx_lines_det_factors

2831: AND (Process_For_Recovery_Flag = 'Y' OR
2832: Item_Dist_Changed_Flag = 'Y')
2833: AND EXISTS
2834: (SELECT 1
2835: FROM zx_lines_det_factors
2836: WHERE APPLICATION_ID = L.application_id
2837: AND ENTITY_CODE = L.entity_code
2838: AND EVENT_CLASS_CODE = L.event_class_code
2839: AND TRX_ID = L.trx_id

Line 2871: FROM zx_lines_det_factors

2867: AND entity_code = p_event_class_rec.entity_code
2868: AND event_class_code = p_event_class_rec.event_class_code
2869: AND (trx_id, trx_line_id, trx_level_type) IN
2870: (SELECT trx_id, trx_line_id, trx_level_type
2871: FROM zx_lines_det_factors
2872: WHERE application_id = p_event_class_rec.application_id
2873: AND entity_code = p_event_class_rec.entity_code
2874: AND event_class_code = p_event_class_rec.event_class_code
2875: AND event_id = p_event_class_rec.event_id

Line 2918: FROM zx_lines_det_factors

2914: AND (process_for_recovery_flag = 'Y' OR
2915: item_dist_changed_flag = 'Y')
2916: AND EXISTS
2917: (SELECT 1
2918: FROM zx_lines_det_factors
2919: WHERE application_id = zl.application_id
2920: AND entity_code = zl.entity_code
2921: AND event_class_code = zl.event_class_code
2922: AND trx_id = zl.trx_id

Line 2996: from zx_lines_det_factors

2992: x_return_status := FND_API.G_RET_STS_SUCCESS;
2993:
2994: select trx_id, trx_line_id, trx_level_type
2995: bulk collect into pg_trx_id_tab, pg_trx_line_id_tab ,pg_trx_level_type_tab
2996: from zx_lines_det_factors
2997: where application_id = p_event_class_rec.application_id
2998: and entity_code = p_event_class_rec.entity_code
2999: and event_class_code = p_event_class_rec.event_class_code
3000: and event_id = p_event_class_rec.event_id;

Line 3058: ( select 1 from zx_lines_det_factors

3054: WHERE application_id = p_event_class_rec.application_id
3055: AND entity_code = p_event_class_rec.entity_code
3056: AND event_class_code = p_event_class_rec.event_class_code
3057: /*AND exists
3058: ( select 1 from zx_lines_det_factors
3059: where application_id = l.application_id
3060: and entity_code = l.entity_code
3061: and event_class_code = l.event_class_code
3062: and trx_id = l.trx_id

Line 3100: ( select 1 from zx_lines_det_factors

3096: WHERE application_id = p_event_class_rec.application_id
3097: AND entity_code = p_event_class_rec.entity_code
3098: AND event_class_code = p_event_class_rec.event_class_code
3099: AND exists
3100: ( select 1 from zx_lines_det_factors
3101: where application_id = S.application_id
3102: and entity_code = S.entity_code
3103: and event_class_code = S.event_class_code
3104: and trx_id = S.trx_id

Line 5196: FROM zx_lines_det_factors line

5192: AND trx_id = p_event_class_rec.trx_id
5193: */
5194: EXISTS (
5195: SELECT 1
5196: FROM zx_lines_det_factors line
5197: WHERE tax.application_id = line.application_id
5198: AND tax.event_class_code = line.event_class_code
5199: AND tax.entity_code = line.entity_code
5200: AND tax.trx_id = line.trx_id

Line 5475: FROM zx_lines_det_factors line

5471: AND trx_id = p_event_class_rec.trx_id
5472: */
5473: EXISTS (
5474: SELECT 1
5475: FROM zx_lines_det_factors line
5476: WHERE tax.application_id = line.application_id
5477: AND tax.event_class_code = line.event_class_code
5478: AND tax.entity_code = line.entity_code
5479: AND tax.trx_id = line.trx_id

Line 5622: FROM zx_lines_det_factors line

5618: --AND event_class_code = p_event_class_rec.event_class_code
5619: --AND trx_id = p_event_class_rec.trx_id
5620: WHERE EXISTS (
5621: SELECT 1
5622: FROM zx_lines_det_factors line
5623: WHERE tax.application_id = line.application_id
5624: AND tax.event_class_code = line.event_class_code
5625: AND tax.entity_code = line.entity_code
5626: AND tax.trx_id = line.trx_id

Line 5935: FROM zx_lines_det_factors line

5931: FROM ZX_LINES tax
5932: -- bug fix 5417887
5933: WHERE EXISTS (
5934: SELECT 1
5935: FROM zx_lines_det_factors line
5936: WHERE tax.application_id = line.application_id
5937: AND tax.event_class_code = line.event_class_code
5938: AND tax.entity_code = line.entity_code
5939: AND tax.trx_id = line.trx_id

Line 6087: FROM zx_lines_det_factors line

6083: --AND event_class_code = p_event_class_rec.event_class_code
6084: --AND trx_id = p_event_class_rec.trx_id
6085: WHERE EXISTS (
6086: SELECT 1
6087: FROM zx_lines_det_factors line
6088: WHERE tax.application_id = line.application_id
6089: AND tax.event_class_code = line.event_class_code
6090: AND tax.entity_code = line.entity_code
6091: AND tax.trx_id = line.trx_id