[Home] [Help]
672: PO_VENDORS PO_VEND,
673: FA_INVOICE_TRANSACTIONS IT,
674: FA_ASSET_INVOICES AI_IN,
675: FA_DEPRN_SUMMARY DS,
676: FA_ADDITIONS AD,
677: GL_CODE_COMBINATIONS DHCC,
678: FA_DISTRIBUTION_HISTORY DH,
679: FA_LOOKUPS FALU,
680: FA_CATEGORY_BOOKS CB,
684: /* FA_DEPRN_PERIODS DP1,*/
685: FA_DEPRN_PERIODS DP,
686: FA_DEPRN_DETAIL DD,
687: FA_CATEGORIES CAT,
688: FA_ADDITIONS_B GAD
689: WHERE ' || where_clause1 || '
690: UNION ALL
691: SELECT DISTINCT
692: DECODE(TH.MASS_REFERENCE_ID,NULL,''Manual Addition'',''Mass Addition''),
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,
740: FA_ASSET_HISTORY AH,
741: FA_TRANSACTION_HEADERS THADD,
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 || '
750: UNION ALL
751: SELECT DISTINCT
752: DECODE(TH.MASS_REFERENCE_ID,NULL,''Manual Addition'',''Mass Addition''),
783: spec_select_statement ||' ,
784: gad.asset_number
785: FROM
786: FA_DEPRN_SUMMARY DS,
787: FA_ADDITIONS AD,
788: GL_CODE_COMBINATIONS DHCC,
789: FA_DISTRIBUTION_HISTORY DH,
790: FA_LOOKUPS FALU,
791: FA_CATEGORY_BOOKS CB,
794: FA_TRANSACTION_HEADERS TH,
795: FA_DEPRN_PERIODS DP,
796: FA_DEPRN_DETAIL DD,
797: fa_categories cat,
798: fa_additions_b GAD
799: WHERE ' || where_clause3 || '
800: UNION ALL
801: SELECT DISTINCT
802: DECODE(TH.MASS_REFERENCE_ID,NULL,''Manual Addition'',''Mass Addition''),
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,
844: FA_ASSET_HISTORY AH,
845: FA_DEPRN_PERIODS DP,
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 ;
851:
852: IF (g_print_debug) THEN
853: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'select_statement:='|| select_statement);
1368: FA_DISTRIBUTION_HISTORY DH,
1369: FA_ASSET_HISTORY AH,
1370: FA_CATEGORY_BOOKS CB,
1371: FA_LOOKUPS FALU,
1372: FA_ADDITIONS AD,
1373: --GL_CODE_COMBINATIONS DHCC,
1374: FA_BOOKS BK,
1375: FA_DEPRN_SUMMARY DS,
1376: FA_TRANSACTION_HEADERS TH,
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,
1474: --GL_CODE_COMBINATIONS DHCC,
1581: FA_ASSET_HISTORY AH,
1582: FA_CATEGORY_BOOKS CB,
1583: FA_LOOKUPS FALU,
1584: PO_VENDORS PO_VEND,
1585: FA_ADDITIONS AD,
1586: --GL_CODE_COMBINATIONS DHCC,
1587: FA_DEPRN_DETAIL DD
1588: WHERE
1589: bk.book_type_code = th.book_type_code AND
1693: FA_ASSET_HISTORY AH,
1694: FA_CATEGORY_BOOKS CB,
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
2065: FA_TRANSACTION_HEADERS TH,
2066: PER_ALL_PEOPLE_F EMP,
2067: FA_LOCATIONS LOC,
2068: GL_CODE_COMBINATIONS CC,
2069: FA_ADDITIONS AD,
2070: FA_ASSET_HISTORY AH,
2071: FA_DISTRIBUTION_HISTORY DH,
2072: FA_BOOKS BOOKS,
2073: FA_DEPRN_SUMMARY DS,
2141: FA_TRANSACTION_HEADERS TH,
2142: PER_ALL_PEOPLE_F EMP,
2143: FA_LOCATIONS LOC,
2144: GL_CODE_COMBINATIONS CC,
2145: FA_ADDITIONS AD,
2146: FA_ASSET_HISTORY AH,
2147: FA_DISTRIBUTION_HISTORY DH,
2148: FA_BOOKS BOOKS,
2149: FA_DEPRN_SUMMARY DS,
2232: FA_TRANSACTION_HEADERS TH,
2233: PER_ALL_PEOPLE_F EMP,
2234: FA_LOCATIONS LOC,
2235: GL_CODE_COMBINATIONS CC,
2236: FA_ADDITIONS AD,
2237: FA_ASSET_HISTORY AH,
2238: FA_DISTRIBUTION_HISTORY DH,
2239: FA_DEPRN_SUMMARY DS,
2240: FA_BOOKS BOOKS,