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.FA_MASSADD_PREP_ENERGY_PKG dependencies on FA_MASS_ADDITIONS

Line 31: from fa_mass_additions

27: p_log_level_rec => p_log_level_rec);
28: end if;
29: select nvl(sum(fixed_assets_cost), 0)
30: into l_total_cost
31: from fa_mass_additions
32: where split_merged_code = 'MC'
33: and parent_mass_addition_id = px_mass_add_rec.mass_addition_id
34: or mass_addition_id = px_mass_add_rec.mass_addition_id;
35: if (l_total_cost >= 0) then

Line 37: update fa_mass_additions

33: and parent_mass_addition_id = px_mass_add_rec.mass_addition_id
34: or mass_addition_id = px_mass_add_rec.mass_addition_id;
35: if (l_total_cost >= 0) then
36: l_debug_str := 'Cost is positive';
37: update fa_mass_additions
38: set EXPENSE_CODE_COMBINATION_ID = px_mass_add_rec.EXPENSE_CODE_COMBINATION_ID,
39: location_id = px_mass_add_rec.location_id,
40: asset_category_id = px_mass_add_rec.asset_category_id,
41: asset_key_ccid = px_mass_add_rec.asset_key_ccid,

Line 55: update fa_mass_additions

51: l_debug_str,
52: '',
53: p_log_level_rec => p_log_level_rec);
54: end if;
55: update fa_mass_additions
56: set EXPENSE_CODE_COMBINATION_ID = px_mass_add_rec.EXPENSE_CODE_COMBINATION_ID,
57: location_id = px_mass_add_rec.location_id,
58: asset_category_id = px_mass_add_rec.asset_category_id,
59: asset_key_ccid = px_mass_add_rec.asset_key_ccid,

Line 75: update fa_mass_additions

71: l_debug_str,
72: '',
73: p_log_level_rec => p_log_level_rec);
74: end if;
75: update fa_mass_additions
76: set EXPENSE_CODE_COMBINATION_ID = nvl(px_mass_add_rec.EXPENSE_CODE_COMBINATION_ID,
77: EXPENSE_CODE_COMBINATION_ID),
78: location_id = nvl(px_mass_add_rec.location_id,
79: location_id),

Line 119: from fa_mass_additions

115: p_log_level_rec => p_log_level_rec);
116: end if;
117: select nvl(sum(fixed_assets_cost), 0)
118: into l_total_cost
119: from fa_mass_additions
120: where split_merged_code = 'MC'
121: and parent_mass_addition_id = px_mass_add_rec.mass_addition_id
122: and merged_code = 'MC'
123: and posting_status = 'MERGED';

Line 139: update fa_mass_additions

135: l_debug_str,
136: '',
137: p_log_level_rec => p_log_level_rec);
138: end if;
139: update fa_mass_additions
140: set add_to_asset_id = px_mass_add_rec.add_to_asset_id,
141: posting_status = 'POST',
142: queue_name = 'POST',
143: last_update_date = sysdate,

Line 155: update fa_mass_additions

151: l_debug_str,
152: '',
153: p_log_level_rec => p_log_level_rec);
154: end if;
155: update fa_mass_additions
156: set posting_status = 'POST',
157: queue_name = 'POST',
158: last_update_date = sysdate,
159: last_updated_by = FND_GLOBAL.user_id

Line 223: l_asset_type FA_Mass_Additions.Asset_Type%TYPE;

219:
220: l_segment varchar30_tbl;
221: l_category FA_Categories.Category_ID%TYPE;
222: l_key_ccid FA_Asset_Keywords.Code_Combination_ID%TYPE;
223: l_asset_type FA_Mass_Additions.Asset_Type%TYPE;
224:
225: l_mass_addition_id FA_Mass_Additions.Mass_Addition_ID%TYPE;
226: l_invoice_number FA_Mass_Additions.Invoice_Number%TYPE;
227: l_feeder_sys_name FA_Mass_Additions.Feeder_System_Name%TYPE;

Line 225: l_mass_addition_id FA_Mass_Additions.Mass_Addition_ID%TYPE;

