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.XLA_PERIOD_CLOSE_EXP_PKG dependencies on GL_LEDGER_RELATIONSHIPS

Line 111: FROM gl_ledger_relationships glr1,

107: 'E')
108: AND xle.application_id = xlo.application_id
109: AND xlo.capture_event_flag = 'Y'
110: AND EXISTS (SELECT 1
111: FROM gl_ledger_relationships glr1,
112: gl_ledger_relationships glr2
113: WHERE glr1.target_ledger_id = xlo.ledger_id
114: AND glr2.target_ledger_id = p_ledger_id
115: AND glr2.source_ledger_id = glr1.source_ledger_id

Line 112: gl_ledger_relationships glr2

108: AND xle.application_id = xlo.application_id
109: AND xlo.capture_event_flag = 'Y'
110: AND EXISTS (SELECT 1
111: FROM gl_ledger_relationships glr1,
112: gl_ledger_relationships glr2
113: WHERE glr1.target_ledger_id = xlo.ledger_id
114: AND glr2.target_ledger_id = p_ledger_id
115: AND glr2.source_ledger_id = glr1.source_ledger_id
116: AND glr2.application_id = glr1.application_id

Line 152: FROM gl_ledger_relationships glr1,

148: xla_events xle,
149: xla_transaction_entities_upg xte, --bug11830219 changed from XTE to UPG synonym
150: gl_period_statuses glp
151: WHERE EXISTS (SELECT 1
152: FROM gl_ledger_relationships glr1,
153: gl_ledger_relationships glr2
154: WHERE aeh.ledger_id = glr2.target_ledger_id
155: AND glr2.source_ledger_id = glr1.source_ledger_id
156: AND glr2.application_id = glr1.application_id

Line 153: gl_ledger_relationships glr2

149: xla_transaction_entities_upg xte, --bug11830219 changed from XTE to UPG synonym
150: gl_period_statuses glp
151: WHERE EXISTS (SELECT 1
152: FROM gl_ledger_relationships glr1,
153: gl_ledger_relationships glr2
154: WHERE aeh.ledger_id = glr2.target_ledger_id
155: AND glr2.source_ledger_id = glr1.source_ledger_id
156: AND glr2.application_id = glr1.application_id
157: AND glr1.target_ledger_id = p_ledger_id

Line 214: FROM gl_ledger_relationships glr1,

210: 'E')
211: AND xle.application_id = xlo.application_id
212: AND xlo.capture_event_flag = 'Y'
213: AND EXISTS (SELECT 1
214: FROM gl_ledger_relationships glr1,
215: gl_ledger_relationships glr2
216: WHERE glr1.target_ledger_id = xlo.ledger_id
217: AND glr2.target_ledger_id = p_ledger_id
218: AND glr2.source_ledger_id = glr1.source_ledger_id

Line 215: gl_ledger_relationships glr2

211: AND xle.application_id = xlo.application_id
212: AND xlo.capture_event_flag = 'Y'
213: AND EXISTS (SELECT 1
214: FROM gl_ledger_relationships glr1,
215: gl_ledger_relationships glr2
216: WHERE glr1.target_ledger_id = xlo.ledger_id
217: AND glr2.target_ledger_id = p_ledger_id
218: AND glr2.source_ledger_id = glr1.source_ledger_id
219: AND glr2.application_id = glr1.application_id

Line 250: FROM gl_ledger_relationships glr1,

246: FROM xla_ae_headers aeh,
247: xla_events xle,
248: xla_transaction_entities_upg xte --bug11830219 changed from XTE to UPG synonym
249: WHERE EXISTS (SELECT 1
250: FROM gl_ledger_relationships glr1,
251: gl_ledger_relationships glr2
252: WHERE aeh.ledger_id = glr2.target_ledger_id
253: AND glr2.source_ledger_id = glr1.source_ledger_id
254: AND glr2.application_id = glr1.application_id

Line 251: gl_ledger_relationships glr2

247: xla_events xle,
248: xla_transaction_entities_upg xte --bug11830219 changed from XTE to UPG synonym
249: WHERE EXISTS (SELECT 1
250: FROM gl_ledger_relationships glr1,
251: gl_ledger_relationships glr2
252: WHERE aeh.ledger_id = glr2.target_ledger_id
253: AND glr2.source_ledger_id = glr1.source_ledger_id
254: AND glr2.application_id = glr1.application_id
255: AND glr1.target_ledger_id = p_ledger_id