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.ARP_DESCR_FLEX dependencies on RA_CUSTOMER_TRX

Line 10: | of the descriptive flexfields in the ra_customer_trx and |

6: | |
7: | PUBLIC PROCEDURE: get_concatenated_segments |
8: | |
9: | This procedure returns the concatenated segments and context values |
10: | of the descriptive flexfields in the ra_customer_trx and |
11: | ra_customer_trx_lines tables. |
12: | For now, this function hardcodes all column and flexfield information. |
13: | When PL/SQL supports dynamic SQL, this function could be rewritten to |
14: | be more generic. |

Line 11: | ra_customer_trx_lines tables. |

7: | PUBLIC PROCEDURE: get_concatenated_segments |
8: | |
9: | This procedure returns the concatenated segments and context values |
10: | of the descriptive flexfields in the ra_customer_trx and |
11: | ra_customer_trx_lines tables. |
12: | For now, this function hardcodes all column and flexfield information. |
13: | When PL/SQL supports dynamic SQL, this function could be rewritten to |
14: | be more generic. |
15: | |

Line 31: cursor ra_customer_trx_lines_C( p_flex_name in varchar2,

27:
28:
29: first boolean;
30:
31: cursor ra_customer_trx_lines_C( p_flex_name in varchar2,
32: p_customer_trx_line_id in number) IS
33: select decode(u.descriptive_flexfield_name,
34: 'RA_INTERFACE_LINES',
35: decode(u.application_column_name,

Line 51: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_transaction_code,

47: 'INTERFACE_LINE_ATTRIBUTE12', l.interface_line_attribute12,
48: 'INTERFACE_LINE_ATTRIBUTE13', l.interface_line_attribute13,
49: 'INTERFACE_LINE_ATTRIBUTE14', l.interface_line_attribute14,
50: 'INTERFACE_LINE_ATTRIBUTE15', l.interface_line_attribute15),
51: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_transaction_code,
52: 'RA_CUSTOMER_TRX_LINES', decode(u.application_column_name,
53: 'ATTRIBUTE1', l.attribute1,
54: 'ATTRIBUTE2', l.attribute2,
55: 'ATTRIBUTE3', l.attribute3,

Line 52: 'RA_CUSTOMER_TRX_LINES', decode(u.application_column_name,

48: 'INTERFACE_LINE_ATTRIBUTE13', l.interface_line_attribute13,
49: 'INTERFACE_LINE_ATTRIBUTE14', l.interface_line_attribute14,
50: 'INTERFACE_LINE_ATTRIBUTE15', l.interface_line_attribute15),
51: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_transaction_code,
52: 'RA_CUSTOMER_TRX_LINES', decode(u.application_column_name,
53: 'ATTRIBUTE1', l.attribute1,
54: 'ATTRIBUTE2', l.attribute2,
55: 'ATTRIBUTE3', l.attribute3,
56: 'ATTRIBUTE4', l.attribute4,

Line 71: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_trx_code_context,

67: 'ATTRIBUTE15', l.attribute15)
68: ) segment_value,
69: decode(u.descriptive_flexfield_name,
70: 'RA_INTERFACE_LINES', l.interface_line_context,
71: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_trx_code_context,
72: 'RA_CUSTOMER_TRX_LINES', l.attribute_category,
73: '') context,
74: f.concatenated_segment_delimiter delimiter
75: from fnd_descr_flex_column_usages u,

Line 72: 'RA_CUSTOMER_TRX_LINES', l.attribute_category,

68: ) segment_value,
69: decode(u.descriptive_flexfield_name,
70: 'RA_INTERFACE_LINES', l.interface_line_context,
71: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_trx_code_context,
72: 'RA_CUSTOMER_TRX_LINES', l.attribute_category,
73: '') context,
74: f.concatenated_segment_delimiter delimiter
75: from fnd_descr_flex_column_usages u,
76: fnd_descriptive_flexs f,

Line 77: ra_customer_trx_lines l

73: '') context,
74: f.concatenated_segment_delimiter delimiter
75: from fnd_descr_flex_column_usages u,
76: fnd_descriptive_flexs f,
77: ra_customer_trx_lines l
78: where u.descriptive_flexfield_name = p_flex_name
79: and u.application_id = 222
80: and u.enabled_flag = 'Y'
81: and u.descriptive_flexfield_name = f.descriptive_flexfield_name