221: l_category FA_Categories.Category_ID%TYPE;
222: l_key_ccid FA_Asset_Keywords.Code_Combination_ID%TYPE;
223: l_asset_type FA_Mass_Additions.Asset_Type%TYPE;
224:
225: l_mass_addition_id FA_Mass_Additions.Mass_Addition_ID%TYPE;
226: l_invoice_number FA_Mass_Additions.Invoice_Number%TYPE;
227: l_feeder_sys_name FA_Mass_Additions.Feeder_System_Name%TYPE;
228: l_fixed_assets_cost FA_Mass_Additions.Fixed_Assets_Cost%TYPE;
229: l_description FA_Mass_Additions.Description%TYPE;

Line 226: l_invoice_number FA_Mass_Additions.Invoice_Number%TYPE;

222: l_key_ccid FA_Asset_Keywords.Code_Combination_ID%TYPE;
223: l_asset_type FA_Mass_Additions.Asset_Type%TYPE;
224:
225: l_mass_addition_id FA_Mass_Additions.Mass_Addition_ID%TYPE;
226: l_invoice_number FA_Mass_Additions.Invoice_Number%TYPE;
227: l_feeder_sys_name FA_Mass_Additions.Feeder_System_Name%TYPE;
228: l_fixed_assets_cost FA_Mass_Additions.Fixed_Assets_Cost%TYPE;
229: l_description FA_Mass_Additions.Description%TYPE;
230: l_queue_name FA_Mass_Additions.Queue_Name%TYPE;

Line 227: l_feeder_sys_name FA_Mass_Additions.Feeder_System_Name%TYPE;

223: l_asset_type FA_Mass_Additions.Asset_Type%TYPE;
224:
225: l_mass_addition_id FA_Mass_Additions.Mass_Addition_ID%TYPE;
226: l_invoice_number FA_Mass_Additions.Invoice_Number%TYPE;
227: l_feeder_sys_name FA_Mass_Additions.Feeder_System_Name%TYPE;
228: l_fixed_assets_cost FA_Mass_Additions.Fixed_Assets_Cost%TYPE;
229: l_description FA_Mass_Additions.Description%TYPE;
230: l_queue_name FA_Mass_Additions.Queue_Name%TYPE;
231: l_asset_Key_segment1 FA_Mass_Additions.Asset_Key_segment1%TYPE;

Line 228: l_fixed_assets_cost FA_Mass_Additions.Fixed_Assets_Cost%TYPE;

224:
225: l_mass_addition_id FA_Mass_Additions.Mass_Addition_ID%TYPE;
226: l_invoice_number FA_Mass_Additions.Invoice_Number%TYPE;
227: l_feeder_sys_name FA_Mass_Additions.Feeder_System_Name%TYPE;
228: l_fixed_assets_cost FA_Mass_Additions.Fixed_Assets_Cost%TYPE;
229: l_description FA_Mass_Additions.Description%TYPE;
230: l_queue_name FA_Mass_Additions.Queue_Name%TYPE;
231: l_asset_Key_segment1 FA_Mass_Additions.Asset_Key_segment1%TYPE;
232: l_asset_Key_segment2 FA_Mass_Additions.Asset_Key_segment2%TYPE;

Line 229: l_description FA_Mass_Additions.Description%TYPE;

225: l_mass_addition_id FA_Mass_Additions.Mass_Addition_ID%TYPE;
226: l_invoice_number FA_Mass_Additions.Invoice_Number%TYPE;
227: l_feeder_sys_name FA_Mass_Additions.Feeder_System_Name%TYPE;
228: l_fixed_assets_cost FA_Mass_Additions.Fixed_Assets_Cost%TYPE;
229: l_description FA_Mass_Additions.Description%TYPE;
230: l_queue_name FA_Mass_Additions.Queue_Name%TYPE;
231: l_asset_Key_segment1 FA_Mass_Additions.Asset_Key_segment1%TYPE;
232: l_asset_Key_segment2 FA_Mass_Additions.Asset_Key_segment2%TYPE;
233: l_asset_Key_segment3 FA_Mass_Additions.Asset_Key_segment3%TYPE;

Line 230: l_queue_name FA_Mass_Additions.Queue_Name%TYPE;

