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 1435: FA_TRANSACTION_HEADERS TH

1431: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK2.REDUCTION_RATE,0)) net_proceeds_to_reduce
1432: from FA_BOOKS BK1,
1433: FA_BOOKS BK2,
1434: FA_RETIREMENTS RET,
1435: FA_TRANSACTION_HEADERS TH
1436: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1437: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1438: and TH.TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)
1439: and BK2.ASSET_ID= p_asset_id

Line 1455: FA_TRANSACTION_HEADERS TH

1451: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1452: from FA_BOOKS BK1,
1453: FA_BOOKS BK2,
1454: FA_RETIREMENTS RET,
1455: FA_TRANSACTION_HEADERS TH
1456: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1457: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1458: and TH.TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)
1459: and BK2.ASSET_ID= p_asset_id

Line 1482: FA_TRANSACTION_HEADERS TH

1478: from FA_BOOKS BK1,
1479: FA_BOOKS BK2,
1480: FA_BOOKS BK3,
1481: FA_RETIREMENTS RET,
1482: FA_TRANSACTION_HEADERS TH
1483: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1484: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1485: and TH.MEMBER_TRANSACTION_HEADER_ID = BK3.TRANSACTION_HEADER_ID_IN
1486: and TH.MEMBER_TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)

Line 1510: FA_TRANSACTION_HEADERS TH

1506: from FA_BOOKS BK1,
1507: FA_BOOKS BK2,
1508: FA_BOOKS BK3,
1509: FA_RETIREMENTS RET,
1510: FA_TRANSACTION_HEADERS TH
1511: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1512: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1513: and TH.MEMBER_TRANSACTION_HEADER_ID = BK3.TRANSACTION_HEADER_ID_IN
1514: and TH.MEMBER_TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)

Line 1547: FA_TRANSACTION_HEADERS TH

1543: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK2.REDUCTION_RATE,0)) net_proceeds_to_reduce
1544: from FA_BOOKS_MRC_V BK1,
1545: FA_BOOKS_MRC_V BK2,
1546: FA_RETIREMENTS_MRC_V RET,
1547: FA_TRANSACTION_HEADERS TH
1548: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1549: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1550: and TH.TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)
1551: and BK2.ASSET_ID= p_asset_id

Line 1567: FA_TRANSACTION_HEADERS TH

1563: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1564: from FA_BOOKS_MRC_V BK1,
1565: FA_BOOKS_MRC_V BK2,
1566: FA_RETIREMENTS_MRC_V RET,
1567: FA_TRANSACTION_HEADERS TH
1568: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1569: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1570: and TH.TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)
1571: and BK2.ASSET_ID= p_asset_id

Line 1594: FA_TRANSACTION_HEADERS TH

1590: from FA_BOOKS_MRC_V BK1,
1591: FA_BOOKS_MRC_V BK2,
1592: FA_BOOKS_MRC_V BK3,
1593: FA_RETIREMENTS_MRC_V RET,
1594: FA_TRANSACTION_HEADERS TH
1595: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1596: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1597: and TH.MEMBER_TRANSACTION_HEADER_ID = BK3.TRANSACTION_HEADER_ID_IN
1598: and TH.MEMBER_TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)

Line 1622: FA_TRANSACTION_HEADERS TH

1618: from FA_BOOKS_MRC_V BK1,
1619: FA_BOOKS_MRC_V BK2,
1620: FA_BOOKS_MRC_V BK3,
1621: FA_RETIREMENTS_MRC_V RET,
1622: FA_TRANSACTION_HEADERS TH
1623: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1624: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
1625: and TH.MEMBER_TRANSACTION_HEADER_ID = BK3.TRANSACTION_HEADER_ID_IN
1626: and TH.MEMBER_TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)

Line 1658: from FA_TRANSACTION_HEADERS TH

