APPS.FII_AR_REVENUE_B_C dependencies on XLA_AE_HEADERS

Line 595: xla_ae_headers aeh,

591: oe_order_lines_all sl_child,
592: oe_order_lines_all sl_parent,
593: oe_order_headers_all sh,
594: ACCNT_CLASS AC,
595: xla_ae_headers aeh,
596: xla_ae_lines ael,
597: xla_distribution_links lnk
598: WHERE fpk.view_type_id= 4
599: AND fpk.job_num = p_job_num

Line 872: xla_ae_headers aeh,

868: -- oe_order_lines_all sl_parent,
869: gl_ledgers_public_v sob,
870: hz_cust_accounts bill_acct,
871: ACCNT_CLASS AC,
872: xla_ae_headers aeh,
873: xla_ae_lines ael,
874: xla_distribution_links lnk
875: WHERE fpk.view_type_id = 3
876: AND fpk.job_num = p_job_num

Line 1173: xla_ae_headers aeh

1169: ra_cust_trx_line_gl_dist_all ctlgd,
1170: ACCNT_CLASS AC,
1171: xla_distribution_links lnk,
1172: xla_ae_lines ael,
1173: xla_ae_headers aeh
1174: WHERE fpk.view_type_id= 4
1175: AND fpk.job_num = p_job_num
1176: AND ctl.customer_trx_line_id = fpk.primary_key1
1177: AND nvl(ctl.interface_line_context, 'xxx') <> 'PA INVOICES'

Line 1920: SELECT /*+ INDEX(aeh, xla_ae_headers_N5) */

1916:
1917: l_stmt := 'INSERT INTO FII_AR_REVENUE_ID (
1918: view_type_id,
1919: primary_key1)
1920: SELECT /*+ INDEX(aeh, xla_ae_headers_N5) */
1921: dup.view_type_id,
1922: aeh.ae_header_id
1923: FROM xla_ae_headers aeh,
1924: ( select /*+ no_merge */ distinct ledger_id

Line 1923: FROM xla_ae_headers aeh,

1919: primary_key1)
1920: SELECT /*+ INDEX(aeh, xla_ae_headers_N5) */
1921: dup.view_type_id,
1922: aeh.ae_header_id
1923: FROM xla_ae_headers aeh,
1924: ( select /*+ no_merge */ distinct ledger_id
1925: from fii_slg_assignments slga,
1926: fii_source_ledger_groups fslg
1927: where slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 1957: SELECT /*+ INDEX(aeh, xla_ae_headers_N5) */

1953: ELSE
1954: l_stmt := 'INSERT INTO FII_AR_REVENUE_ID (
1955: view_type_id,
1956: primary_key1)
1957: SELECT /*+ INDEX(aeh, xla_ae_headers_N5) */
1958: dup.view_type_id,
1959: aeh.ae_header_id
1960: FROM xla_ae_headers aeh,
1961: ( select distinct ledger_id

Line 1960: FROM xla_ae_headers aeh,

1956: primary_key1)
1957: SELECT /*+ INDEX(aeh, xla_ae_headers_N5) */
1958: dup.view_type_id,
1959: aeh.ae_header_id
1960: FROM xla_ae_headers aeh,
1961: ( select distinct ledger_id
1962: from fii_slg_assignments slga,
1963: fii_source_ledger_groups fslg
1964: where slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 3299: xla_ae_headers aeh

3295: ) lidset,
3296: ACCNT_CLASS AC,
3297: xla_distribution_links lnk,
3298: xla_ae_lines ael,
3299: xla_ae_headers aeh
3300: WHERE aeh.accounting_date BETWEEN g_gl_from_date AND g_gl_to_date
3301: AND adj.gl_date BETWEEN g_gl_from_date AND g_gl_to_date
3302: AND NVL(adj.status, 'A') = 'A'
3303: AND NVL(adj.postable,'Y') = 'Y'

Line 3356: xla_ae_headers aeh

3352: ) lidset,
3353: ACCNT_CLASS AC,
3354: xla_distribution_links lnk,
3355: xla_ae_lines ael,
3356: xla_ae_headers aeh
3357: WHERE aeh.accounting_date BETWEEN g_gl_from_date AND g_gl_to_date
3358: AND ctlgd.gl_date BETWEEN g_gl_from_date AND g_gl_to_date
3359: AND ctlgd.account_set_flag = 'N'
3360: AND NVL(lnk.unrounded_entered_cr,0) - NVL(lnk.unrounded_entered_dr,0) <> 0

Line 4716: FROM xla_ae_headers ) new

4712:
4713: MERGE INTO FII_CHANGE_LOG log
4714: USING ( SELECT 'AR_MAX_GROUP_ID' LOG_ITEM,
4715: to_char( nvl(max(group_id), -1) ) ITEM_VALUE
4716: FROM xla_ae_headers ) new
4717: ON ( new.LOG_ITEM = log.LOG_ITEM )
4718: WHEN MATCHED THEN
4719: UPDATE SET
4720: log.ITEM_VALUE = new.ITEM_VALUE,