APPS.FII_AR_REVENUE_B_C dependencies on AR_DISTRIBUTIONS_ALL

Line 857: ar_distributions_all ad,

853: null CHILD_ORDER_LINE_ID
854: FROM
855: fii_ar_revenue_id fpk,
856: ar_adjustments_all adj,
857: ar_distributions_all ad,
858: gl_code_combinations gcc,
859: fii_gl_ccid_dimensions ccdim,
860: fii_slg_assignments slga,
861: fii_source_ledger_groups fslg,

Line 887: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

883: AND aeh.ae_header_id = ael.ae_header_id
884: AND lnk.application_id = 222
885: AND ael.ae_header_id = lnk.ae_header_id
886: AND ael.ae_line_num = lnk.ae_line_num
887: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
888: AND lnk.source_distribution_id_num_1 = ad.line_id
889: AND aeh.ledger_id = adj.set_of_books_id
890: AND NVL(adj.status, 'A') = 'A'
891: AND NVL(adj.postable,'Y') = 'Y'

Line 3289: ar_distributions_all ad,

3285: ael.code_combination_id,
3286: 'Y' POSTED_FLAG,
3287: AC.Fin_Cat_Type_Code
3288: FROM ar_adjustments_all adj,
3289: ar_distributions_all ad,
3290: (
3291: select /*+ no_merge use_hash(slga,fslg) */ distinct ledger_id
3292: from fii_slg_assignments slga, fii_source_ledger_groups fslg
3293: where slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 3316: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

3312: AND aeh.ae_header_id = ael.ae_header_id
3313: AND lnk.application_id = 222
3314: AND ael.ae_header_id = lnk.ae_header_id
3315: AND ael.ae_line_num = lnk.ae_line_num
3316: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
3317: AND lnk.source_distribution_id_num_1 = ad.line_id
3318: AND aeh.ledger_id = adj.set_of_books_id
3319: AND ael.accounting_class_code = AC.Accounting_Class_Code
3320: AND ( aeh.ledger_id = AC.Ledger_ID OR AC.Ledger_ID IS NULL )