Line 86: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_trx_code_context,

82: and u.application_id = f.application_id
83: and nvl(
84: decode(u.descriptive_flexfield_name,
85: 'RA_INTERFACE_LINES', l.interface_line_context,
86: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_trx_code_context,
87: 'RA_CUSTOMER_TRX_LINES', l.attribute_category,
88: ''),
89: 'Global Data Elements'
90: ) = descriptive_flex_context_code

Line 87: 'RA_CUSTOMER_TRX_LINES', l.attribute_category,

83: and nvl(
84: decode(u.descriptive_flexfield_name,
85: 'RA_INTERFACE_LINES', l.interface_line_context,
86: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_trx_code_context,
87: 'RA_CUSTOMER_TRX_LINES', l.attribute_category,
88: ''),
89: 'Global Data Elements'
90: ) = descriptive_flex_context_code
91: and customer_trx_line_id = p_customer_trx_line_id

Line 94: cursor ra_customer_trx_C( p_flex_name in varchar2,

90: ) = descriptive_flex_context_code
91: and customer_trx_line_id = p_customer_trx_line_id
92: order by column_seq_num;
93:
94: cursor ra_customer_trx_C( p_flex_name in varchar2,
95: p_customer_trx_id in number) IS
96: select decode(u.descriptive_flexfield_name,
97: 'RA_INTERFACE_HEADER',
98: decode(u.application_column_name,

Line 114: 'RA_CUSTOMER_TRX_GOV', t.default_ussgl_transaction_code,

110: 'INTERFACE_HEADER_ATTRIBUTE12', t.interface_header_attribute12,
111: 'INTERFACE_HEADER_ATTRIBUTE13', t.interface_header_attribute13,
112: 'INTERFACE_HEADER_ATTRIBUTE14', t.interface_header_attribute14,
113: 'INTERFACE_HEADER_ATTRIBUTE15', t.interface_header_attribute15),
114: 'RA_CUSTOMER_TRX_GOV', t.default_ussgl_transaction_code,
115: 'RA_CUSTOMER_TRX', decode(u.application_column_name,
116: 'ATTRIBUTE1', t.attribute1,
117: 'ATTRIBUTE2', t.attribute2,
118: 'ATTRIBUTE3', t.attribute3,

Line 115: 'RA_CUSTOMER_TRX', decode(u.application_column_name,

111: 'INTERFACE_HEADER_ATTRIBUTE13', t.interface_header_attribute13,
112: 'INTERFACE_HEADER_ATTRIBUTE14', t.interface_header_attribute14,
113: 'INTERFACE_HEADER_ATTRIBUTE15', t.interface_header_attribute15),
114: 'RA_CUSTOMER_TRX_GOV', t.default_ussgl_transaction_code,
115: 'RA_CUSTOMER_TRX', decode(u.application_column_name,
116: 'ATTRIBUTE1', t.attribute1,
117: 'ATTRIBUTE2', t.attribute2,
118: 'ATTRIBUTE3', t.attribute3,
119: 'ATTRIBUTE4', t.attribute4,

Line 134: 'RA_CUSTOMER_TRX_GOV', t.default_ussgl_trx_code_context,

130: 'ATTRIBUTE15', t.attribute15)
131: ) segment_value,
132: decode(u.descriptive_flexfield_name,
133: 'RA_INTERFACE_HEADER', t.interface_header_context,
134: 'RA_CUSTOMER_TRX_GOV', t.default_ussgl_trx_code_context,
135: 'RA_CUSTOMER_TRX', t.attribute_category,
136: '') context,
137: f.concatenated_segment_delimiter delimiter
138: from fnd_descr_flex_column_usages u,

Line 135: 'RA_CUSTOMER_TRX', t.attribute_category,

131: ) segment_value,
132: decode(u.descriptive_flexfield_name,
133: 'RA_INTERFACE_HEADER', t.interface_header_context,
134: 'RA_CUSTOMER_TRX_GOV', t.default_ussgl_trx_code_context,
135: 'RA_CUSTOMER_TRX', t.attribute_category,
136: '') context,
137: f.concatenated_segment_delimiter delimiter
138: from fnd_descr_flex_column_usages u,
139: fnd_descriptive_flexs f,

