APPS.ZX_TDS_REVERSE_DOCUMENT_PKG dependencies on ZX_REV_TRX_HEADERS_GT

Line 39: (SELECT /*+ ORDERED INDEX(hdrgt ZX_REV_TRX_HEADERS_GT_U1)

35: reversing_evnt_cls_code,
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,

Line 48: FROM zx_rev_trx_headers_gt hdrgt,

44: lngt.reversing_entity_code,
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

Line 75: SELECT /*+ ORDERED INDEX(hdrgt ZX_REV_TRX_HEADERS_GT_U1)

71: )
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

Line 88: FROM zx_rev_trx_headers_gt hdrgt,

84: lngt.reversing_trx_id, -- from line gt
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

Line 113: TYPE trx_number_tp IS TABLE OF zx_rev_trx_headers_gt.trx_number%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;
117: l_offset_link_to_tx_line_id_tb tax_line_id_tp;

Line 390: -- 3. Some columns(16) have new values from zx_rev_trx_headers_gt.

386: -- 1. tax_line_id has new value form sequence zx_lines_s, stored in
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.