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

Line 1564: FA_TRANSACTION_HEADERS TH

1560: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK2.REDUCTION_RATE,0)) net_proceeds_to_reduce
1561: from FA_BOOKS BK1,
1562: FA_BOOKS BK2,
1563: FA_RETIREMENTS RET,
1564: FA_TRANSACTION_HEADERS TH
1565: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1566: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1567: and TH.TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)
1568: and RET.STATUS(+) = 'PROCESSED' --bug#15897249

Line 1585: FA_TRANSACTION_HEADERS TH

1581: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1582: from FA_BOOKS BK1,
1583: FA_BOOKS BK2,
1584: FA_RETIREMENTS RET,
1585: FA_TRANSACTION_HEADERS TH
1586: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1587: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1588: and TH.TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)
1589: and BK2.ASSET_ID= p_asset_id

Line 1612: FA_TRANSACTION_HEADERS TH

1608: from FA_BOOKS BK1,
1609: FA_BOOKS BK2,
1610: FA_BOOKS BK3,
1611: FA_RETIREMENTS RET,
1612: FA_TRANSACTION_HEADERS TH
1613: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1614: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1615: and TH.MEMBER_TRANSACTION_HEADER_ID = BK3.TRANSACTION_HEADER_ID_IN
1616: and TH.MEMBER_TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)

Line 1641: FA_TRANSACTION_HEADERS TH

1637: from FA_BOOKS BK1,
1638: FA_BOOKS BK2,
1639: FA_BOOKS BK3,
1640: FA_RETIREMENTS RET,
1641: FA_TRANSACTION_HEADERS TH
1642: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1643: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1644: and TH.MEMBER_TRANSACTION_HEADER_ID = BK3.TRANSACTION_HEADER_ID_IN
1645: and TH.MEMBER_TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)

Line 1678: FA_TRANSACTION_HEADERS TH

1674: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK2.REDUCTION_RATE,0)) net_proceeds_to_reduce
1675: from FA_MC_BOOKS BK1,
1676: FA_MC_BOOKS BK2,
1677: FA_MC_RETIREMENTS RET,
1678: FA_TRANSACTION_HEADERS TH
1679: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1680: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1681: and TH.TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)
1682: and RET.STATUS(+) = 'PROCESSED' --bug#15897249

Line 1702: FA_TRANSACTION_HEADERS TH

1698: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1699: from FA_MC_BOOKS BK1,
1700: FA_MC_BOOKS BK2,
1701: FA_MC_RETIREMENTS RET,
1702: FA_TRANSACTION_HEADERS TH
1703: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1704: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1705: and TH.TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)
1706: and BK2.ASSET_ID= p_asset_id

Line 1732: FA_TRANSACTION_HEADERS TH

1728: from FA_MC_BOOKS BK1,
1729: FA_MC_BOOKS BK2,
1730: FA_MC_BOOKS BK3,
1731: FA_MC_RETIREMENTS RET,
1732: FA_TRANSACTION_HEADERS TH
1733: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1734: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1735: and TH.MEMBER_TRANSACTION_HEADER_ID = BK3.TRANSACTION_HEADER_ID_IN
1736: and TH.MEMBER_TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)

Line 1766: FA_TRANSACTION_HEADERS TH

1762: from FA_MC_BOOKS BK1,
1763: FA_MC_BOOKS BK2,
1764: FA_MC_BOOKS BK3,
1765: FA_MC_RETIREMENTS RET,
1766: FA_TRANSACTION_HEADERS TH
1767: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1768: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1769: and TH.MEMBER_TRANSACTION_HEADER_ID = BK3.TRANSACTION_HEADER_ID_IN
1770: and TH.MEMBER_TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)

Line 1808: from FA_TRANSACTION_HEADERS TH

1804: ------------------------------
1805: cursor C_CHK_TRANSACTION (l_transaction_header_id number)
1806: is
1807: select count('Y')
1808: from FA_TRANSACTION_HEADERS TH
1809: where TH.TRANSACTION_HEADER_ID = l_transaction_header_id
1810: and TH.ASSET_ID = p_asset_id
1811: and TH.BOOK_TYPE_CODE = p_book_type_code;
1812:

Line 1858: FA_TRANSACTION_HEADERS TH

1854: nvl(RET.NBV_RETIRED,0)*nvl(BK2.REDUCTION_RATE,0) cur_net_proceeds_to_reduce
1855: from FA_BOOKS BK1,
1856: FA_BOOKS BK2,
1857: FA_RETIREMENTS RET,
1858: FA_TRANSACTION_HEADERS TH
1859: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1860: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1861: and TH.TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)
1862: and BK2.TRANSACTION_HEADER_ID_IN = mem_transaction_header_id

