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.XLA_BALANCES_PKG dependencies on XLA_AE_HEADERS

Line 3779: FROM xla_ae_headers aeh

3775: p_ins_bind_var_num:=1;
3776:
3777: p_entry_locking_dyn_stmt :=
3778: ' SELECT 1
3779: FROM xla_ae_headers aeh
3780: ,xla_ae_lines ael
3781: WHERE ael.ae_header_id = aeh.ae_header_id
3782: AND ael.application_id = aeh.application_id
3783: AND aeh.accounting_entry_status_code IN (''D'', ''F'')

Line 4038: FROM xla_ae_headers aeh

4034: ,ael.party_id
4035: ,NVL(ael.party_site_id,-999) party_site_id
4036: ,ael.accounted_dr
4037: ,ael.accounted_cr
4038: FROM xla_ae_headers aeh
4039: ,xla_ae_lines ael
4040: ,gl_period_statuses gps
4041: WHERE ael.ae_header_id = aeh.ae_header_id
4042: AND ael.application_id = aeh.application_id

Line 4313: ,xla_ae_headers aeh

4309: ,ael.accounted_dr
4310: ,ael.accounted_cr
4311: FROM xla_events xev
4312: ,xla_events_gt xeg
4313: ,xla_ae_headers aeh
4314: ,xla_ae_lines ael
4315: ,gl_period_statuses gps
4316: WHERE xev.application_id = p_application_id
4317: AND xeg.event_id = xev.event_id

Line 4357: ,xla_ae_headers aeh

4353: ,ael.party_site_id
4354: ,ael.accounted_dr
4355: ,ael.accounted_cr
4356: FROM xla_events xev
4357: ,xla_ae_headers aeh
4358: ,xla_ae_lines ael
4359: ,gl_period_statuses gps
4360: WHERE xev.request_id = p_request_id
4361: AND xev.application_id = p_application_id

Line 4399: FROM xla_ae_headers aeh

4395: ,ael.party_id
4396: ,ael.party_site_id
4397: ,ael.accounted_dr
4398: ,ael.accounted_cr
4399: FROM xla_ae_headers aeh
4400: ,xla_ae_lines ael
4401: ,gl_period_statuses gps
4402: WHERE aeh.application_id = p_application_id
4403: AND aeh.entity_id = p_entity_id

Line 4540: ,xla_ae_headers aeh

4536: ,ael.accounted_dr
4537: ,ael.accounted_cr
4538: FROM xla_events_gt xeg
4539: ,xla_events xe
4540: ,xla_ae_headers aeh
4541: ,xla_ae_lines ael
4542: ,gl_period_statuses gps
4543: WHERE xeg.application_id = p_application_id
4544: AND aeh.application_id = xeg.application_id

Line 4665: ,xla_ae_headers aeh

4661: ,NVL(ael.party_site_id,-999) party_site_id
4662: ,ael.accounted_dr
4663: ,ael.accounted_cr
4664: FROM xla_events xev
4665: ,xla_ae_headers aeh
4666: ,xla_ae_lines ael
4667: ,gl_period_statuses gps
4668: WHERE xev.request_id = p_request_id
4669: AND xev.application_id = p_application_id

Line 4786: FROM xla_ae_headers aeh

4782: ,ael.party_id
4783: ,NVL(ael.party_site_id,-999) party_site_id
4784: ,ael.accounted_dr
4785: ,ael.accounted_cr
4786: FROM xla_ae_headers aeh
4787: ,xla_ae_lines ael
4788: ,gl_period_statuses gps
4789: WHERE aeh.application_id = p_application_id
4790: AND aeh.entity_id = p_entity_id

Line 6813: FROM xla_ae_headers aeh

