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_RX_GROUP dependencies on FA_TRANSACTION_HEADERS

Line 298: fa_transaction_headers thg,

294: l_group_rec.recapture_amount
295: FROM fa_retirements ret,
296: fa_book_controls bc,
297: fa_fiscal_year fy,
298: fa_transaction_headers thg,
299: fa_transaction_headers thm
300: WHERE bc.book_type_code = p_book_type_code
301: AND fy.fiscal_year = l_info_rec.fiscal_year
302: AND fy.fiscal_year_name = bc.fiscal_year_name

Line 299: fa_transaction_headers thm

295: FROM fa_retirements ret,
296: fa_book_controls bc,
297: fa_fiscal_year fy,
298: fa_transaction_headers thg,
299: fa_transaction_headers thm
300: WHERE bc.book_type_code = p_book_type_code
301: AND fy.fiscal_year = l_info_rec.fiscal_year
302: AND fy.fiscal_year_name = bc.fiscal_year_name
303: AND thm.book_type_code = bc.book_type_code

Line 336: fa_transaction_headers thg

332: l_second_half_grp_adjustment
333: FROM fa_adjustments adj,
334: fa_book_controls bc,
335: fa_fiscal_year fy,
336: fa_transaction_headers thg
337: WHERE thg.asset_id = l_group_rec.asset_id
338: AND thg.book_type_code = p_book_type_code
339: AND thg.member_transaction_header_id IS NULL
340: AND thg.transaction_header_id = adj.transaction_header_id

Line 371: fa_transaction_headers thg,

367: -- Get group reclass amount
368: SELECT NVL(SUM(bkm.cost), 0) - NVL(SUM(adj.adjustment_amount), 0)
369: INTO l_group_reclass_in
370: FROM fa_adjustments adj,
371: fa_transaction_headers thg,
372: fa_books bkm,
373: (SELECT bk_pre.asset_id,
374: bk_pre.group_asset_id
375: FROM fa_books bk_pre,

Line 409: fa_transaction_headers thg,

405:
406: SELECT NVL(SUM(bkm.cost), 0) - NVL(SUM(adj.adjustment_amount), 0)
407: INTO l_group_reclass_out
408: FROM fa_adjustments adj,
409: fa_transaction_headers thg,
410: fa_books bkm
411: WHERE adj.asset_id = l_group_rec.asset_id
412: AND adj.book_type_code = p_book_type_code
413: AND thg.transaction_header_id = adj.transaction_header_id

Line 993: fa_transaction_headers thm,

989: adjustment_amount
990: FROM fa_adjustments adj,
991: fa_book_controls bc,
992: fa_fiscal_year fy,
993: fa_transaction_headers thm,
994: fa_books bkm
995: WHERE bkm.group_asset_id = ' || p_group_rec.asset_id || '
996: AND adj.asset_id = bkm.asset_id
997: AND bkm.transaction_header_id_in = thm.transaction_header_id

Line 1043: fa_transaction_headers thm,

1039: NVL(SUM(ret.reserve_retired), 0) reserve_retired
1040: FROM fa_retirements ret,
1041: fa_book_controls bc,
1042: fa_fiscal_year fy,
1043: fa_transaction_headers thm,
1044: fa_books bkm
1045: WHERE bkm.group_asset_id = ' || p_group_asset_id || '
1046: AND bc.book_type_code = ''' || p_info_rec.book_type_code || '''
1047: AND fy.fiscal_year = ' || p_info_rec.fiscal_year || '

Line 1328: fa_transaction_headers thg,

1324: BEGIN
1325: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1326: INTO l_group_reclass_out
1327: FROM fa_adjustments adj,
1328: fa_transaction_headers thg,
1329: fa_books bkm
1330: WHERE adj.asset_id = p_group_rec.asset_id
1331: AND adj.book_type_code = p_info_rec.book_type_code
1332: AND thg.transaction_header_id = adj.transaction_header_id

Line 1364: fa_transaction_headers thg,

1360: BEGIN
1361: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1362: INTO l_group_reclass_in
1363: FROM fa_adjustments adj,
1364: fa_transaction_headers thg,
1365: fa_books bkm
1366: WHERE adj.asset_id = p_group_rec.asset_id
1367: AND adj.book_type_code = p_info_rec.book_type_code
1368: AND thg.transaction_header_id = adj.transaction_header_id