226: l_invoice_number FA_Mass_Additions.Invoice_Number%TYPE;
227: l_feeder_sys_name FA_Mass_Additions.Feeder_System_Name%TYPE;
228: l_fixed_assets_cost FA_Mass_Additions.Fixed_Assets_Cost%TYPE;
229: l_description FA_Mass_Additions.Description%TYPE;
230: l_queue_name FA_Mass_Additions.Queue_Name%TYPE;
231: l_asset_Key_segment1 FA_Mass_Additions.Asset_Key_segment1%TYPE;
232: l_asset_Key_segment2 FA_Mass_Additions.Asset_Key_segment2%TYPE;
233: l_asset_Key_segment3 FA_Mass_Additions.Asset_Key_segment3%TYPE;
234: l_asset_Key_segment4 FA_Mass_Additions.Asset_Key_segment4%TYPE;

Line 231: l_asset_Key_segment1 FA_Mass_Additions.Asset_Key_segment1%TYPE;

227: l_feeder_sys_name FA_Mass_Additions.Feeder_System_Name%TYPE;
228: l_fixed_assets_cost FA_Mass_Additions.Fixed_Assets_Cost%TYPE;
229: l_description FA_Mass_Additions.Description%TYPE;
230: l_queue_name FA_Mass_Additions.Queue_Name%TYPE;
231: l_asset_Key_segment1 FA_Mass_Additions.Asset_Key_segment1%TYPE;
232: l_asset_Key_segment2 FA_Mass_Additions.Asset_Key_segment2%TYPE;
233: l_asset_Key_segment3 FA_Mass_Additions.Asset_Key_segment3%TYPE;
234: l_asset_Key_segment4 FA_Mass_Additions.Asset_Key_segment4%TYPE;
235: l_asset_Key_segment5 FA_Mass_Additions.Asset_Key_segment5%TYPE;

Line 232: l_asset_Key_segment2 FA_Mass_Additions.Asset_Key_segment2%TYPE;

228: l_fixed_assets_cost FA_Mass_Additions.Fixed_Assets_Cost%TYPE;
229: l_description FA_Mass_Additions.Description%TYPE;
230: l_queue_name FA_Mass_Additions.Queue_Name%TYPE;
231: l_asset_Key_segment1 FA_Mass_Additions.Asset_Key_segment1%TYPE;
232: l_asset_Key_segment2 FA_Mass_Additions.Asset_Key_segment2%TYPE;
233: l_asset_Key_segment3 FA_Mass_Additions.Asset_Key_segment3%TYPE;
234: l_asset_Key_segment4 FA_Mass_Additions.Asset_Key_segment4%TYPE;
235: l_asset_Key_segment5 FA_Mass_Additions.Asset_Key_segment5%TYPE;
236: l_asset_Key_segment6 FA_Mass_Additions.Asset_Key_segment6%TYPE;

Line 233: l_asset_Key_segment3 FA_Mass_Additions.Asset_Key_segment3%TYPE;

229: l_description FA_Mass_Additions.Description%TYPE;
230: l_queue_name FA_Mass_Additions.Queue_Name%TYPE;
231: l_asset_Key_segment1 FA_Mass_Additions.Asset_Key_segment1%TYPE;
232: l_asset_Key_segment2 FA_Mass_Additions.Asset_Key_segment2%TYPE;
233: l_asset_Key_segment3 FA_Mass_Additions.Asset_Key_segment3%TYPE;
234: l_asset_Key_segment4 FA_Mass_Additions.Asset_Key_segment4%TYPE;
235: l_asset_Key_segment5 FA_Mass_Additions.Asset_Key_segment5%TYPE;
236: l_asset_Key_segment6 FA_Mass_Additions.Asset_Key_segment6%TYPE;
237: l_asset_Key_segment7 FA_Mass_Additions.Asset_Key_segment7%TYPE;

Line 234: l_asset_Key_segment4 FA_Mass_Additions.Asset_Key_segment4%TYPE;