1654: ------------------------------
1655: cursor C_CHK_TRANSACTION (l_transaction_header_id number)
1656: is
1657: select count('Y')
1658: from FA_TRANSACTION_HEADERS TH
1659: where TH.TRANSACTION_HEADER_ID = l_transaction_header_id
1660: and TH.ASSET_ID = p_asset_id
1661: and TH.BOOK_TYPE_CODE = p_book_type_code;
1662:

Line 2452: FA_TRANSACTION_HEADERS TH

2448: select sum(BK2.RECOVERABLE_COST -nvl(BK1.RECOVERABLE_COST,0)) recoverable_cost,
2449: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0)) salvage_value
2450: from FA_BOOKS BK1,
2451: FA_BOOKS BK2,
2452: FA_TRANSACTION_HEADERS TH
2453: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2454: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
2455: and TH.ASSET_ID = p_asset_id
2456: and TH.BOOK_TYPE_CODE = p_book_type_code

Line 2464: FA_TRANSACTION_HEADERS TH

2460: select sum(BK2.RECOVERABLE_COST -nvl(BK1.RECOVERABLE_COST,0)) recoverable_cost,
2461: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0)) salvage_value
2462: from FA_BOOKS_MRC_V BK1,
2463: FA_BOOKS_MRC_V BK2,
2464: FA_TRANSACTION_HEADERS TH
2465: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2466: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
2467: and TH.ASSET_ID = p_asset_id
2468: and TH.BOOK_TYPE_CODE = p_book_type_code

Line 2485: FA_TRANSACTION_HEADERS TH,

2481: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) salvage_value
2482: from FA_BOOKS BK1,
2483: FA_BOOKS BK2,
2484: FA_BOOKS BK3,
2485: FA_TRANSACTION_HEADERS TH,
2486: FA_CALENDAR_PERIODS CP
2487: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2488: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
2489: and BK2.BOOK_TYPE_CODE = p_book_type_code

Line 2505: FA_TRANSACTION_HEADERS TH,

2501: BK4. DATE_INEFFECTIVE is null)
2502: and BK3.TRANSACTION_HEADER_ID_IN=
2503: (select max(BK.TRANSACTION_HEADER_ID_IN)
2504: from FA_BOOKS BK,
2505: FA_TRANSACTION_HEADERS TH,
2506: FA_CALENDAR_PERIODS CP
2507: where BK.ASSET_ID= p_asset_id
2508: and BK.BOOK_TYPE_CODE = p_book_type_code
2509: and BK.TRANSACTION_HEADER_ID_IN =TH.TRANSACTION_HEADER_ID

Line 2532: FA_TRANSACTION_HEADERS TH,

2528: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) salvage_value
2529: from FA_BOOKS_MRC_V BK1,
2530: FA_BOOKS_MRC_V BK2,
2531: FA_BOOKS_MRC_V BK3,
2532: FA_TRANSACTION_HEADERS TH,
2533: FA_CALENDAR_PERIODS CP
2534: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2535: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
2536: and BK2.BOOK_TYPE_CODE = p_book_type_code

Line 2552: FA_TRANSACTION_HEADERS TH,

2548: BK4. DATE_INEFFECTIVE is null)
2549: and BK3.TRANSACTION_HEADER_ID_IN=
2550: (select max(BK.TRANSACTION_HEADER_ID_IN)
2551: from FA_BOOKS_MRC_V BK,
2552: FA_TRANSACTION_HEADERS TH,
2553: FA_CALENDAR_PERIODS CP,
2554: FA_BOOK_CONTROLS_MRC_V BC
2555: where BK.ASSET_ID= p_asset_id
2556: and BK.BOOK_TYPE_CODE = p_book_type_code

Line 3728: FA_TRANSACTION_HEADERS th

3724: p_period_end_date date
3725: ) is
3726: select nvl(sum(ret.nbv_retired),0) ldt_proceeds
3727: from FA_RETIREMENTS ret,
3728: FA_TRANSACTION_HEADERS th
3729: where th.asset_id = p_asset_id
3730: and th.book_type_code = p_book_type_code
3731: and ret.status in ('PROCESSED','PENDING')
3732: and ret.transaction_header_id_in = th.transaction_header_id

