DBA Data[Home] [Help]

APPS.FA_INTERCO_PVT dependencies on FA_BOOK_CONTROLS

Line 1487: fa_book_controls bc,

1483: l_statement :=
1484: 'select distinct glcc.' || l_column_name ||
1485: ' from gl_code_combinations glcc,
1486: fa_books bk,
1487: fa_book_controls bc,
1488: fa_distribution_history dh
1489: where bk.asset_id = dh.asset_id
1490: and bk.group_asset_id = :p_asset_id
1491: and bk.book_type_code = bc.book_type_code

Line 1514: fa_book_controls bc,

1510:
1511: l_statement :=
1512: 'select distinct glcc.' || l_column_name ||
1513: ' from gl_code_combinations glcc,
1514: fa_book_controls bc,
1515: fa_distribution_history dh
1516: where dh.asset_id = :p_asset_Id
1517: and dh.date_ineffective is null
1518: and dh.code_combination_id = glcc.code_combination_id

Line 1534: fa_book_controls bc

1530: 'select distinct glcc.' || l_column_name ||
1531: ' from gl_code_combinations glcc,
1532: fa_books bk,
1533: fa_distribution_history dh,
1534: fa_book_controls bc
1535: where dh.asset_id = bk.group_asset_id
1536: and dh.date_ineffective is null
1537: and dh.code_combination_id = glcc.code_combination_id
1538: and bk.asset_id = :p_asset_id