eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FARX_BL dependencies on FA_ADDITIONS

Line 66: h_asset FA_ADDITIONS.Asset_Number%TYPE; --bug 8432604

62:
63: h_ccid number;
64: h_account FA_BALANCES_REPORT_GT.Category_Books_Account%TYPE; --bug 8432604
65: h_ajccid number;
66: h_asset FA_ADDITIONS.Asset_Number%TYPE; --bug 8432604
67: h_tag_number FA_ADDITIONS.tag_number%TYPE; --bug 8432604
68: h_serial_number FA_ADDITIONS.serial_number%TYPE; --bug 8432604
69: h_inventorial FA_ADDITIONS.inventorial%TYPE; --bug 8432604
70: h_description FA_ADDITIONS.description%TYPE; --bug 8432604

Line 67: h_tag_number FA_ADDITIONS.tag_number%TYPE; --bug 8432604

63: h_ccid number;
64: h_account FA_BALANCES_REPORT_GT.Category_Books_Account%TYPE; --bug 8432604
65: h_ajccid number;
66: h_asset FA_ADDITIONS.Asset_Number%TYPE; --bug 8432604
67: h_tag_number FA_ADDITIONS.tag_number%TYPE; --bug 8432604
68: h_serial_number FA_ADDITIONS.serial_number%TYPE; --bug 8432604
69: h_inventorial FA_ADDITIONS.inventorial%TYPE; --bug 8432604
70: h_description FA_ADDITIONS.description%TYPE; --bug 8432604
71: h_begin number;

Line 68: h_serial_number FA_ADDITIONS.serial_number%TYPE; --bug 8432604

64: h_account FA_BALANCES_REPORT_GT.Category_Books_Account%TYPE; --bug 8432604
65: h_ajccid number;
66: h_asset FA_ADDITIONS.Asset_Number%TYPE; --bug 8432604
67: h_tag_number FA_ADDITIONS.tag_number%TYPE; --bug 8432604
68: h_serial_number FA_ADDITIONS.serial_number%TYPE; --bug 8432604
69: h_inventorial FA_ADDITIONS.inventorial%TYPE; --bug 8432604
70: h_description FA_ADDITIONS.description%TYPE; --bug 8432604
71: h_begin number;
72: h_end number;

Line 69: h_inventorial FA_ADDITIONS.inventorial%TYPE; --bug 8432604

65: h_ajccid number;
66: h_asset FA_ADDITIONS.Asset_Number%TYPE; --bug 8432604
67: h_tag_number FA_ADDITIONS.tag_number%TYPE; --bug 8432604
68: h_serial_number FA_ADDITIONS.serial_number%TYPE; --bug 8432604
69: h_inventorial FA_ADDITIONS.inventorial%TYPE; --bug 8432604
70: h_description FA_ADDITIONS.description%TYPE; --bug 8432604
71: h_begin number;
72: h_end number;
73: h_addition number;

Line 70: h_description FA_ADDITIONS.description%TYPE; --bug 8432604

66: h_asset FA_ADDITIONS.Asset_Number%TYPE; --bug 8432604
67: h_tag_number FA_ADDITIONS.tag_number%TYPE; --bug 8432604
68: h_serial_number FA_ADDITIONS.serial_number%TYPE; --bug 8432604
69: h_inventorial FA_ADDITIONS.inventorial%TYPE; --bug 8432604
70: h_description FA_ADDITIONS.description%TYPE; --bug 8432604
71: h_begin number;
72: h_end number;
73: h_addition number;
74: h_adjustment number;

Line 122: h_asset_id FA_ADDITIONS.asset_id%TYPE; /* StatReq */

118:
119: h_key_segs fa_rx_shared_pkg.Seg_Array; /* StatReq */
120: h_cat_segs fa_rx_shared_pkg.Seg_Array; /* StatReq */
121:
122: h_asset_id FA_ADDITIONS.asset_id%TYPE; /* StatReq */
123: h_stl_depreciation_rate NUMBER; /* StatReq */
124: h_date_placed_in_service DATE; /* StatReq */
125: h_life_in_months NUMBER; /* StatReq */
126: h_account_description VARCHAR2(500); /* StatReq */

Line 223: FA_ADDITIONS AD,

219: fa_category_books cb,
220: FA_METHODS M, /* StatReq */
221: FA_BOOKS B, /* StatReq */
222: FA_BALANCES_REPORT_GT BAL,
223: FA_ADDITIONS AD,
224: GL_CODE_COMBINATIONS DHCC,
225: GL_CODE_COMBINATIONS AJCC,
226: FA_ADDITIONS AD1,
227: FA_LOOKUPS LU

