DBA Data[Home] [Help]

APPS.FARX_AD dependencies on FA_DEPRN_SUMMARY

Line 675: FA_DEPRN_SUMMARY DS,

671: FROM
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,

Line 734: fa_deprn_summary ds,

730: FA_INVOICE_TRANSACTIONS IT,
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,

Line 786: FA_DEPRN_SUMMARY DS,

782: min_select_statement ||','||
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,

Line 838: fa_deprn_summary ds,

834: gad.asset_number
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,

Line 1375: FA_DEPRN_SUMMARY DS,

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,
1377: FA_DEPRN_DETAIL DD,
1378: fa_adjustments adj
1379:

Line 1467: fa_deprn_summary ds,

1463: ds.bonus_Rate,
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,

Line 1578: FA_DEPRN_SUMMARY DS,

1574: FROM
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,

Line 1688: fa_deprn_summary ds,

1684: ds.bonus_Rate,
1685: cb.category_id, dh.location_id
1686: FROM
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,

Line 2073: FA_DEPRN_SUMMARY DS,

2069: FA_ADDITIONS AD,
2070: FA_ASSET_HISTORY AH,
2071: FA_DISTRIBUTION_HISTORY DH,
2072: FA_BOOKS BOOKS,
2073: FA_DEPRN_SUMMARY DS,
2074: FA_DEPRN_DETAIL DD
2075: --FA_DEPRN_PERIODS DP
2076: WHERE
2077: TH.DATE_EFFECTIVE >= h_period1_pod AND

Line 2149: FA_DEPRN_SUMMARY DS,

2145: FA_ADDITIONS AD,
2146: FA_ASSET_HISTORY AH,
2147: FA_DISTRIBUTION_HISTORY DH,
2148: FA_BOOKS BOOKS,
2149: FA_DEPRN_SUMMARY DS,
2150: FA_ADJUSTMENTS CADJ
2151: --fa_deprn_periods dp
2152: WHERE
2153: TH.DATE_EFFECTIVE >= h_period1_pod AND

Line 2239: FA_DEPRN_SUMMARY DS,

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,
2241: FA_ADJUSTMENTS RADJ
2242: --fa_deprn_periods dp
2243: WHERE