Line 1876: FA_TRANSACTION_HEADERS TH

1872: nvl(RET.NBV_RETIRED,0)*nvl(BK2.REDUCTION_RATE,0) cur_net_proceeds_to_reduce
1873: from FA_MC_BOOKS BK1,
1874: FA_MC_BOOKS BK2,
1875: FA_MC_RETIREMENTS RET,
1876: FA_TRANSACTION_HEADERS TH
1877: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1878: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1879: and TH.TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)
1880: and BK2.TRANSACTION_HEADER_ID_IN = mem_transaction_header_id

Line 2696: FA_TRANSACTION_HEADERS TH

2692: select sum(BK2.RECOVERABLE_COST -nvl(BK1.RECOVERABLE_COST,0)) recoverable_cost,
2693: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0)) salvage_value
2694: from FA_BOOKS BK1,
2695: FA_BOOKS BK2,
2696: FA_TRANSACTION_HEADERS TH
2697: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2698: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
2699: and TH.ASSET_ID = p_asset_id
2700: and TH.BOOK_TYPE_CODE = p_book_type_code

Line 2708: FA_TRANSACTION_HEADERS TH

2704: select sum(BK2.RECOVERABLE_COST -nvl(BK1.RECOVERABLE_COST,0)) recoverable_cost,
2705: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0)) salvage_value
2706: from FA_MC_BOOKS BK1,
2707: FA_MC_BOOKS BK2,
2708: FA_TRANSACTION_HEADERS TH
2709: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2710: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
2711: and TH.ASSET_ID = p_asset_id
2712: and TH.BOOK_TYPE_CODE = p_book_type_code

Line 2731: FA_TRANSACTION_HEADERS TH,

2727: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) salvage_value
2728: from FA_BOOKS BK1,
2729: FA_BOOKS BK2,
2730: FA_BOOKS BK3,
2731: FA_TRANSACTION_HEADERS TH,
2732: FA_CALENDAR_PERIODS CP
2733: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2734: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
2735: and BK2.BOOK_TYPE_CODE = p_book_type_code

Line 2751: FA_TRANSACTION_HEADERS TH,

2747: BK4. DATE_INEFFECTIVE is null)
2748: and BK3.TRANSACTION_HEADER_ID_IN=
2749: (select max(BK.TRANSACTION_HEADER_ID_IN)
2750: from FA_BOOKS BK,
2751: FA_TRANSACTION_HEADERS TH,
2752: FA_CALENDAR_PERIODS CP
2753: where BK.ASSET_ID= p_asset_id
2754: and BK.BOOK_TYPE_CODE = p_book_type_code
2755: and BK.TRANSACTION_HEADER_ID_IN =TH.TRANSACTION_HEADER_ID

Line 2778: FA_TRANSACTION_HEADERS TH,

2774: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) salvage_value
2775: from FA_MC_BOOKS BK1,
2776: FA_MC_BOOKS BK2,
2777: FA_MC_BOOKS BK3,
2778: FA_TRANSACTION_HEADERS TH,
2779: FA_CALENDAR_PERIODS CP
2780: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2781: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
2782: and BK2.BOOK_TYPE_CODE = p_book_type_code

Line 2802: FA_TRANSACTION_HEADERS TH,

2798: BK4.set_of_books_id = p_set_of_books_id)
2799: and BK3.TRANSACTION_HEADER_ID_IN=
2800: (select max(BK.TRANSACTION_HEADER_ID_IN)
2801: from FA_MC_BOOKS BK,
2802: FA_TRANSACTION_HEADERS TH,
2803: FA_CALENDAR_PERIODS CP,
2804: FA_MC_BOOK_CONTROLS BC
2805: where BK.ASSET_ID= p_asset_id
2806: and BK.BOOK_TYPE_CODE = p_book_type_code

Line 3895: , fa_transaction_headers fth

3891: INTO l_trx_type
3892: , l_old_trx_id
3893: FROM fa_retirements fr
3894: , fa_books fb
3895: , fa_transaction_headers fth
3896: WHERE fr.transaction_header_id_out = p_trans_rec.transaction_header_id
3897: AND fr.transaction_header_id_in = fb.transaction_header_id_in
3898: AND fr.transaction_header_id_in = fth.transaction_header_id
3899: AND fr.asset_id = fb.asset_id

Line 4156: FA_TRANSACTION_HEADERS th

4152: p_period_end_date date
4153: ) is
4154: select nvl(sum(ret.nbv_retired),0) ldt_proceeds
4155: from FA_RETIREMENTS ret,
4156: FA_TRANSACTION_HEADERS th
4157: where th.asset_id = p_asset_id
4158: and th.book_type_code = p_book_type_code
4159: and ret.status in ('PROCESSED','PENDING')
4160: and ret.transaction_header_id_in = th.transaction_header_id