Line 3741: FA_TRANSACTION_HEADERS th

3737: p_period_end_date date
3738: ) is
3739: select nvl(sum(ret.nbv_retired),0) ldt_proceeds
3740: from FA_RETIREMENTS ret,
3741: FA_TRANSACTION_HEADERS th
3742: where th.asset_id = p_asset_id
3743: and th.book_type_code = p_book_type_code
3744: and ret.status in ('PROCESSED','PENDING')
3745: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 3753: FA_TRANSACTION_HEADERS th

3749: p_period_end_date date
3750: ) is
3751: select nvl(sum(ret.nbv_retired),0) ldt_proceeds
3752: from FA_RETIREMENTS_MRC_V ret,
3753: FA_TRANSACTION_HEADERS th
3754: where th.asset_id = p_asset_id
3755: and th.book_type_code = p_book_type_code
3756: and ret.status in ('PROCESSED','PENDING')
3757: and ret.transaction_header_id_in = th.transaction_header_id

Line 3766: FA_TRANSACTION_HEADERS th

3762: p_period_end_date date
3763: ) is
3764: select nvl(sum(ret.nbv_retired),0) ldt_proceeds
3765: from FA_RETIREMENTS_MRC_V ret,
3766: FA_TRANSACTION_HEADERS th
3767: where th.asset_id = p_asset_id
3768: and th.book_type_code = p_book_type_code
3769: and ret.status in ('PROCESSED','PENDING')
3770: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 3780: FA_TRANSACTION_HEADERS th

3776: p_period_end_date date
3777: ) is
3778: select nvl(sum(ret.nbv_retired),0) ytd_proceeds
3779: from FA_RETIREMENTS ret,
3780: FA_TRANSACTION_HEADERS th
3781: where th.asset_id = p_asset_id
3782: and th.book_type_code = p_book_type_code
3783: and ret.status in ('PROCESSED','PENDING')
3784: and ret.transaction_header_id_in = th.transaction_header_id

Line 3795: FA_TRANSACTION_HEADERS th

3791: p_period_end_date date
3792: ) is
3793: select nvl(sum(ret.nbv_retired),0) ytd_proceeds
3794: from FA_RETIREMENTS ret,
3795: FA_TRANSACTION_HEADERS th
3796: where th.asset_id = p_asset_id
3797: and th.book_type_code = p_book_type_code
3798: and ret.status in ('PROCESSED','PENDING')
3799: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 3809: FA_TRANSACTION_HEADERS th

3805: p_period_end_date date
3806: ) is
3807: select nvl(sum(ret.nbv_retired),0) ytd_proceeds
3808: from FA_RETIREMENTS_MRC_V ret,
3809: FA_TRANSACTION_HEADERS th
3810: where th.asset_id = p_asset_id
3811: and th.book_type_code = p_book_type_code
3812: and ret.status in ('PROCESSED','PENDING')
3813: and ret.transaction_header_id_in = th.transaction_header_id

Line 3824: FA_TRANSACTION_HEADERS th

3820: p_period_end_date date
3821: ) is
3822: select nvl(sum(ret.nbv_retired),0) ytd_proceeds
3823: from FA_RETIREMENTS_MRC_V ret,
3824: FA_TRANSACTION_HEADERS th
3825: where th.asset_id = p_asset_id
3826: and th.book_type_code = p_book_type_code
3827: and ret.status in ('PROCESSED','PENDING')
3828: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 4003: FA_TRANSACTION_HEADERS th

3999: p_period_end_date date
4000: ) is
4001: select nvl(sum(ret.cost_retired),0)
4002: from FA_RETIREMENTS ret,
4003: FA_TRANSACTION_HEADERS th
4004: where th.asset_id = p_asset_id
4005: and th.book_type_code = p_book_type_code
4006: and ret.status in ('PROCESSED','PENDING')
4007: and ret.transaction_header_id_in = th.transaction_header_id