Line 226: FA_ADDITIONS AD1,

222: FA_BALANCES_REPORT_GT BAL,
223: FA_ADDITIONS AD,
224: GL_CODE_COMBINATIONS DHCC,
225: GL_CODE_COMBINATIONS AJCC,
226: FA_ADDITIONS AD1,
227: FA_LOOKUPS LU
228: WHERE AD.Asset_ID = BAL.Asset_ID
229: AND DHCC.Code_Combination_ID = BAL.Distribution_CCID
230: AND AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID

Line 334: FA_ADDITIONS AD,

330: fa_category_books cb,
331: FA_METHODS M, /* StatReq */
332: FA_MC_BOOKS B, /* StatReq */
333: FA_BALANCES_REPORT_GT BAL,
334: FA_ADDITIONS AD,
335: GL_CODE_COMBINATIONS DHCC,
336: GL_CODE_COMBINATIONS AJCC,
337: FA_ADDITIONS AD1,
338: FA_LOOKUPS LU

Line 337: FA_ADDITIONS AD1,

333: FA_BALANCES_REPORT_GT BAL,
334: FA_ADDITIONS AD,
335: GL_CODE_COMBINATIONS DHCC,
336: GL_CODE_COMBINATIONS AJCC,
337: FA_ADDITIONS AD1,
338: FA_LOOKUPS LU
339: WHERE AD.Asset_ID = BAL.Asset_ID
340: AND DHCC.Code_Combination_ID = BAL.Distribution_CCID
341: AND AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID

Line 447: FA_ADDITIONS AD,

443: FA_ASSET_HISTORY AH, /* StatReq */
444: FA_METHODS M, /* StatReq */
445: FA_BOOKS B, /* StatReq */
446: FA_BALANCES_REPORT_GT BAL,
447: FA_ADDITIONS AD,
448: GL_CODE_COMBINATIONS DHCC,
449: GL_CODE_COMBINATIONS AJCC,
450: FA_ADDITIONS AD1, -- This is only used to get Group Asset Number
451: FA_LOOKUPS LU,

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

446: FA_BALANCES_REPORT_GT BAL,
447: FA_ADDITIONS AD,
448: GL_CODE_COMBINATIONS DHCC,
449: GL_CODE_COMBINATIONS AJCC,
450: FA_ADDITIONS AD1, -- This is only used to get Group Asset Number
451: FA_LOOKUPS LU,
452: FA_BOOKS BKG
453: WHERE AD.Asset_ID = BAL.Asset_ID
454: AND DHCC.Code_Combination_ID = BAL.Distribution_CCID

Line 533: FA_ADDITIONS AD,

529: FA_ASSET_HISTORY AH, /* StatReq */
530: FA_METHODS M, /* StatReq */
531: FA_MC_BOOKS B, /* StatReq */
532: FA_BALANCES_REPORT_GT BAL,
533: FA_ADDITIONS AD,
534: GL_CODE_COMBINATIONS DHCC,
535: GL_CODE_COMBINATIONS AJCC,
536: FA_ADDITIONS AD1, -- This is only used to get Group Asset Number
537: FA_LOOKUPS LU,

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

532: FA_BALANCES_REPORT_GT BAL,
533: FA_ADDITIONS AD,
534: GL_CODE_COMBINATIONS DHCC,
535: GL_CODE_COMBINATIONS AJCC,
536: FA_ADDITIONS AD1, -- This is only used to get Group Asset Number
537: FA_LOOKUPS LU,
538: FA_MC_BOOKS BKG
539: WHERE AD.Asset_ID = BAL.Asset_ID
540: AND DHCC.Code_Combination_ID = BAL.Distribution_CCID

Line 2139: from fa_additions

2135: close GROUP_RESERVE_AMOUNTS;
2136:
2137: select distinct asset_number
2138: into h_group_asset
2139: from fa_additions
2140: where asset_id=group_asset.group_asset_id;
2141:
2142: Update fa_balances_rep_itf
2143: set cost_begin_balance = h_cost_begin_balance

Line 2416: from fa_additions

2412: close GROUP_COST_AMOUNTS;
2413:
2414: select distinct asset_number
2415: into h_group_asset
2416: from fa_additions
2417: where asset_id=group_asset.group_asset_id;
2418:
2419: Update fa_balances_rep_itf
2420: set cost_begin_balance = h_cost_begin_balance,