Line 4169: FA_TRANSACTION_HEADERS th

4165: p_period_end_date date
4166: ) is
4167: select nvl(sum(ret.nbv_retired),0) ldt_proceeds
4168: from FA_RETIREMENTS ret,
4169: FA_TRANSACTION_HEADERS th
4170: where th.asset_id = p_asset_id
4171: and th.book_type_code = p_book_type_code
4172: and ret.status in ('PROCESSED','PENDING')
4173: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 4181: FA_TRANSACTION_HEADERS th

4177: p_period_end_date date
4178: ) is
4179: select nvl(sum(ret.nbv_retired),0) ldt_proceeds
4180: from FA_MC_RETIREMENTS ret,
4181: FA_TRANSACTION_HEADERS th
4182: where th.asset_id = p_asset_id
4183: and th.book_type_code = p_book_type_code
4184: and ret.status in ('PROCESSED','PENDING')
4185: and ret.transaction_header_id_in = th.transaction_header_id

Line 4195: FA_TRANSACTION_HEADERS th

4191: p_period_end_date date
4192: ) is
4193: select nvl(sum(ret.nbv_retired),0) ldt_proceeds
4194: from FA_MC_RETIREMENTS ret,
4195: FA_TRANSACTION_HEADERS th
4196: where th.asset_id = p_asset_id
4197: and th.book_type_code = p_book_type_code
4198: and ret.status in ('PROCESSED','PENDING')
4199: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 4210: FA_TRANSACTION_HEADERS th

4206: p_period_end_date date
4207: ) is
4208: select nvl(sum(ret.nbv_retired),0) ytd_proceeds
4209: from FA_RETIREMENTS ret,
4210: FA_TRANSACTION_HEADERS th
4211: where th.asset_id = p_asset_id
4212: and th.book_type_code = p_book_type_code
4213: and ret.status in ('PROCESSED','PENDING')
4214: and ret.transaction_header_id_in = th.transaction_header_id

Line 4225: FA_TRANSACTION_HEADERS th

4221: p_period_end_date date
4222: ) is
4223: select nvl(sum(ret.nbv_retired),0) ytd_proceeds
4224: from FA_RETIREMENTS ret,
4225: FA_TRANSACTION_HEADERS th
4226: where th.asset_id = p_asset_id
4227: and th.book_type_code = p_book_type_code
4228: and ret.status in ('PROCESSED','PENDING')
4229: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 4239: FA_TRANSACTION_HEADERS th

4235: p_period_end_date date
4236: ) is
4237: select nvl(sum(ret.nbv_retired),0) ytd_proceeds
4238: from FA_MC_RETIREMENTS ret,
4239: FA_TRANSACTION_HEADERS th
4240: where th.asset_id = p_asset_id
4241: and th.book_type_code = p_book_type_code
4242: and ret.status in ('PROCESSED','PENDING')
4243: and ret.transaction_header_id_in = th.transaction_header_id

Line 4255: FA_TRANSACTION_HEADERS th

4251: p_period_end_date date
4252: ) is
4253: select nvl(sum(ret.nbv_retired),0) ytd_proceeds
4254: from FA_MC_RETIREMENTS ret,
4255: FA_TRANSACTION_HEADERS th
4256: where th.asset_id = p_asset_id
4257: and th.book_type_code = p_book_type_code
4258: and ret.status in ('PROCESSED','PENDING')
4259: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 4436: FA_TRANSACTION_HEADERS th

4432: p_period_end_date date
4433: ) is
4434: select nvl(sum(ret.cost_retired),0)
4435: from FA_RETIREMENTS ret,
4436: FA_TRANSACTION_HEADERS th
4437: where th.asset_id = p_asset_id
4438: and th.book_type_code = p_book_type_code
4439: and ret.status in ('PROCESSED','PENDING')
4440: and ret.transaction_header_id_in = th.transaction_header_id

Line 4450: FA_TRANSACTION_HEADERS th