230: l_queue_name FA_Mass_Additions.Queue_Name%TYPE;
231: l_asset_Key_segment1 FA_Mass_Additions.Asset_Key_segment1%TYPE;
232: l_asset_Key_segment2 FA_Mass_Additions.Asset_Key_segment2%TYPE;
233: l_asset_Key_segment3 FA_Mass_Additions.Asset_Key_segment3%TYPE;
234: l_asset_Key_segment4 FA_Mass_Additions.Asset_Key_segment4%TYPE;
235: l_asset_Key_segment5 FA_Mass_Additions.Asset_Key_segment5%TYPE;
236: l_asset_Key_segment6 FA_Mass_Additions.Asset_Key_segment6%TYPE;
237: l_asset_Key_segment7 FA_Mass_Additions.Asset_Key_segment7%TYPE;
238: l_asset_Key_segment8 FA_Mass_Additions.Asset_Key_segment8%TYPE;

Line 235: l_asset_Key_segment5 FA_Mass_Additions.Asset_Key_segment5%TYPE;

231: l_asset_Key_segment1 FA_Mass_Additions.Asset_Key_segment1%TYPE;
232: l_asset_Key_segment2 FA_Mass_Additions.Asset_Key_segment2%TYPE;
233: l_asset_Key_segment3 FA_Mass_Additions.Asset_Key_segment3%TYPE;
234: l_asset_Key_segment4 FA_Mass_Additions.Asset_Key_segment4%TYPE;
235: l_asset_Key_segment5 FA_Mass_Additions.Asset_Key_segment5%TYPE;
236: l_asset_Key_segment6 FA_Mass_Additions.Asset_Key_segment6%TYPE;
237: l_asset_Key_segment7 FA_Mass_Additions.Asset_Key_segment7%TYPE;
238: l_asset_Key_segment8 FA_Mass_Additions.Asset_Key_segment8%TYPE;
239: l_asset_Key_segment9 FA_Mass_Additions.Asset_Key_segment9%TYPE;

Line 236: l_asset_Key_segment6 FA_Mass_Additions.Asset_Key_segment6%TYPE;

232: l_asset_Key_segment2 FA_Mass_Additions.Asset_Key_segment2%TYPE;
233: l_asset_Key_segment3 FA_Mass_Additions.Asset_Key_segment3%TYPE;
234: l_asset_Key_segment4 FA_Mass_Additions.Asset_Key_segment4%TYPE;
235: l_asset_Key_segment5 FA_Mass_Additions.Asset_Key_segment5%TYPE;
236: l_asset_Key_segment6 FA_Mass_Additions.Asset_Key_segment6%TYPE;
237: l_asset_Key_segment7 FA_Mass_Additions.Asset_Key_segment7%TYPE;
238: l_asset_Key_segment8 FA_Mass_Additions.Asset_Key_segment8%TYPE;
239: l_asset_Key_segment9 FA_Mass_Additions.Asset_Key_segment9%TYPE;
240: l_asset_Key_segment10 FA_Mass_Additions.Asset_Key_segment10%TYPE;

Line 237: l_asset_Key_segment7 FA_Mass_Additions.Asset_Key_segment7%TYPE;

233: l_asset_Key_segment3 FA_Mass_Additions.Asset_Key_segment3%TYPE;
234: l_asset_Key_segment4 FA_Mass_Additions.Asset_Key_segment4%TYPE;
235: l_asset_Key_segment5 FA_Mass_Additions.Asset_Key_segment5%TYPE;
236: l_asset_Key_segment6 FA_Mass_Additions.Asset_Key_segment6%TYPE;
237: l_asset_Key_segment7 FA_Mass_Additions.Asset_Key_segment7%TYPE;
238: l_asset_Key_segment8 FA_Mass_Additions.Asset_Key_segment8%TYPE;
239: l_asset_Key_segment9 FA_Mass_Additions.Asset_Key_segment9%TYPE;
240: l_asset_Key_segment10 FA_Mass_Additions.Asset_Key_segment10%TYPE;
241: l_payables_ccid FA_Mass_Additions.Payables_Code_Combination_ID%TYPE;

Line 238: l_asset_Key_segment8 FA_Mass_Additions.Asset_Key_segment8%TYPE;

