[Home] [Help]
671: PO_VENDORS PO_VEND,
672: FA_INVOICE_TRANSACTIONS IT,
673: FA_ASSET_INVOICES AI_IN,
674: FA_DEPRN_SUMMARY DS,
675: FA_ADDITIONS AD,
676: GL_CODE_COMBINATIONS DHCC,
677: FA_DISTRIBUTION_HISTORY DH,
678: FA_LOOKUPS FALU,
679: FA_CATEGORY_BOOKS CB,
683: FA_DEPRN_PERIODS DP1,
684: FA_DEPRN_PERIODS DP,
685: FA_DEPRN_DETAIL DD,
686: FA_CATEGORIES CAT,
687: FA_ADDITIONS_B GAD
688: WHERE ' || where_clause1 || '
689: UNION ALL
690: SELECT DISTINCT
691: DECODE(TH.MASS_REFERENCE_ID,NULL,''Manual Addition'',''Mass Addition''),
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,
739: FA_ASSET_HISTORY AH,
740: FA_TRANSACTION_HEADERS THADD,
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 || '
749: UNION ALL
750: SELECT DISTINCT
751: DECODE(TH.MASS_REFERENCE_ID,NULL,''Manual Addition'',''Mass Addition''),
782: spec_select_statement ||' ,
783: gad.asset_number
784: FROM
785: FA_DEPRN_SUMMARY DS,
786: FA_ADDITIONS AD,
787: GL_CODE_COMBINATIONS DHCC,
788: FA_DISTRIBUTION_HISTORY DH,
789: FA_LOOKUPS FALU,
790: FA_CATEGORY_BOOKS CB,
793: FA_TRANSACTION_HEADERS TH,
794: FA_DEPRN_PERIODS DP,
795: FA_DEPRN_DETAIL DD,
796: fa_categories cat,
797: fa_additions_b GAD
798: WHERE ' || where_clause3 || '
799: UNION ALL
800: SELECT DISTINCT
801: DECODE(TH.MASS_REFERENCE_ID,NULL,''Manual Addition'',''Mass Addition''),
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,
843: FA_ASSET_HISTORY AH,
844: FA_DEPRN_PERIODS DP,
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 ;
850:
851: IF (g_print_debug) THEN
852: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'select_statement:='|| select_statement);
1367: FA_DISTRIBUTION_HISTORY DH,
1368: FA_ASSET_HISTORY AH,
1369: FA_CATEGORY_BOOKS CB,
1370: FA_LOOKUPS FALU,
1371: FA_ADDITIONS AD,
1372: --GL_CODE_COMBINATIONS DHCC,
1373: FA_BOOKS BK,
1374: FA_DEPRN_SUMMARY DS,
1375: FA_TRANSACTION_HEADERS TH,
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,
1473: --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
1695: FA_ASSET_HISTORY AH,
1696: FA_CATEGORY_BOOKS CB,
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
2067: FA_TRANSACTION_HEADERS TH,
2068: PER_ALL_PEOPLE_F EMP,
2069: FA_LOCATIONS LOC,
2070: GL_CODE_COMBINATIONS CC,
2071: FA_ADDITIONS AD,
2072: FA_ASSET_HISTORY AH,
2073: FA_DISTRIBUTION_HISTORY DH,
2074: FA_BOOKS BOOKS,
2075: FA_DEPRN_SUMMARY DS,
2143: FA_TRANSACTION_HEADERS TH,
2144: PER_ALL_PEOPLE_F EMP,
2145: FA_LOCATIONS LOC,
2146: GL_CODE_COMBINATIONS CC,
2147: FA_ADDITIONS AD,
2148: FA_ASSET_HISTORY AH,
2149: FA_DISTRIBUTION_HISTORY DH,
2150: FA_BOOKS BOOKS,
2151: FA_DEPRN_SUMMARY DS,
2234: FA_TRANSACTION_HEADERS TH,
2235: PER_ALL_PEOPLE_F EMP,
2236: FA_LOCATIONS LOC,
2237: GL_CODE_COMBINATIONS CC,
2238: FA_ADDITIONS AD,
2239: FA_ASSET_HISTORY AH,
2240: FA_DISTRIBUTION_HISTORY DH,
2241: FA_DEPRN_SUMMARY DS,
2242: FA_BOOKS BOOKS,