6809: ( SELECT xbct.line_rowid
6810: FROM xla_bal_ctrl_lines_gt xbct
6811: )
6812: AND EXISTS (SELECT 1
6813: FROM xla_ae_headers aeh
6814: ,gl_period_statuses gps
6815: WHERE ael.ae_header_id = aeh.ae_header_id
6816: AND aeh.application_id = ael.application_id
6817: AND gps.application_id = 101

Line 6968: FROM xla_ae_headers aeh

6964: ,xbct.ae_line_num
6965: FROM xla_bal_anacri_lines_gt xbct
6966: )
6967: AND EXISTS (SELECT 1
6968: FROM xla_ae_headers aeh
6969: ,gl_period_statuses gps
6970: WHERE ael.ae_header_id = aeh.ae_header_id
6971: AND aeh.application_id = ael.application_id
6972: AND gps.application_id = 101

Line 7999: ,xla_ae_headers xah

7995: )
7996: WHERE ael.ROWID IN
7997: (SELECT xal.ROWID
7998: FROM xla_balance_statuses xbs
7999: ,xla_ae_headers xah
8000: ,xla_ae_lines xal
8001: ,gl_period_statuses gps
8002: WHERE xbs.balance_status_code = 'R'
8003: AND xbs.balance_source_code = 'C'

Line 8058: ,xla_ae_headers xah

8054: )
8055: WHERE ael.ROWID IN
8056: (SELECT xal.ROWID
8057: FROM xla_balance_statuses xbs
8058: ,xla_ae_headers xah
8059: ,xla_ae_lines xal
8060: ,gl_period_statuses gps
8061: WHERE xbs.balance_status_code = 'R'
8062: AND xbs.balance_source_code = 'A'

Line 8544: FROM xla_ae_headers xah

8540: IF p_party_type_code IS NOT NULL
8541: THEN
8542: l_party_clause :=
8543: 'AND EXISTS (SELECT 1
8544: FROM xla_ae_headers xah
8545: ,xla_ae_lines xal
8546: WHERE xah.application_id = xbs.application_id
8547: AND xah.ledger_id = xbs.ledger_id
8548: AND xal.code_combination_id = xbs.code_combination_id

Line 9684: ,xla_ae_headers xah

9680: WHERE xal.ROWID IN
9681: ( SELECT xal.ROWID
9682: FROM xla_bal_synchronize_gt xbt
9683: ,xla_ae_lines xal
9684: ,xla_ae_headers xah
9685: ,xla_subledgers xsl
9686: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9687: AND xal.code_combination_id = xbt.code_combination_id
9688: AND xah.ae_header_id = xal.ae_header_id

Line 9999: INSERT INTO xla_ae_headers

9995: ,p_level => C_LEVEL_PROCEDURE);
9996: END IF;
9997:
9998: IF p_mode = 'A' THEN
9999: INSERT INTO xla_ae_headers
10000: (
10001: AE_HEADER_ID
10002: ,APPLICATION_ID
10003: ,LEDGER_ID

Line 10097: FROM xla_ae_headers xah

10093: FROM xla_ae_lines xal
10094: WHERE xal.ae_header_id = p_ae_header_id;
10095:
10096: DELETE
10097: FROM xla_ae_headers xah
10098: WHERE xah.ae_header_id = p_ae_header_id;
10099:
10100: ELSE
10101: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN

Line 10294: ,xla_ae_headers xah

10290:
10291: SELECT MIN(gps.effective_period_num)
10292: INTO l_first_entry_eff_period_num
10293: FROM gl_period_statuses gps
10294: ,xla_ae_headers xah
10295: ,xla_ae_lines xal
10296: WHERE gps.ledger_id = p_ledger_id
10297: AND gps.application_id = 101
10298: AND gps.period_name = xah.period_name

Line 10395: SELECT xla_ae_headers_s.nextval

10391: END IF;
10392:
10393: END IF;
10394:
10395: SELECT xla_ae_headers_s.nextval
10396: INTO l_ae_header_id
10397: FROM DUAL;
10398:
10399: --Create fake entries