DBA Data[Home] [Help]

APPS.FARX_AD dependencies on FA_DEPRN_SUMMARY

Line 674: FA_DEPRN_SUMMARY DS,

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

Line 733: fa_deprn_summary ds,

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

Line 785: FA_DEPRN_SUMMARY DS,

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

Line 837: fa_deprn_summary ds,

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

Line 1374: FA_DEPRN_SUMMARY DS,

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

Line 1466: fa_deprn_summary ds,

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

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 1690: fa_deprn_summary ds,

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

Line 2075: FA_DEPRN_SUMMARY DS,

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

Line 2151: FA_DEPRN_SUMMARY DS,

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

Line 2241: FA_DEPRN_SUMMARY DS,

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