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.GCS_PERIOD_INIT_DYNAMIC_PKG dependencies on GCS_ENTRY_HEADERS

Line 97: gcs_entry_headers geh

93: 0
94: BULK COLLECT INTO
95: l_entry_id_list
96: FROM gcs_cons_eng_run_dtls gcerd,
97: gcs_entry_headers geh
98: WHERE gcerd.run_name = p_run_name
99: AND gcerd.consolidation_entity_id = p_cons_entity_id
100: AND gcerd.child_entity_id IS NOT NULL
101: AND gcerd.category_code = p_category_code

Line 114: gcs_entry_headers geh

110: 0
111: BULK COLLECT INTO
112: l_entry_id_list
113: FROM gcs_cons_eng_run_dtls gcerd,
114: gcs_entry_headers geh
115: WHERE gcerd.run_name = p_run_name
116: AND gcerd.consolidation_entity_id = p_cons_entity_id
117: AND gcerd.child_entity_id IS NOT NULL
118: AND gcerd.category_code = p_category_code

Line 130: gcs_entry_headers geh

126: NVL(geh.end_cal_period_id, geh.start_cal_period_id) - geh.start_cal_period_id
127: BULK COLLECT INTO
128: l_entry_id_list
129: FROM gcs_cons_eng_run_dtls gcerd,
130: gcs_entry_headers geh
131: WHERE gcerd.run_name = p_run_name
132: AND gcerd.consolidation_entity_id = p_cons_entity_id
133: AND gcerd.child_entity_id IS NOT NULL
134: AND gcerd.category_code = p_category_code

Line 149: gcs_entry_headers geh

145: 0
146: BULK COLLECT INTO
147: l_entry_id_list
148: FROM gcs_cons_eng_run_dtls gcerd,
149: gcs_entry_headers geh
150: WHERE gcerd.run_name = p_run_name
151: AND gcerd.consolidation_entity_id = p_cons_entity_id
152: AND gcerd.child_entity_id = p_entity_id
153: AND gcerd.category_code = p_category_code

Line 166: gcs_entry_headers geh

162: 0
163: BULK COLLECT INTO
164: l_entry_id_list
165: FROM gcs_cons_eng_run_dtls gcerd,
166: gcs_entry_headers geh
167: WHERE gcerd.run_name = p_run_name
168: AND gcerd.consolidation_entity_id = p_cons_entity_id
169: AND gcerd.child_entity_id = p_entity_id
170: AND gcerd.category_code = p_category_code

Line 182: gcs_entry_headers geh

178: NVL(geh.end_cal_period_id, geh.start_cal_period_id) - geh.start_cal_period_id
179: BULK COLLECT INTO
180: l_entry_id_list
181: FROM gcs_cons_eng_run_dtls gcerd,
182: gcs_entry_headers geh
183: WHERE gcerd.run_name = p_run_name
184: AND gcerd.consolidation_entity_id = p_cons_entity_id
185: AND gcerd.child_entity_id = p_entity_id
186: AND gcerd.category_code = p_category_code

Line 262: --Also remove join to gcs_entry_headers as all of the information is available in the PL/SQL collection

258: ytd_debit_balance_e,
259: ytd_credit_balance_e)
260: SELECT
261: --Bugfix 5449718: Remove the references to the init_xlate_entry_id, and removed all group by calcs as this is happening on a line by line basis.
262: --Also remove join to gcs_entry_headers as all of the information is available in the PL/SQL collection
263: decode(l_currency_code_list(i), 'STAT', p_init_stat_entry_id,
264: p_init_entry_id),
265: decode(feata.dim_attribute_varchar_member,
266: 'REVENUE', 'PROFIT_LOSS',

Line 330: --Also remove join to gcs_entry_headers as all of the information is available in the PL/SQL collection

326: ytd_debit_balance_e,
327: ytd_credit_balance_e)
328: SELECT
329: --Bugfix 5449718: Remove the references to the init_xlate_entry_id, and removed all group by calcs as this is happening on a line by line basis.
330: --Also remove join to gcs_entry_headers as all of the information is available in the PL/SQL collection
331: --Join to line type is no longer required as all rows for recurring entries have the line type code populated
332: decode(l_currency_code_list(i), 'STAT', p_init_stat_entry_id,
333: p_init_entry_id),
334: l2.line_type_code,