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