Line 140: ra_customer_trx t

136: '') context,
137: f.concatenated_segment_delimiter delimiter
138: from fnd_descr_flex_column_usages u,
139: fnd_descriptive_flexs f,
140: ra_customer_trx t
141: where u.descriptive_flexfield_name = p_flex_name
142: and u.application_id = 222
143: and u.enabled_flag = 'Y'
144: and u.descriptive_flexfield_name = f.descriptive_flexfield_name

Line 149: 'RA_CUSTOMER_TRX_GOV', t.default_ussgl_trx_code_context,

145: and u.application_id = f.application_id
146: and nvl(
147: decode(u.descriptive_flexfield_name,
148: 'RA_INTERFACE_HEADER', t.interface_header_context,
149: 'RA_CUSTOMER_TRX_GOV', t.default_ussgl_trx_code_context,
150: 'RA_CUSTOMER_TRX', t.attribute_category,
151: ''),
152: 'Global Data Elements'
153: ) = descriptive_flex_context_code

Line 150: 'RA_CUSTOMER_TRX', t.attribute_category,

146: and nvl(
147: decode(u.descriptive_flexfield_name,
148: 'RA_INTERFACE_HEADER', t.interface_header_context,
149: 'RA_CUSTOMER_TRX_GOV', t.default_ussgl_trx_code_context,
150: 'RA_CUSTOMER_TRX', t.attribute_category,
151: ''),
152: 'Global Data Elements'
153: ) = descriptive_flex_context_code
154: and customer_trx_id = p_customer_trx_id

Line 168: if (p_table_name = 'RA_CUSTOMER_TRX_LINES')

164: | Select each segment of the flexfield in order and concatenate |
165: | it onto the previous segments. |
166: +----------------------------------------------------------------*/
167:
168: if (p_table_name = 'RA_CUSTOMER_TRX_LINES')
169: then
170: FOR segments in ra_customer_trx_lines_C(p_flex_name,
171: p_customer_trx_line_id )
172: LOOP

Line 170: FOR segments in ra_customer_trx_lines_C(p_flex_name,

166: +----------------------------------------------------------------*/
167:
168: if (p_table_name = 'RA_CUSTOMER_TRX_LINES')
169: then
170: FOR segments in ra_customer_trx_lines_C(p_flex_name,
171: p_customer_trx_line_id )
172: LOOP
173: if (first <> true)
174: then p_concatenated_segments := p_concatenated_segments ||

Line 187: if (p_table_name = 'RA_CUSTOMER_TRX')

183:
184: END LOOP;
185: end if;
186:
187: if (p_table_name = 'RA_CUSTOMER_TRX')
188: then
189: FOR segments in ra_customer_trx_C(p_flex_name,
190: p_customer_trx_id )
191: LOOP

Line 189: FOR segments in ra_customer_trx_C(p_flex_name,

185: end if;
186:
187: if (p_table_name = 'RA_CUSTOMER_TRX')
188: then
189: FOR segments in ra_customer_trx_C(p_flex_name,
190: p_customer_trx_id )
191: LOOP
192: if (first <> true)
193: then p_concatenated_segments := p_concatenated_segments ||