APPS.FII_AR_REVENUE_B_C dependencies on XLA_DISTRIBUTION_LINKS

Line 597: xla_distribution_links lnk

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
600: AND aeh.ae_header_id = fpk.primary_key1
601: AND aeh.application_id = 222

Line 874: xla_distribution_links lnk

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
877: -- AND adj.adjustment_id = fpk.Primary_Key1
878: AND aeh.ae_header_id = fpk.primary_key1

Line 1171: xla_distribution_links lnk,

1167: ra_customer_trx_all ct,
1168: ra_cust_trx_types_all ctt,
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

Line 3297: xla_distribution_links lnk,

3293: where slga.source_ledger_group_id = fslg.source_ledger_group_id
3294: and fslg.usage_code = g_usage_code
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

Line 3354: xla_distribution_links lnk,

3350: where slga.source_ledger_group_id = fslg.source_ledger_group_id
3351: and fslg.usage_code = g_usage_code
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