APPS.FII_AR_REVENUE_B_C dependencies on AR_ADJUSTMENTS_ALL

Line 856: ar_adjustments_all adj,

852: to_date(null) REV_BOOKED_DATE,
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,

Line 1779: ar_adjustments_all adj,

1775: SELECT --+ ORDERED USE_NL(ADJ)
1776: 7,
1777: adj.adjustment_id
1778: from ra_customer_trx_all t,
1779: ar_adjustments_all adj,
1780: ( select distinct ledger_id
1781: from fii_slg_assignments slga,
1782: fii_source_ledger_groups fslg
1783: where slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 1815: FROM ar_adjustments_all t,

1811: primary_key1)
1812: SELECT
1813: 7,
1814: t.adjustment_id
1815: FROM ar_adjustments_all t,
1816: ( select distinct ledger_id
1817: from fii_slg_assignments slga,
1818: fii_source_ledger_groups fslg
1819: where slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 3288: FROM ar_adjustments_all adj,

3284: adj.customer_trx_id,
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