212: FA_METHODS M, /* StatReq */
213: FA_BOOKS B, /* StatReq */
214: FA_BALANCES_REPORT_GT BAL,
215: FA_ADDITIONS AD,
216: GL_CODE_COMBINATIONS DHCC,
217: GL_CODE_COMBINATIONS AJCC,
218: FA_ADDITIONS AD1,
219: FA_LOOKUPS LU
220: WHERE AD.Asset_ID = BAL.Asset_ID
213: FA_BOOKS B, /* StatReq */
214: FA_BALANCES_REPORT_GT BAL,
215: FA_ADDITIONS AD,
216: GL_CODE_COMBINATIONS DHCC,
217: GL_CODE_COMBINATIONS AJCC,
218: FA_ADDITIONS AD1,
219: FA_LOOKUPS LU
220: WHERE AD.Asset_ID = BAL.Asset_ID
221: AND DHCC.Code_Combination_ID = BAL.Distribution_CCID
297: FA_METHODS M, /* StatReq */
298: FA_BOOKS B, /* StatReq */
299: FA_BALANCES_REPORT_GT BAL,
300: FA_ADDITIONS AD,
301: GL_CODE_COMBINATIONS DHCC,
302: GL_CODE_COMBINATIONS AJCC,
303: FA_ADDITIONS AD1, -- This is only used to get Group Asset Number
304: FA_LOOKUPS LU
305: WHERE AD.Asset_ID = BAL.Asset_ID
298: FA_BOOKS B, /* StatReq */
299: FA_BALANCES_REPORT_GT BAL,
300: FA_ADDITIONS AD,
301: GL_CODE_COMBINATIONS DHCC,
302: GL_CODE_COMBINATIONS AJCC,
303: FA_ADDITIONS AD1, -- This is only used to get Group Asset Number
304: FA_LOOKUPS LU
305: WHERE AD.Asset_ID = BAL.Asset_ID
306: AND DHCC.Code_Combination_ID = BAL.Distribution_CCID