DBA Data[Home] [Help]

APPS.FARX_BL dependencies on FA_ADDITIONS

Line 215: FA_ADDITIONS AD,

211: fa_category_books cb,
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

Line 218: FA_ADDITIONS AD1,

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
222: AND AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID

Line 300: FA_ADDITIONS AD,

296: FA_ASSET_HISTORY AH, /* StatReq */
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

Line 303: FA_ADDITIONS AD1, -- This is only used to get Group Asset Number

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
307: AND AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID

Line 1279: from fa_additions

1275: close GROUP_RESERVE_AMOUNTS;
1276:
1277: select distinct asset_number
1278: into h_group_asset
1279: from fa_additions
1280: where asset_id=group_asset.group_asset_id;
1281:
1282: Update fa_balances_rep_itf
1283: set cost_begin_balance = h_cost_begin_balance

Line 1498: from fa_additions

1494: close GROUP_COST_AMOUNTS;
1495:
1496: select distinct asset_number
1497: into h_group_asset
1498: from fa_additions
1499: where asset_id=group_asset.group_asset_id;
1500:
1501: Update fa_balances_rep_itf
1502: set cost_begin_balance = h_cost_begin_balance,