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_REVERSE_DOCUMENT_PKG dependencies on ZX_REVERSE_TRX_LINES_GT

Line 40: INDEX(lngt ZX_REVERSE_TRX_LINES_GT_U1) */

36: reversing_trx_id,
37: trx_number
38: FROM
39: (SELECT /*+ ORDERED INDEX(hdrgt ZX_REV_TRX_HEADERS_GT_U1)
40: INDEX(lngt ZX_REVERSE_TRX_LINES_GT_U1) */
41: DISTINCT
42: summ.summary_tax_line_id,
43: lngt.reversing_appln_id,
44: lngt.reversing_entity_code,

Line 49: zx_reverse_trx_lines_gt lngt,

45: lngt.reversing_evnt_cls_code,
46: lngt.reversing_trx_id,
47: hdrgt.trx_number
48: FROM zx_rev_trx_headers_gt hdrgt,
49: zx_reverse_trx_lines_gt lngt,
50: zx_lines_summary summ
51: WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
52: AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
53: AND hdrgt.reversing_evnt_cls_code = p_event_class_rec.event_class_code

Line 76: INDEX(lngt ZX_REVERSE_TRX_LINES_GT_U1) */

72: );
73:
74: CURSOR get_rev_tax_lines_info_csr IS
75: SELECT /*+ ORDERED INDEX(hdrgt ZX_REV_TRX_HEADERS_GT_U1)
76: INDEX(lngt ZX_REVERSE_TRX_LINES_GT_U1) */
77: zl.tax_line_id, -- from zx_lines
78: zx_lines_s.NEXTVAL, -- from Sequence
79: zl.offset_link_to_tax_line_id, -- from zx_lines
80: zl.summary_tax_line_id, -- from zx_lines

Line 89: zx_reverse_trx_lines_gt lngt,

85: lngt.reversing_trx_line_id, -- from line gt
86: lngt.reversing_trx_level_type, -- from line gt
87: hdrgt.trx_number -- from header gt
88: FROM zx_rev_trx_headers_gt hdrgt,
89: zx_reverse_trx_lines_gt lngt,
90: zx_lines zl
91: WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
92: AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
93: AND hdrgt.reversing_evnt_cls_code = p_event_class_rec.event_class_code

Line 107: TYPE reversing_appln_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_appln_id%TYPE INDEX BY BINARY_INTEGER;

103: AND zl.trx_line_id = lngt.reversed_trx_line_id
104: AND zl.trx_level_type = lngt.reversed_trx_level_type;
105:
106:
107: TYPE reversing_appln_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_appln_id%TYPE INDEX BY BINARY_INTEGER;
108: TYPE reversing_entity_code_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_entity_code%TYPE INDEX BY BINARY_INTEGER;
109: TYPE reversing_evnt_cls_code_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_evnt_cls_code%TYPE INDEX BY BINARY_INTEGER;
110: TYPE reversing_trx_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_id%TYPE INDEX BY BINARY_INTEGER;
111: TYPE reversing_trx_line_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_line_id%TYPE INDEX BY BINARY_INTEGER;

Line 108: TYPE reversing_entity_code_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_entity_code%TYPE INDEX BY BINARY_INTEGER;

104: AND zl.trx_level_type = lngt.reversed_trx_level_type;
105:
106:
107: TYPE reversing_appln_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_appln_id%TYPE INDEX BY BINARY_INTEGER;
108: TYPE reversing_entity_code_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_entity_code%TYPE INDEX BY BINARY_INTEGER;
109: TYPE reversing_evnt_cls_code_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_evnt_cls_code%TYPE INDEX BY BINARY_INTEGER;
110: TYPE reversing_trx_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_id%TYPE INDEX BY BINARY_INTEGER;
111: TYPE reversing_trx_line_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_line_id%TYPE INDEX BY BINARY_INTEGER;
112: TYPE reversing_trx_level_type_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_level_type%TYPE INDEX BY BINARY_INTEGER;

Line 109: TYPE reversing_evnt_cls_code_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_evnt_cls_code%TYPE INDEX BY BINARY_INTEGER;