Line 4017: FA_TRANSACTION_HEADERS th

4013: p_period_end_date date
4014: ) is
4015: select nvl(sum(ret.cost_retired),0)
4016: from FA_RETIREMENTS ret,
4017: FA_TRANSACTION_HEADERS th
4018: where th.asset_id = p_asset_id
4019: and th.book_type_code = p_book_type_code
4020: and ret.status in ('PROCESSED','PENDING')
4021: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 4029: FA_TRANSACTION_HEADERS th

4025: p_period_end_date date
4026: ) is
4027: select nvl(sum(ret.cost_retired),0)
4028: from FA_RETIREMENTS_MRC_V ret,
4029: FA_TRANSACTION_HEADERS th
4030: where th.asset_id = p_asset_id
4031: and th.book_type_code = p_book_type_code
4032: and ret.status in ('PROCESSED','PENDING')
4033: and ret.transaction_header_id_in = th.transaction_header_id

Line 4041: FA_TRANSACTION_HEADERS th

4037: p_period_end_date date
4038: ) is
4039: select nvl(sum(ret.cost_retired),0)
4040: from FA_RETIREMENTS_MRC_V ret,
4041: FA_TRANSACTION_HEADERS th
4042: where th.asset_id = p_asset_id
4043: and th.book_type_code = p_book_type_code
4044: and ret.status in ('PROCESSED','PENDING')
4045: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 4055: FA_TRANSACTION_HEADERS th

4051: p_period_end_date date
4052: ) is
4053: select nvl(sum(ret.cost_retired),0)
4054: from FA_RETIREMENTS ret,
4055: FA_TRANSACTION_HEADERS th
4056: where th.asset_id = p_asset_id
4057: and th.book_type_code = p_book_type_code
4058: and ret.status in ('PROCESSED','PENDING')
4059: and ret.transaction_header_id_in = th.transaction_header_id

Line 4070: FA_TRANSACTION_HEADERS th

4066: p_period_end_date date
4067: ) is
4068: select nvl(sum(ret.cost_retired),0)
4069: from FA_RETIREMENTS ret,
4070: FA_TRANSACTION_HEADERS th
4071: where th.asset_id = p_asset_id
4072: and th.book_type_code = p_book_type_code
4073: and ret.status in ('PROCESSED','PENDING')
4074: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 4084: FA_TRANSACTION_HEADERS th

4080: p_period_end_date date
4081: ) is
4082: select nvl(sum(ret.cost_retired),0)
4083: from FA_RETIREMENTS_MRC_V ret,
4084: FA_TRANSACTION_HEADERS th
4085: where th.asset_id = p_asset_id
4086: and th.book_type_code = p_book_type_code
4087: and ret.status in ('PROCESSED','PENDING')
4088: and ret.transaction_header_id_in = th.transaction_header_id

Line 4098: FA_TRANSACTION_HEADERS th

4094: p_period_end_date date
4095: ) is
4096: select nvl(sum(ret.cost_retired),0)
4097: from FA_RETIREMENTS_MRC_V ret,
4098: FA_TRANSACTION_HEADERS th
4099: where th.asset_id = p_asset_id
4100: and th.book_type_code = p_book_type_code
4101: and ret.status in ('PROCESSED','PENDING')
4102: and ret.transaction_header_id_in = th.member_transaction_header_id

Line 4234: from FA_TRANSACTION_HEADERS TH

4230: get_mem_trans_info EXCEPTION;
4231:
4232: cursor C_GET_MEM_TRANS_HEADER is
4233: select TH.TRANSACTION_TYPE_CODE
4234: from FA_TRANSACTION_HEADERS TH
4235: where TH.TRANSACTION_HEADER_ID = p_member_transaction_header_id;
4236:
4237:
4238: -- Get Proceeds of member asset