4446: p_period_end_date date
4447: ) is
4448: select nvl(sum(ret.cost_retired),0)
4449: from FA_RETIREMENTS ret,
4450: FA_TRANSACTION_HEADERS th
4451: where th.asset_id = p_asset_id
4452: and th.book_type_code = p_book_type_code
4453: and ret.status in ('PROCESSED','PENDING')
4454: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 4462: FA_TRANSACTION_HEADERS th

4458: p_period_end_date date
4459: ) is
4460: select nvl(sum(ret.cost_retired),0)
4461: from FA_MC_RETIREMENTS ret,
4462: FA_TRANSACTION_HEADERS th
4463: where th.asset_id = p_asset_id
4464: and th.book_type_code = p_book_type_code
4465: and ret.status in ('PROCESSED','PENDING')
4466: and ret.transaction_header_id_in = th.transaction_header_id

Line 4475: FA_TRANSACTION_HEADERS th

4471: p_period_end_date date
4472: ) is
4473: select nvl(sum(ret.cost_retired),0)
4474: from FA_MC_RETIREMENTS ret,
4475: FA_TRANSACTION_HEADERS th
4476: where th.asset_id = p_asset_id
4477: and th.book_type_code = p_book_type_code
4478: and ret.status in ('PROCESSED','PENDING')
4479: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 4490: FA_TRANSACTION_HEADERS th

4486: p_period_end_date date
4487: ) is
4488: select nvl(sum(ret.cost_retired),0)
4489: from FA_RETIREMENTS ret,
4490: FA_TRANSACTION_HEADERS th
4491: where th.asset_id = p_asset_id
4492: and th.book_type_code = p_book_type_code
4493: and ret.status in ('PROCESSED','PENDING')
4494: and ret.transaction_header_id_in = th.transaction_header_id

Line 4505: FA_TRANSACTION_HEADERS th

4501: p_period_end_date date
4502: ) is
4503: select nvl(sum(ret.cost_retired),0)
4504: from FA_RETIREMENTS ret,
4505: FA_TRANSACTION_HEADERS th
4506: where th.asset_id = p_asset_id
4507: and th.book_type_code = p_book_type_code
4508: and ret.status in ('PROCESSED','PENDING')
4509: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 4519: FA_TRANSACTION_HEADERS th

4515: p_period_end_date date
4516: ) is
4517: select nvl(sum(ret.cost_retired),0)
4518: from FA_MC_RETIREMENTS ret,
4519: FA_TRANSACTION_HEADERS th
4520: where th.asset_id = p_asset_id
4521: and th.book_type_code = p_book_type_code
4522: and ret.status in ('PROCESSED','PENDING')
4523: and ret.transaction_header_id_in = th.transaction_header_id

Line 4534: FA_TRANSACTION_HEADERS th

4530: p_period_end_date date
4531: ) is
4532: select nvl(sum(ret.cost_retired),0)
4533: from FA_MC_RETIREMENTS ret,
4534: FA_TRANSACTION_HEADERS th
4535: where th.asset_id = p_asset_id
4536: and th.book_type_code = p_book_type_code
4537: and ret.status in ('PROCESSED','PENDING')
4538: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 4671: from FA_TRANSACTION_HEADERS TH

4667: get_mem_trans_info EXCEPTION;
4668:
4669: cursor C_GET_MEM_TRANS_HEADER is
4670: select TH.TRANSACTION_TYPE_CODE
4671: from FA_TRANSACTION_HEADERS TH
4672: where TH.TRANSACTION_HEADER_ID = p_member_transaction_header_id;
4673:
4674:
4675: -- Get Proceeds of member asset

Line 4850: from fa_books bk, fa_transaction_headers th

4846: l_max_adjcost_date date;
4847: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.calc_adj_cost_diff';
4848: cursor c_adj_cost_diff is
4849: select (bk.adjusted_cost-bk.recoverable_cost) adj_cost_diff, th.amortization_start_date
4850: from fa_books bk, fa_transaction_headers th
4851: where bk.asset_id = th.asset_id
4852: and bk.book_type_code = p_book_type_code
4853: and bk.asset_id = p_asset_id
4854: and th.transaction_header_id = bk.transaction_header_id_in

Line 4860: from fa_books bk, fa_transaction_headers th

4856: order by th.transaction_header_id desc;
4857:
4858: cursor c_min_amrt_date is
4859: select min(amortization_start_date)
4860: from fa_books bk, fa_transaction_headers th
4861: where bk.asset_id = th.asset_id
4862: and bk.book_type_code = p_book_type_code
4863: and bk.asset_id = p_asset_id
4864: and th.transaction_header_id = bk.transaction_header_id_in