234: l_asset_Key_segment4 FA_Mass_Additions.Asset_Key_segment4%TYPE;
235: l_asset_Key_segment5 FA_Mass_Additions.Asset_Key_segment5%TYPE;
236: l_asset_Key_segment6 FA_Mass_Additions.Asset_Key_segment6%TYPE;
237: l_asset_Key_segment7 FA_Mass_Additions.Asset_Key_segment7%TYPE;
238: l_asset_Key_segment8 FA_Mass_Additions.Asset_Key_segment8%TYPE;
239: l_asset_Key_segment9 FA_Mass_Additions.Asset_Key_segment9%TYPE;
240: l_asset_Key_segment10 FA_Mass_Additions.Asset_Key_segment10%TYPE;
241: l_payables_ccid FA_Mass_Additions.Payables_Code_Combination_ID%TYPE;
242: l_dist_ccid NUMBER;

Line 239: l_asset_Key_segment9 FA_Mass_Additions.Asset_Key_segment9%TYPE;

235: l_asset_Key_segment5 FA_Mass_Additions.Asset_Key_segment5%TYPE;
236: l_asset_Key_segment6 FA_Mass_Additions.Asset_Key_segment6%TYPE;
237: l_asset_Key_segment7 FA_Mass_Additions.Asset_Key_segment7%TYPE;
238: l_asset_Key_segment8 FA_Mass_Additions.Asset_Key_segment8%TYPE;
239: l_asset_Key_segment9 FA_Mass_Additions.Asset_Key_segment9%TYPE;
240: l_asset_Key_segment10 FA_Mass_Additions.Asset_Key_segment10%TYPE;
241: l_payables_ccid FA_Mass_Additions.Payables_Code_Combination_ID%TYPE;
242: l_dist_ccid NUMBER;
243: l_dist_line_num NUMBER;

Line 240: l_asset_Key_segment10 FA_Mass_Additions.Asset_Key_segment10%TYPE;

236: l_asset_Key_segment6 FA_Mass_Additions.Asset_Key_segment6%TYPE;
237: l_asset_Key_segment7 FA_Mass_Additions.Asset_Key_segment7%TYPE;
238: l_asset_Key_segment8 FA_Mass_Additions.Asset_Key_segment8%TYPE;
239: l_asset_Key_segment9 FA_Mass_Additions.Asset_Key_segment9%TYPE;
240: l_asset_Key_segment10 FA_Mass_Additions.Asset_Key_segment10%TYPE;
241: l_payables_ccid FA_Mass_Additions.Payables_Code_Combination_ID%TYPE;
242: l_dist_ccid NUMBER;
243: l_dist_line_num NUMBER;
244: l_mass_add_rec Fa_Mass_Additions%ROWTYPE;

Line 241: l_payables_ccid FA_Mass_Additions.Payables_Code_Combination_ID%TYPE;

237: l_asset_Key_segment7 FA_Mass_Additions.Asset_Key_segment7%TYPE;
238: l_asset_Key_segment8 FA_Mass_Additions.Asset_Key_segment8%TYPE;
239: l_asset_Key_segment9 FA_Mass_Additions.Asset_Key_segment9%TYPE;
240: l_asset_Key_segment10 FA_Mass_Additions.Asset_Key_segment10%TYPE;
241: l_payables_ccid FA_Mass_Additions.Payables_Code_Combination_ID%TYPE;
242: l_dist_ccid NUMBER;
243: l_dist_line_num NUMBER;
244: l_mass_add_rec Fa_Mass_Additions%ROWTYPE;
245:

Line 244: l_mass_add_rec Fa_Mass_Additions%ROWTYPE;

240: l_asset_Key_segment10 FA_Mass_Additions.Asset_Key_segment10%TYPE;
241: l_payables_ccid FA_Mass_Additions.Payables_Code_Combination_ID%TYPE;
242: l_dist_ccid NUMBER;
243: l_dist_line_num NUMBER;
244: l_mass_add_rec Fa_Mass_Additions%ROWTYPE;
245:
246: l_cur_status number;
247: l_debug_str varchar2(1000);
248: l_plsql_block VARCHAR2(500);

Line 281: ',FA_Mass_Additions FA where ' || l_where ||

277: l_from,
278: l_where);*/
279: l_query := 'select ' || l_select || ',Payables_Code_Combination_ID
280: from ' || l_from ||
281: ',FA_Mass_Additions FA where ' || l_where ||
282: ' AND TRANS.Invoice_ID= FA.Invoice_ID
283: AND TRANS.Distribution_Line_Number=FA.AP_Distribution_Line_Number
284: AND Posting_Status IN (''NEW'',''ON HOLD'')
285: AND book_type_code=:px_mass_add_rec.book_type_code

