[Home] [Help]
679: FA_LOOKUPS FALU,
680: FA_CATEGORY_BOOKS CB,
681: FA_ASSET_HISTORY AH,
682: FA_BOOKS BK,
683: FA_TRANSACTION_HEADERS TH,
684: /* FA_DEPRN_PERIODS DP1,*/
685: FA_DEPRN_PERIODS DP,
686: FA_DEPRN_DETAIL DD,
687: FA_CATEGORIES CAT,
731: FA_ASSET_INVOICES AI_IN,
732: FA_DISTRIBUTION_HISTORY DH,
733: GL_CODE_COMBINATIONS DHCC,
734: fa_deprn_summary ds,
735: FA_TRANSACTION_HEADERS THDIS,
736: fa_books bk,
737: FA_ADDITIONS AD,
738: FA_CATEGORY_BOOKS CB,
739: FA_LOOKUPS FALU,
737: FA_ADDITIONS AD,
738: FA_CATEGORY_BOOKS CB,
739: FA_LOOKUPS FALU,
740: FA_ASSET_HISTORY AH,
741: FA_TRANSACTION_HEADERS THADD,
742: FA_DEPRN_PERIODS DP2,
743: FA_DEPRN_PERIODS DP1,
744: FA_DEPRN_PERIODS DP,
745: FA_TRANSACTION_HEADERS TH,
741: FA_TRANSACTION_HEADERS THADD,
742: FA_DEPRN_PERIODS DP2,
743: FA_DEPRN_PERIODS DP1,
744: FA_DEPRN_PERIODS DP,
745: FA_TRANSACTION_HEADERS TH,
746: fa_deprn_detail dd,
747: fa_categories cat,
748: fa_additions_b GAD
749: WHERE ' || where_clause2 || '
790: FA_LOOKUPS FALU,
791: FA_CATEGORY_BOOKS CB,
792: FA_ASSET_HISTORY AH,
793: FA_BOOKS BK,
794: FA_TRANSACTION_HEADERS TH,
795: FA_DEPRN_PERIODS DP,
796: FA_DEPRN_DETAIL DD,
797: fa_categories cat,
798: fa_additions_b GAD
835: FROM
836: FA_DISTRIBUTION_HISTORY DH,
837: GL_CODE_COMBINATIONS DHCC,
838: fa_deprn_summary ds,
839: FA_TRANSACTION_HEADERS THDIS,
840: fa_books bk,
841: FA_ADDITIONS AD,
842: FA_CATEGORY_BOOKS CB,
843: FA_LOOKUPS FALU,
842: FA_CATEGORY_BOOKS CB,
843: FA_LOOKUPS FALU,
844: FA_ASSET_HISTORY AH,
845: FA_DEPRN_PERIODS DP,
846: FA_TRANSACTION_HEADERS TH,
847: fa_deprn_detail dd,
848: fa_categories cat,
849: FA_ADDITIONS_B GAD
850: WHERE ' || where_clause4 ;
1372: FA_ADDITIONS AD,
1373: --GL_CODE_COMBINATIONS DHCC,
1374: FA_BOOKS BK,
1375: FA_DEPRN_SUMMARY DS,
1376: FA_TRANSACTION_HEADERS TH,
1377: FA_DEPRN_DETAIL DD,
1378: fa_adjustments adj
1379:
1380: WHERE
1464: cb.category_id, dh.location_id
1465: FROM
1466: fa_books bk,
1467: fa_deprn_summary ds,
1468: FA_TRANSACTION_HEADERS TH,
1469: FA_TRANSACTION_HEADERS THDIS,
1470: FA_ADDITIONS AD,
1471: FA_ASSET_HISTORY AH,
1472: FA_CATEGORY_BOOKS CB,
1465: FROM
1466: fa_books bk,
1467: fa_deprn_summary ds,
1468: FA_TRANSACTION_HEADERS TH,
1469: FA_TRANSACTION_HEADERS THDIS,
1470: FA_ADDITIONS AD,
1471: FA_ASSET_HISTORY AH,
1472: FA_CATEGORY_BOOKS CB,
1473: FA_DISTRIBUTION_HISTORY DH,
1575: FA_ASSET_INVOICES AI_IN,
1576: FA_INVOICE_TRANSACTIONS IT,
1577: FA_BOOKS BK,
1578: FA_DEPRN_SUMMARY DS,
1579: FA_TRANSACTION_HEADERS TH,
1580: FA_DISTRIBUTION_HISTORY DH,
1581: FA_ASSET_HISTORY AH,
1582: FA_CATEGORY_BOOKS CB,
1583: FA_LOOKUPS FALU,
1687: fa_books bk,
1688: fa_deprn_summary ds,
1689: FA_ASSET_INVOICES AI_IN,
1690: FA_INVOICE_TRANSACTIONS IT,
1691: FA_TRANSACTION_HEADERS THDIS,
1692: FA_DISTRIBUTION_HISTORY DH,
1693: FA_ASSET_HISTORY AH,
1694: FA_CATEGORY_BOOKS CB,
1695: FA_LOOKUPS FALU,
1695: FA_LOOKUPS FALU,
1696: PO_VENDORS PO_VEND,
1697: FA_ADDITIONS AD,
1698: --GL_CODE_COMBINATIONS DHCC,
1699: FA_TRANSACTION_HEADERS TH,
1700: FA_DEPRN_PERIODS DP
1701: WHERE
1702: DP.BOOK_TYPE_CODE = h_book AND
1703: dp.period_open_date >= bk.date_effective --AND
2061: nvl(DD.DEPRN_RESERVE,0),
2062: NULL,
2063: period --dp.period_name
2064: FROM
2065: FA_TRANSACTION_HEADERS TH,
2066: PER_ALL_PEOPLE_F EMP,
2067: FA_LOCATIONS LOC,
2068: GL_CODE_COMBINATIONS CC,
2069: FA_ADDITIONS AD,
2137: 0 , -- RESERVE,
2138: 'T',
2139: period --dp.period_name
2140: FROM
2141: FA_TRANSACTION_HEADERS TH,
2142: PER_ALL_PEOPLE_F EMP,
2143: FA_LOCATIONS LOC,
2144: GL_CODE_COMBINATIONS CC,
2145: FA_ADDITIONS AD,
2228: DECODE(RADJ.DEBIT_CREDIT_FLAG,'CR',1,'DR',-1)),
2229: 'T',
2230: period --dp.period_name
2231: FROM
2232: FA_TRANSACTION_HEADERS TH,
2233: PER_ALL_PEOPLE_F EMP,
2234: FA_LOCATIONS LOC,
2235: GL_CODE_COMBINATIONS CC,
2236: FA_ADDITIONS AD,