105:
106:
107: TYPE reversing_appln_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_appln_id%TYPE INDEX BY BINARY_INTEGER;
108: TYPE reversing_entity_code_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_entity_code%TYPE INDEX BY BINARY_INTEGER;
109: TYPE reversing_evnt_cls_code_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_evnt_cls_code%TYPE INDEX BY BINARY_INTEGER;
110: TYPE reversing_trx_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_id%TYPE INDEX BY BINARY_INTEGER;
111: TYPE reversing_trx_line_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_line_id%TYPE INDEX BY BINARY_INTEGER;
112: TYPE reversing_trx_level_type_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_level_type%TYPE INDEX BY BINARY_INTEGER;
113: TYPE trx_number_tp IS TABLE OF zx_rev_trx_headers_gt.trx_number%TYPE INDEX BY BINARY_INTEGER;

Line 110: TYPE reversing_trx_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_id%TYPE INDEX BY BINARY_INTEGER;

106:
107: TYPE reversing_appln_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_appln_id%TYPE INDEX BY BINARY_INTEGER;
108: TYPE reversing_entity_code_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_entity_code%TYPE INDEX BY BINARY_INTEGER;
109: TYPE reversing_evnt_cls_code_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_evnt_cls_code%TYPE INDEX BY BINARY_INTEGER;
110: TYPE reversing_trx_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_id%TYPE INDEX BY BINARY_INTEGER;
111: TYPE reversing_trx_line_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_line_id%TYPE INDEX BY BINARY_INTEGER;
112: TYPE reversing_trx_level_type_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_level_type%TYPE INDEX BY BINARY_INTEGER;
113: TYPE trx_number_tp IS TABLE OF zx_rev_trx_headers_gt.trx_number%TYPE INDEX BY BINARY_INTEGER;
114:

Line 111: TYPE reversing_trx_line_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_line_id%TYPE INDEX BY BINARY_INTEGER;

107: TYPE reversing_appln_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_appln_id%TYPE INDEX BY BINARY_INTEGER;
108: TYPE reversing_entity_code_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_entity_code%TYPE INDEX BY BINARY_INTEGER;
109: TYPE reversing_evnt_cls_code_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_evnt_cls_code%TYPE INDEX BY BINARY_INTEGER;
110: TYPE reversing_trx_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_id%TYPE INDEX BY BINARY_INTEGER;
111: TYPE reversing_trx_line_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_line_id%TYPE INDEX BY BINARY_INTEGER;
112: TYPE reversing_trx_level_type_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_level_type%TYPE INDEX BY BINARY_INTEGER;
113: TYPE trx_number_tp IS TABLE OF zx_rev_trx_headers_gt.trx_number%TYPE INDEX BY BINARY_INTEGER;
114:
115: l_reversed_tax_line_id_tb tax_line_id_tp;

Line 112: TYPE reversing_trx_level_type_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_level_type%TYPE INDEX BY BINARY_INTEGER;

108: TYPE reversing_entity_code_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_entity_code%TYPE INDEX BY BINARY_INTEGER;
109: TYPE reversing_evnt_cls_code_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_evnt_cls_code%TYPE INDEX BY BINARY_INTEGER;
110: TYPE reversing_trx_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_id%TYPE INDEX BY BINARY_INTEGER;
111: TYPE reversing_trx_line_id_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_line_id%TYPE INDEX BY BINARY_INTEGER;
112: TYPE reversing_trx_level_type_tp IS TABLE OF zx_reverse_trx_lines_gt.reversing_trx_level_type%TYPE INDEX BY BINARY_INTEGER;
113: TYPE trx_number_tp IS TABLE OF zx_rev_trx_headers_gt.trx_number%TYPE INDEX BY BINARY_INTEGER;
114:
115: l_reversed_tax_line_id_tb tax_line_id_tp;
116: l_reversing_tax_line_id_tb tax_line_id_tp;

Line 391: -- 4. Some columns(11) have new values from zx_reverse_trx_lines_gt.

387: -- l_reversed_tax_line_id_tb.
388: -- 2. All the amount related columns have values reversed from
389: -- the reversing document.
390: -- 3. Some columns(16) have new values from zx_rev_trx_headers_gt.
391: -- 4. Some columns(11) have new values from zx_reverse_trx_lines_gt.
392: -- 5. WHO columns(5) have new values with current user and sysdate.
393: -- 6. if a tax line has a offset_link_to_tax_line_id, the new value of this
394: -- column will point to the new reversed detail tax line.
395: -- 7. if a tax line has a summary_tax_line_id, the new value of this