Line 305: ',FA_Mass_Additions FA where ' || l_where ||

301: ,Feeder_System_Name ,Fixed_Assets_Cost
302: ,FA.Description Description ,Queue_Name ' ||
303: l_select || ',Payables_Code_Combination_ID
304: from ' || l_from ||
305: ',FA_Mass_Additions FA where ' || l_where ||
306: 'AND TRANS.Je_Header_ID = FA.Je_Header_ID
307: AND TRANS.Je_Line_Num = FA.Je_Line_Num
308: AND book_type_code = :px_mass_add_rec.book_type_code
309: AND Posting_Status IN (''NEW'',''ON HOLD'')

Line 334: FROM fa_mass_additions

330: l_akey_segment(7),
331: l_akey_segment(8),
332: l_akey_segment(9),
333: l_akey_segment(10)
334: FROM fa_mass_additions
335: WHERE mass_addition_id = px_mass_add_rec.mass_addition_id;
336:
337: BEGIN
338: l_debug_str := 'Get the Asset Key';

Line 1020: FROM fa_mass_additions mass_add

1016: from FA_MASSADD_DISTRIBUTIONS mass_dist
1017: where mass_dist.mass_addition_id =
1018: mass_add.mass_addition_id) as
1019: fa_mass_add_dist_tbl) dists
1020: FROM fa_mass_additions mass_add
1021: where posting_status in ('NEW', 'ON-HOLD', 'POST')
1022: and book_type_code = l_book
1023: and nvl(merged_code, '1') not in ('MC')
1024: and (asset_key_ccid is null or asset_category_id is null);

Line 1108: FROM FA_Mass_Additions

1104: SELECT Mass_Addition_ID,
1105: Asset_Key_CCID,
1106: Asset_Category_ID,
1107: book_type_code
1108: FROM FA_Mass_Additions
1109: WHERE Posting_Status IN ('NEW', 'ON HOLD', 'POST')
1110: AND Asset_Category_ID IS NOT NULL
1111: AND Asset_Key_CCID IS NOT NULL
1112: and book_type_code = l_book_type_code

Line 1121: from fa_mass_additions

1117: decode(posting_status, 'POST', 1, 'NEW', 2, 'ON HOLD', 3);
1118:
1119: cursor child_mass_add(l_mass_add_id number, l_asset_key_ccid number, l_asset_category_id number, l_book_type_code varchar2) is
1120: select mass_addition_id, asset_category_id, asset_key_ccid
1121: from fa_mass_additions
1122: where posting_status in ('NEW', 'ON HOLD', 'POSTED')
1123: and mass_addition_id <> l_mass_add_id
1124: and asset_category_id = l_asset_category_id
1125: and asset_key_ccid = l_asset_key_ccid

Line 1138: update fa_mass_additions

1134: for child_rec in child_mass_add(parent_rec.mass_addition_id,
1135: parent_rec.asset_key_ccid,
1136: parent_rec.asset_category_id,
1137: parent_rec.book_type_code) loop
1138: update fa_mass_additions
1139: set posting_status = 'MERGED',
1140: MERGE_PARENT_MASS_ADDITIONS_ID = parent_rec.mass_addition_id,
1141: merged_code = 'MC',
1142: last_update_date = sysdate,

Line 1149: update fa_mass_additions

1145: where mass_addition_id = child_rec.mass_addition_id;
1146: merged_parent := 1;
1147: end loop;
1148: if (merged_parent = 1) then
1149: update fa_mass_additions
1150: set merged_code = 'MP',
1151: last_update_date = sysdate,
1152: last_updated_by = -1,
1153: last_update_login = -1

Line 1580: update fa_mass_additions

1576: end if;
1577: end if;
1578: end if;
1579:
1580: update fa_mass_additions
1581: set location_id = px_mass_add_rec.location_id,
1582: expense_code_combination_id = px_mass_add_rec.expensE_code_combination_id
1583: where mass_addition_id = px_mass_add_rec.mass_addition_id;
1584: commit;