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.

[Home] [Help]

APPS.GCS_DYN_FEM_POSTING_PKG dependencies on GCS_ENTRY_LINES

Line 92: FROM GCS_ENTRY_LINES GLE

88: nvl(GLE.PTD_DEBIT_BALANCE_E, GLE.YTD_DEBIT_BALANCE_E),
89: nvl(GLE.PTD_CREDIT_BALANCE_E, GLE.YTD_CREDIT_BALANCE_E),
90: GLE.YTD_DEBIT_BALANCE_E,
91: GLE.YTD_CREDIT_BALANCE_E
92: FROM GCS_ENTRY_LINES GLE
93: WHERE GLE.entry_id = l_entry_id_list(i);
94:
95: -- The following is happening when consolidating adjustments on operating entities
96: ELSIF (p_child_entity_id is not null) THEN

Line 160: GCS_ENTRY_LINES GLE

156: sum(GLE.YTD_DEBIT_BALANCE_E) YTD_DEBIT_BALANCE_E,
157: sum(GLE.YTD_CREDIT_BALANCE_E) YTD_CREDIT_BALANCE_E
158: FROM GCS_CONS_ENG_RUN_DTLS GCERD,
159: GCS_ENTRY_HEADERS GHD,
160: GCS_ENTRY_LINES GLE
161: WHERE GCERD.run_name = p_run_name
162: AND GCERD.consolidation_entity_id = p_cons_entity_id
163: AND GCERD.child_entity_id = p_child_entity_id
164: AND GCERD.category_code = p_category_code

Line 224: GCS_ENTRY_LINES GLE

220: sum(GLE.YTD_DEBIT_BALANCE_E) YTD_DEBIT_BALANCE_E,
221: sum(GLE.YTD_CREDIT_BALANCE_E) YTD_CREDIT_BALANCE_E
222: FROM GCS_CONS_ENG_RUN_DTLS GCERD,
223: GCS_ENTRY_HEADERS GHD,
224: GCS_ENTRY_LINES GLE
225: WHERE GCERD.run_name = p_run_name
226: AND GCERD.consolidation_entity_id = p_cons_entity_id
227: AND GCERD.child_entity_id = p_child_entity_id
228: AND GCERD.category_code = p_category_code

Line 299: GCS_ENTRY_LINES GLE

295: sum(GLE.YTD_DEBIT_BALANCE_E) YTD_DEBIT_BALANCE_E,
296: sum(GLE.YTD_CREDIT_BALANCE_E) YTD_CREDIT_BALANCE_E
297: FROM GCS_CONS_ENG_RUN_DTLS GCERD,
298: GCS_ENTRY_HEADERS GHD,
299: GCS_ENTRY_LINES GLE
300: WHERE GCERD.run_name = p_run_name
301: AND GCERD.consolidation_entity_id = p_cons_entity_id
302: AND GCERD.category_code = p_category_code
303: AND GHD.entry_id in (GCERD.entry_id, GCERD.stat_entry_id)

Line 362: GCS_ENTRY_LINES GLE

358: sum(GLE.YTD_DEBIT_BALANCE_E) YTD_DEBIT_BALANCE_E,
359: sum(GLE.YTD_CREDIT_BALANCE_E) YTD_CREDIT_BALANCE_E
360: FROM GCS_CONS_ENG_RUN_DTLS GCERD,
361: GCS_ENTRY_HEADERS GHD,
362: GCS_ENTRY_LINES GLE
363: WHERE GCERD.run_name = p_run_name
364: AND GCERD.consolidation_entity_id = p_cons_entity_id
365: AND GCERD.category_code = p_category_code
366: AND GHD.entry_id in (GCERD.entry_id, GCERD.stat_entry_id)