DBA Data[Home] [Help]

APPS.FII_FA_EXP_B_C dependencies on FA_BOOK_CONTROLS

Line 70: fa_book_controls bc,

66: s.name
67: FROM gl_period_statuses ps,
68: gl_ledgers_public_v s,
69: fa_deprn_periods dp,
70: fa_book_controls bc,
71: (SELECT DISTINCT slga.ledger_id
72: FROM fii_slg_assignments slga,
73: fii_source_ledger_groups fslg
74: WHERE slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 1408: fa_book_controls bc

1404: fa_additions_b ad,
1405: fa_asset_history ah,
1406: fii_fa_cat_dimensions cat,
1407: fa_deprn_periods dp,
1408: fa_book_controls bc
1409: where nid.record_id between p_start_range and p_end_range
1410: and nid.event_type_code = 'DEPRECIATION'
1411: and lines.ae_header_id = nid.ae_header_id
1412: and lines.application_id = 140

Line 1538: fa_book_controls bc

1534: fa_additions_b ad,
1535: fa_asset_history ah,
1536: fii_fa_cat_dimensions cat,
1537: fa_deprn_periods dp,
1538: fa_book_controls bc
1539: where nid.record_id between p_start_range and p_end_range
1540: and nid.event_type_code not in ('DEPRECIATION', 'ROLLBACK_DEPRECIATION')
1541: and lines.ae_header_id = nid.ae_header_id
1542: and lines.application_id = 140

Line 1742: fa_book_controls bc

1738: fa_additions_b ad,
1739: fa_asset_history ah,
1740: fii_fa_cat_dimensions cat,
1741: fa_deprn_periods dp,
1742: fa_book_controls bc
1743: where gir.je_header_id = nid.je_header_id
1744: and acls.ledger_id = nid.ledger_id
1745: and lines.application_id = 140
1746: and lines.gl_sl_link_id = gir.gl_sl_link_id

Line 1905: fa_book_controls bc

1901: fa_additions_b ad,
1902: fa_asset_history ah,
1903: fii_fa_cat_dimensions cat,
1904: fa_deprn_periods dp,
1905: fa_book_controls bc
1906: where gir.je_header_id = nid.je_header_id
1907: and acls.ledger_id = nid.ledger_id
1908: and lines.application_id = 140
1909: and lines.gl_sl_link_id = gir.gl_sl_link_id