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

Line 735: from fa_transaction_headers th1,

731: sum(decode(adj.adjustment_type,'BONUS EXPENSE',
732: decode(adj.debit_credit_flag,
733: 'DR',adj.adjustment_amount,
734: 'CR', -1 * adj.adjustment_amount)))
735: from fa_transaction_headers th1,
736: fa_transaction_headers th2,
737: fa_adjustments adj
738: where adj.transaction_header_id = th1.transaction_header_id
739: and adj.asset_id = h_group_asset_id

Line 736: fa_transaction_headers th2,

732: decode(adj.debit_credit_flag,
733: 'DR',adj.adjustment_amount,
734: 'CR', -1 * adj.adjustment_amount)))
735: from fa_transaction_headers th1,
736: fa_transaction_headers th2,
737: fa_adjustments adj
738: where adj.transaction_header_id = th1.transaction_header_id
739: and adj.asset_id = h_group_asset_id
740: and adj.book_type_code = h_book_type_code

Line 756: fa_transaction_headers th1,

752: decode(adj.debit_credit_flag,
753: 'DR',adj.adjustment_amount,
754: 'CR', -1 * adj.adjustment_amount)))
755: from fa_mc_adjustments adj,
756: fa_transaction_headers th1,
757: fa_transaction_headers th2
758: where adj.transaction_header_id = th1.transaction_header_id
759: and adj.asset_id = h_group_asset_id
760: and adj.book_type_code = h_book_type_code

Line 757: fa_transaction_headers th2

753: 'DR',adj.adjustment_amount,
754: 'CR', -1 * adj.adjustment_amount)))
755: from fa_mc_adjustments adj,
756: fa_transaction_headers th1,
757: fa_transaction_headers th2
758: where adj.transaction_header_id = th1.transaction_header_id
759: and adj.asset_id = h_group_asset_id
760: and adj.book_type_code = h_book_type_code
761: and adj.period_counter_adjusted = h_period_counter

Line 778: select /*+ ORDERED Index(TH2 FA_TRANSACTION_HEADERS_N1)

774: and (nvl(fully_reserved_flag,'N') = 'Y' or nvl(override_flag,'N') = 'Y');
775:
776: --* Cursor for FA_ADJUSTMENTS for unplanned depreciation
777: cursor FA_ADJ_UNPLANNED is
778: select /*+ ORDERED Index(TH2 FA_TRANSACTION_HEADERS_N1)
779: INDEX(TH1 FA_TRANSACTION_HEADERS_N7)
780: INDEX(ADJ FA_ADJUSTMENTS_U1)*/
781: sum(decode(adj.adjustment_type,'EXPENSE',
782: decode(adj.debit_credit_flag,

Line 779: INDEX(TH1 FA_TRANSACTION_HEADERS_N7)

775:
776: --* Cursor for FA_ADJUSTMENTS for unplanned depreciation
777: cursor FA_ADJ_UNPLANNED is
778: select /*+ ORDERED Index(TH2 FA_TRANSACTION_HEADERS_N1)
779: INDEX(TH1 FA_TRANSACTION_HEADERS_N7)
780: INDEX(ADJ FA_ADJUSTMENTS_U1)*/
781: sum(decode(adj.adjustment_type,'EXPENSE',
782: decode(adj.debit_credit_flag,
783: 'DR',adj.adjustment_amount,

Line 785: from fa_transaction_headers th2,

781: sum(decode(adj.adjustment_type,'EXPENSE',
782: decode(adj.debit_credit_flag,
783: 'DR',adj.adjustment_amount,
784: 'CR', -1 * adj.adjustment_amount)))
785: from fa_transaction_headers th2,
786: fa_transaction_headers th1,
787: fa_adjustments adj
788: where adj.transaction_header_id = th1.transaction_header_id
789: and adj.asset_id = h_group_asset_id

Line 786: fa_transaction_headers th1,

782: decode(adj.debit_credit_flag,
783: 'DR',adj.adjustment_amount,
784: 'CR', -1 * adj.adjustment_amount)))
785: from fa_transaction_headers th2,
786: fa_transaction_headers th1,
787: fa_adjustments adj
788: where adj.transaction_header_id = th1.transaction_header_id
789: and adj.asset_id = h_group_asset_id
790: and adj.book_type_code = h_book_type_code

Line 804: fa_transaction_headers th

800: decode(adj.debit_credit_flag,
801: 'DR',adj.adjustment_amount,
802: 'CR', -1 * adj.adjustment_amount)))
803: from fa_adjustments adj,
804: fa_transaction_headers th
805: where adj.book_type_code = h_book_type_code
806: and adj.asset_id = h_unplanned_member_asset
807: and adj.period_counter_adjusted = h_period_counter
808: and adj.transaction_header_id = th.transaction_header_id

Line 819: fa_transaction_headers th1,

815: decode(adj.debit_credit_flag,
816: 'DR',adj.adjustment_amount,
817: 'CR', -1 * adj.adjustment_amount)))
818: from fa_mc_adjustments adj,
819: fa_transaction_headers th1,
820: fa_transaction_headers th2
821: where adj.transaction_header_id = th1.transaction_header_id
822: and adj.asset_id = h_group_asset_id
823: and adj.book_type_code = h_book_type_code

Line 820: fa_transaction_headers th2

816: 'DR',adj.adjustment_amount,
817: 'CR', -1 * adj.adjustment_amount)))
818: from fa_mc_adjustments adj,
819: fa_transaction_headers th1,
820: fa_transaction_headers th2
821: where adj.transaction_header_id = th1.transaction_header_id
822: and adj.asset_id = h_group_asset_id
823: and adj.book_type_code = h_book_type_code
824: and adj.period_counter_adjusted = h_period_counter

Line 838: fa_transaction_headers th

834: decode(adj.debit_credit_flag,
835: 'DR',adj.adjustment_amount,
836: 'CR', -1 * adj.adjustment_amount)))
837: from fa_mc_adjustments adj,
838: fa_transaction_headers th
839: where adj.book_type_code = h_book_type_code
840: and adj.asset_id = h_member_asset_id
841: and adj.set_of_books_id = p_set_of_books_id
842: and adj.period_counter_adjusted = h_period_counter

Line 857: , fa_transaction_headers th1

853: , 'CR', -1 * adj.adjustment_amount))
854: )
855: from fa_track_members tm
856: , fa_adjustments adj
857: , fa_transaction_headers th1
858: , fa_transaction_headers th2
859: where tm.group_asset_id = P_group_asset_id
860: and tm.period_counter = P_period_counter
861: and tm.fiscal_year = P_fiscal_year

Line 858: , fa_transaction_headers th2

854: )
855: from fa_track_members tm
856: , fa_adjustments adj
857: , fa_transaction_headers th1
858: , fa_transaction_headers th2
859: where tm.group_asset_id = P_group_asset_id
860: and tm.period_counter = P_period_counter
861: and tm.fiscal_year = P_fiscal_year
862: and nvl(tm.set_of_books_id,-99) = nvl(p_set_of_books_id,-99)

Line 883: , fa_transaction_headers th1

879: , 'CR', -1 * adj.adjustment_amount))
880: )
881: from fa_track_members tm
882: , fa_mc_adjustments adj
883: , fa_transaction_headers th1
884: , fa_transaction_headers th2
885: where tm.group_asset_id = P_group_asset_id
886: and tm.period_counter = P_period_counter
887: and tm.fiscal_year = P_fiscal_year

Line 884: , fa_transaction_headers th2

880: )
881: from fa_track_members tm
882: , fa_mc_adjustments adj
883: , fa_transaction_headers th1
884: , fa_transaction_headers th2
885: where tm.group_asset_id = P_group_asset_id
886: and tm.period_counter = P_period_counter
887: and tm.fiscal_year = P_fiscal_year
888: and nvl(tm.set_of_books_id,-99) = nvl(p_set_of_books_id,-99)

Line 3268: Index(TH2 FA_TRANSACTION_HEADERS_N1)

3264:
3265: --* Cursor for FA_ADJUSTMENTS
3266: cursor FA_ADJ_EXPENSE(p_member_asset_id number) is
3267: select /*+ ORDERED
3268: Index(TH2 FA_TRANSACTION_HEADERS_N1)
3269: INDEX(TH1 FA_TRANSACTION_HEADERS_N7)
3270: INDEX(ADJ FA_ADJUSTMENTS_U1)*/
3271: sum(decode(adj.adjustment_type,'EXPENSE',
3272: decode(adj.debit_credit_flag,

Line 3269: INDEX(TH1 FA_TRANSACTION_HEADERS_N7)

3265: --* Cursor for FA_ADJUSTMENTS
3266: cursor FA_ADJ_EXPENSE(p_member_asset_id number) is
3267: select /*+ ORDERED
3268: Index(TH2 FA_TRANSACTION_HEADERS_N1)
3269: INDEX(TH1 FA_TRANSACTION_HEADERS_N7)
3270: INDEX(ADJ FA_ADJUSTMENTS_U1)*/
3271: sum(decode(adj.adjustment_type,'EXPENSE',
3272: decode(adj.debit_credit_flag,
3273: 'DR',adj.adjustment_amount,

Line 3279: from fa_transaction_headers th2,

3275: sum(decode(adj.adjustment_type,'BONUS EXPENSE',
3276: decode(adj.debit_credit_flag,
3277: 'DR',adj.adjustment_amount,
3278: 'CR', -1 * adj.adjustment_amount)))
3279: from fa_transaction_headers th2,
3280: fa_transaction_headers th1,
3281: fa_adjustments adj
3282: where adj.transaction_header_id = th1.transaction_header_id
3283: and adj.asset_id = p_group_asset_id

Line 3280: fa_transaction_headers th1,

3276: decode(adj.debit_credit_flag,
3277: 'DR',adj.adjustment_amount,
3278: 'CR', -1 * adj.adjustment_amount)))
3279: from fa_transaction_headers th2,
3280: fa_transaction_headers th1,
3281: fa_adjustments adj
3282: where adj.transaction_header_id = th1.transaction_header_id
3283: and adj.asset_id = p_group_asset_id
3284: and adj.book_type_code = p_book_type_code

Line 3301: from fa_transaction_headers th2,

3297: sum(decode(adj.adjustment_type,'BONUS EXPENSE',
3298: decode(adj.debit_credit_flag,
3299: 'DR',adj.adjustment_amount,
3300: 'CR', -1 * adj.adjustment_amount)))
3301: from fa_transaction_headers th2,
3302: fa_transaction_headers th1,
3303: fa_mc_adjustments adj
3304: where adj.transaction_header_id = th1.transaction_header_id
3305: and adj.asset_id = p_group_asset_id

Line 3302: fa_transaction_headers th1,

3298: decode(adj.debit_credit_flag,
3299: 'DR',adj.adjustment_amount,
3300: 'CR', -1 * adj.adjustment_amount)))
3301: from fa_transaction_headers th2,
3302: fa_transaction_headers th1,
3303: fa_mc_adjustments adj
3304: where adj.transaction_header_id = th1.transaction_header_id
3305: and adj.asset_id = p_group_asset_id
3306: and adj.book_type_code = p_book_type_code

Line 4056: fa_transaction_headers th1,

4052: decode(adj.debit_credit_flag,
4053: 'DR',adj.adjustment_amount,
4054: 'CR', -1 * adj.adjustment_amount)))
4055: from fa_adjustments adj,
4056: fa_transaction_headers th1,
4057: fa_transaction_headers th2
4058: where adj.transaction_header_id = th1.transaction_header_id
4059: and adj.asset_id = h_group_asset_id
4060: and adj.book_type_code = h_book_type_code

Line 4057: fa_transaction_headers th2

4053: 'DR',adj.adjustment_amount,
4054: 'CR', -1 * adj.adjustment_amount)))
4055: from fa_adjustments adj,
4056: fa_transaction_headers th1,
4057: fa_transaction_headers th2
4058: where adj.transaction_header_id = th1.transaction_header_id
4059: and adj.asset_id = h_group_asset_id
4060: and adj.book_type_code = h_book_type_code
4061: and adj.period_counter_adjusted = h_period_counter

Line 4091: fa_transaction_headers th1,

4087: decode(adj.debit_credit_flag,
4088: 'DR',adj.adjustment_amount,
4089: 'CR', -1 * adj.adjustment_amount)))
4090: from fa_mc_adjustments adj,
4091: fa_transaction_headers th1,
4092: fa_transaction_headers th2
4093: where adj.transaction_header_id = th1.transaction_header_id
4094: and adj.asset_id = h_group_asset_id
4095: and adj.book_type_code = h_book_type_code

Line 4092: fa_transaction_headers th2

4088: 'DR',adj.adjustment_amount,
4089: 'CR', -1 * adj.adjustment_amount)))
4090: from fa_mc_adjustments adj,
4091: fa_transaction_headers th1,
4092: fa_transaction_headers th2
4093: where adj.transaction_header_id = th1.transaction_header_id
4094: and adj.asset_id = h_group_asset_id
4095: and adj.book_type_code = h_book_type_code
4096: and adj.period_counter_adjusted = h_period_counter

Line 4184: fa_transaction_headers th1,

4180: decode(adj.debit_credit_flag,
4181: 'CR',adj.adjustment_amount,
4182: 'DR', -1 * adj.adjustment_amount))),0)
4183: from fa_adjustments adj,
4184: fa_transaction_headers th1,
4185: fa_transaction_headers th2
4186: where adj.transaction_header_id = th1.transaction_header_id
4187: and adj.asset_id = h_group_asset_id
4188: and adj.book_type_code = h_book_type_code

Line 4185: fa_transaction_headers th2

4181: 'CR',adj.adjustment_amount,
4182: 'DR', -1 * adj.adjustment_amount))),0)
4183: from fa_adjustments adj,
4184: fa_transaction_headers th1,
4185: fa_transaction_headers th2
4186: where adj.transaction_header_id = th1.transaction_header_id
4187: and adj.asset_id = h_group_asset_id
4188: and adj.book_type_code = h_book_type_code
4189: and adj.period_counter_adjusted = h_period_counter

Line 4215: fa_transaction_headers th1

4211: decode(adj.debit_credit_flag,
4212: 'CR',adj.adjustment_amount,
4213: 'DR', -1 * adj.adjustment_amount))),0)
4214: from fa_adjustments adj,
4215: fa_transaction_headers th1
4216: where adj.transaction_header_id = th1.transaction_header_id
4217: and adj.asset_id = h_member_asset_id
4218: and adj.book_type_code = h_book_type_code
4219: and adj.period_counter_adjusted = h_period_counter

Line 4252: Index(TH2 FA_TRANSACTION_HEADERS_N1)

4248:
4249: --* Cursor for FA_ADJUSTMENTS
4250: cursor FA_ADJ_RESERVE_MRC is
4251: select /*+ ORDERED
4252: Index(TH2 FA_TRANSACTION_HEADERS_N1)
4253: INDEX(TH1 FA_TRANSACTION_HEADERS_N7)
4254: INDEX(ADJ FA_ADJUSTMENTS_U1)*/
4255: sum(decode(adj.adjustment_type,'RESERVE',
4256: decode(adj.debit_credit_flag,

Line 4253: INDEX(TH1 FA_TRANSACTION_HEADERS_N7)

4249: --* Cursor for FA_ADJUSTMENTS
4250: cursor FA_ADJ_RESERVE_MRC is
4251: select /*+ ORDERED
4252: Index(TH2 FA_TRANSACTION_HEADERS_N1)
4253: INDEX(TH1 FA_TRANSACTION_HEADERS_N7)
4254: INDEX(ADJ FA_ADJUSTMENTS_U1)*/
4255: sum(decode(adj.adjustment_type,'RESERVE',
4256: decode(adj.debit_credit_flag,
4257: 'CR',adj.adjustment_amount,

Line 4271: from fa_transaction_headers th2,

4267: nvl(sum(decode(adj.adjustment_type,'REMOVALCOST CLR',
4268: decode(adj.debit_credit_flag,
4269: 'CR',adj.adjustment_amount,
4270: 'DR', -1 * adj.adjustment_amount))),0)
4271: from fa_transaction_headers th2,
4272: fa_transaction_headers th1,
4273: fa_mc_adjustments adj
4274: where adj.transaction_header_id = th1.transaction_header_id
4275: and adj.asset_id = h_group_asset_id

Line 4272: fa_transaction_headers th1,

4268: decode(adj.debit_credit_flag,
4269: 'CR',adj.adjustment_amount,
4270: 'DR', -1 * adj.adjustment_amount))),0)
4271: from fa_transaction_headers th2,
4272: fa_transaction_headers th1,
4273: fa_mc_adjustments adj
4274: where adj.transaction_header_id = th1.transaction_header_id
4275: and adj.asset_id = h_group_asset_id
4276: and adj.book_type_code = h_book_type_code

Line 4310: from fa_transaction_headers th,

4306: and nvl(adj.track_member_flag, 'N') = 'N'; -- ENERGY
4307:
4308: cursor GET_TRANS_ASSET_TYPE is
4309: select ad.asset_type
4310: from fa_transaction_headers th,
4311: fa_additions_b ad
4312: where th.transaction_header_id = p_group_rule_in.adj_transaction_header_id
4313: and ad.asset_id = th.asset_id;
4314:

Line 4456: from fa_transaction_headers

4452: end if;
4453:
4454: select asset_id,transaction_type_code,transaction_key,nvl(amortization_start_date,transaction_date_entered)
4455: into h_asset_id,h_transaction_type_code,h_transaction_key,l_transaction_date_entered
4456: from fa_transaction_headers
4457: where transaction_header_id = h_adj_member_trans_header_id;
4458:
4459: h_period_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
4460:

Line 5087: from fa_transaction_headers

5083:
5084: if h_adj_member_trans_header_id is not null then
5085: select asset_id,transaction_type_code
5086: into h_asset_id,h_transaction_type_code
5087: from fa_transaction_headers
5088: where transaction_header_id = h_adj_member_trans_header_id;
5089: else
5090: h_asset_id := null;
5091: end if;

Line 5309: from fa_transaction_headers

5305:
5306: if h_adj_member_trans_header_id is not null then
5307: select asset_id,transaction_type_code
5308: into h_asset_id,h_transaction_type_code
5309: from fa_transaction_headers
5310: where transaction_header_id = h_adj_member_trans_header_id;
5311: else
5312: h_asset_id := null;
5313: end if;

Line 5604: select fa_transaction_headers_s.nextval

5600:
5601: --Bug#8692192 - To create transaction for primary book only
5602: if p_mrc_sob_type_code <> 'R' then
5603: -- Get new Transaction Header ID
5604: select fa_transaction_headers_s.nextval
5605: into p_transaction_header_id
5606: from dual;
5607:
5608: -- Bug 8703676 : Store the trx_hdr_id during the primary loop

Line 5612: FA_TRANSACTION_HEADERS_PKG.Insert_Row

5608: -- Bug 8703676 : Store the trx_hdr_id during the primary loop
5609: g_primary_trx_hdr_id_tbl(l_index) := p_transaction_header_id;
5610: l_index := l_index + 1;
5611:
5612: FA_TRANSACTION_HEADERS_PKG.Insert_Row
5613: (X_Rowid => l_rowid,
5614: X_Transaction_Header_Id => p_transaction_header_id,
5615: X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
5616: X_Asset_Id => p_asset_hdr_rec.asset_id,

Line 6033: from fa_transaction_headers mth

6029: l_member_asset_id number;
6030:
6031: cursor c_get_member_asset_id is
6032: select mth.asset_id
6033: from fa_transaction_headers mth
6034: -- , fa_transaction_headers gth
6035: -- where gth.transaction_header_id = p_transaction_header_id
6036: -- and mth.transaction_header_id = gth.member_transaction_header_id;
6037: where mth.transaction_header_id = p_transaction_header_id;

Line 6034: -- , fa_transaction_headers gth

6030:
6031: cursor c_get_member_asset_id is
6032: select mth.asset_id
6033: from fa_transaction_headers mth
6034: -- , fa_transaction_headers gth
6035: -- where gth.transaction_header_id = p_transaction_header_id
6036: -- and mth.transaction_header_id = gth.member_transaction_header_id;
6037: where mth.transaction_header_id = p_transaction_header_id;
6038:

Line 6057: from fa_transaction_headers

6053:
6054: -- cursor to get period close date
6055: cursor GET_TRANS_DATE is
6056: select nvl(amortization_start_date,transaction_date_entered), asset_id, transaction_type_code
6057: from fa_transaction_headers
6058: where book_type_code = h_book_type_code
6059: and transaction_header_id = p_transaction_header_id;
6060:
6061: -- cursor to get all members at the specified period

Line 6331: from fa_transaction_headers th1,

6327: where ret.book_type_code = h_book_type_code
6328: and ret.asset_id = h_member_asset_id
6329: and exists
6330: (select th1.transaction_header_id
6331: from fa_transaction_headers th1,
6332: fa_deprn_periods dp1,
6333: fa_deprn_periods dp3
6334: where th1.asset_id = ret.asset_id
6335: and dp1.book_type_code = h_book_type_code

Line 6357: from fa_transaction_headers th1,

6353: and ret.asset_id = h_member_asset_id
6354: and ret.set_of_books_id = p_set_of_books_id
6355: and exists
6356: (select th1.transaction_header_id
6357: from fa_transaction_headers th1,
6358: fa_deprn_periods dp1,
6359: fa_deprn_periods dp3
6360: where th1.asset_id = ret.asset_id
6361: and dp1.book_type_code = h_book_type_code

Line 6437: from fa_transaction_headers

6433: and ds.set_of_books_id=p_set_of_books_id;
6434:
6435: cursor ADDITION_DATE is
6436: select nvl(amortization_start_date,transaction_date_entered)
6437: from fa_transaction_headers
6438: where transaction_type_code = 'ADDITION'
6439: and asset_id = h_member_asset_id;
6440:
6441: --* Get latest transaction id for the member asset

Line 6444: from FA_TRANSACTION_HEADERS TH,

6440:
6441: --* Get latest transaction id for the member asset
6442: cursor GET_LAST_TRANS_ID(p_member_asset_id number, p_trans_id number) is
6443: select TH.TRANSACTION_HEADER_ID
6444: from FA_TRANSACTION_HEADERS TH,
6445: FA_TRANSACTION_HEADERS TH1,
6446: FA_CALENDAR_PERIODS DP,
6447: FA_FISCAL_YEAR FY
6448: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar

Line 6445: FA_TRANSACTION_HEADERS TH1,

6441: --* Get latest transaction id for the member asset
6442: cursor GET_LAST_TRANS_ID(p_member_asset_id number, p_trans_id number) is
6443: select TH.TRANSACTION_HEADER_ID
6444: from FA_TRANSACTION_HEADERS TH,
6445: FA_TRANSACTION_HEADERS TH1,
6446: FA_CALENDAR_PERIODS DP,
6447: FA_FISCAL_YEAR FY
6448: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6449: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

Line 7156: from FA_TRANSACTION_HEADERS TH,

7152:
7153: --* Get all transaction headers exists until the specified period
7154: cursor ALL_TRANS_IN_PERIOD(p_fiscal_year number, p_period_num number,p_member_asset_id number) is
7155: select TH.TRANSACTION_HEADER_ID
7156: from FA_TRANSACTION_HEADERS TH,
7157: FA_FISCAL_YEAR FY,
7158: FA_CALENDAR_PERIODS DP
7159: where DP.calendar_type = h_calendar_type
7160: and DP.period_num = p_period_num

Line 7218: from FA_TRANSACTION_HEADERS TH1,

7214: and bk.group_asset_id = h_group_asset_id
7215: and bk.depreciate_flag = 'YES'
7216: and exists
7217: (select TH1.TRANSACTION_HEADER_ID
7218: from FA_TRANSACTION_HEADERS TH1,
7219: FA_CALENDAR_PERIODS DP1,
7220: FA_FISCAL_YEAR FY
7221: where TH1.book_type_code = BK.book_type_code
7222: and DP1.calendar_type = h_calendar_type

Line 7243: from FA_TRANSACTION_HEADERS TH1,

7239: and bk.depreciate_flag = 'YES'
7240: and bk.set_of_books_id = h_set_of_books_id
7241: and exists
7242: (select TH1.TRANSACTION_HEADER_ID
7243: from FA_TRANSACTION_HEADERS TH1,
7244: FA_CALENDAR_PERIODS DP1,
7245: FA_FISCAL_YEAR FY
7246: where TH1.book_type_code = BK.book_type_code
7247: and DP1.calendar_type = h_calendar_type

Line 7938: from fa_transaction_headers mth

7934: l_member_asset_id number;
7935:
7936: cursor c_get_member_asset_id is
7937: select mth.asset_id
7938: from fa_transaction_headers mth
7939: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id;
7940:
7941: -- cursor to get period_counter
7942: cursor GET_PERIOD_COUNTER is

Line 8588: FA_TRANSACTION_HEADERS TH1,

8584: first_value(bk_in.transaction_header_id_in)
8585: over (partition by bk_in.asset_id, bk_in.book_type_code
8586: order by bk_in.transaction_header_id_in desc nulls last) as transaction_header_id_in
8587: from fa_books bk_in,
8588: FA_TRANSACTION_HEADERS TH1,
8589: FA_CALENDAR_PERIODS DP1,
8590: FA_FISCAL_YEAR FY
8591: where TH1.book_type_code = BK_in.book_type_code
8592: and DP1.calendar_type = h_deprn_calendar

Line 8610: FA_TRANSACTION_HEADERS TH1,

8606: first_value(bk_in.transaction_header_id_in)
8607: over (partition by bk_in.asset_id, bk_in.book_type_code
8608: order by bk_in.transaction_header_id_in desc nulls last) as transaction_header_id_in
8609: from fa_books bk_in,
8610: FA_TRANSACTION_HEADERS TH1,
8611: FA_CALENDAR_PERIODS DP1,
8612: FA_FISCAL_YEAR FY
8613: where TH1.book_type_code = BK_in.book_type_code
8614: and DP1.calendar_type = h_deprn_calendar

Line 8628: FA_TRANSACTION_HEADERS TH2,

8624: and (bk_in.asset_id, bk_in.book_type_code) in
8625: (
8626: select distinct bk_in2.asset_id, bk_in2.book_type_code
8627: from fa_books bk_in2,
8628: FA_TRANSACTION_HEADERS TH2,
8629: FA_CALENDAR_PERIODS DP2,
8630: FA_FISCAL_YEAR FY2
8631: where TH2.book_type_code = BK_in2.book_type_code
8632: and DP2.calendar_type = h_deprn_calendar

Line 8668: FA_TRANSACTION_HEADERS TH1,

8664: first_value(bk_in.transaction_header_id_in)
8665: over (partition by bk_in.asset_id, bk_in.book_type_code
8666: order by bk_in.transaction_header_id_in desc nulls last) as transaction_header_id_in
8667: from fa_mc_books bk_in,
8668: FA_TRANSACTION_HEADERS TH1,
8669: FA_CALENDAR_PERIODS DP1,
8670: FA_FISCAL_YEAR FY
8671: where TH1.book_type_code = BK_in.book_type_code
8672: and DP1.calendar_type = h_deprn_calendar

Line 8691: FA_TRANSACTION_HEADERS TH1,

8687: first_value(bk_in.transaction_header_id_in)
8688: over (partition by bk_in.asset_id, bk_in.book_type_code
8689: order by bk_in.transaction_header_id_in desc nulls last) as transaction_header_id_in
8690: from fa_mc_books bk_in,
8691: FA_TRANSACTION_HEADERS TH1,
8692: FA_CALENDAR_PERIODS DP1,
8693: FA_FISCAL_YEAR FY
8694: where TH1.book_type_code = BK_in.book_type_code
8695: and DP1.calendar_type = h_deprn_calendar

Line 8710: FA_TRANSACTION_HEADERS TH2,

8706: and (bk_in.asset_id, bk_in.book_type_code) in
8707: (
8708: select distinct bk_in2.asset_id, bk_in2.book_type_code
8709: from fa_mc_books bk_in2,
8710: FA_TRANSACTION_HEADERS TH2,
8711: FA_CALENDAR_PERIODS DP2,
8712: FA_FISCAL_YEAR FY2
8713: where TH2.book_type_code = BK_in2.book_type_code
8714: and DP2.calendar_type = h_deprn_calendar

Line 8766: from FA_TRANSACTION_HEADERS TH,

8762:
8763: --* Get all transaction headers exists in the specified period
8764: cursor ALL_TRANS_IN_PERIOD(p_fiscal_year number, p_period_num number, p_member_asset_id number) is
8765: select TH.TRANSACTION_HEADER_ID, TH.TRANSACTION_TYPE_CODE,TH.TRANSACTION_KEY --Bug 8484007
8766: from FA_TRANSACTION_HEADERS TH,
8767: FA_CALENDAR_PERIODS DP,
8768: FA_FISCAL_YEAR FY
8769: where DP.calendar_type = h_deprn_calendar
8770: and DP.period_num = p_period_num

Line 9082: from fa_transaction_headers mth

9078: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
9079:
9080: cursor c_get_member_asset_id is
9081: select mth.asset_id
9082: from fa_transaction_headers mth
9083: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id;
9084:
9085: BEGIN
9086: if (p_log_level_rec.statement_level) then

Line 10649: from fa_transaction_headers

10645:
10646: --* Cursor to populate the member level amounts
10647: cursor FETCH_MEMBER_ASSET is
10648: select asset_id
10649: from fa_transaction_headers
10650: where transaction_header_id = p_trans_rec.member_transaction_header_id;
10651:
10652: --* Cursor to get current open period
10653: cursor GET_CUR_PERIOD is

Line 10707: from fa_transaction_headers th1,

10703: where ret.book_type_code = h_book_type_code
10704: and ret.asset_id = h_member_asset_id
10705: and exists
10706: (select th1.transaction_header_id
10707: from fa_transaction_headers th1,
10708: fa_deprn_periods dp1,
10709: fa_deprn_periods dp3
10710: where th1.asset_id = ret.asset_id
10711: and dp1.book_type_code = h_book_type_code

Line 10733: from fa_transaction_headers th1,

10729: and ret.asset_id = h_member_asset_id
10730: and ret.set_of_books_id = h_set_of_books_id
10731: and exists
10732: (select th1.transaction_header_id
10733: from fa_transaction_headers th1,
10734: fa_mc_deprn_periods dp1,
10735: fa_mc_deprn_periods dp3
10736: where th1.asset_id = ret.asset_id
10737: and dp1.book_type_code = h_book_type_code

Line 11761: fa_transaction_headers th1,

11757: 'CR', -1 * adj.adjustment_amount))) as mem_unpln_exp,
11758: th2.asset_id member_asset_id
11759: from fa_adjustments adj,
11760: fa_adjustments adj_mem,
11761: fa_transaction_headers th1,
11762: fa_transaction_headers th2
11763: where adj.transaction_header_id = th1.transaction_header_id
11764: and adj.asset_id = p_group_asset_id
11765: and adj.book_type_code = p_book_type_code

Line 11762: fa_transaction_headers th2

11758: th2.asset_id member_asset_id
11759: from fa_adjustments adj,
11760: fa_adjustments adj_mem,
11761: fa_transaction_headers th1,
11762: fa_transaction_headers th2
11763: where adj.transaction_header_id = th1.transaction_header_id
11764: and adj.asset_id = p_group_asset_id
11765: and adj.book_type_code = p_book_type_code
11766: and adj.period_counter_adjusted = p_period_counter

Line 11789: fa_transaction_headers th1,

11785: 'CR', -1 * adj.adjustment_amount))) as mem_unpln_exp,
11786: th2.asset_id member_asset_id
11787: from fa_mc_adjustments adj,
11788: fa_mc_adjustments adj_mem,
11789: fa_transaction_headers th1,
11790: fa_transaction_headers th2
11791: where adj.transaction_header_id = th1.transaction_header_id
11792: and adj.asset_id = p_group_asset_id
11793: and adj.book_type_code = p_book_type_code

Line 11790: fa_transaction_headers th2

11786: th2.asset_id member_asset_id
11787: from fa_mc_adjustments adj,
11788: fa_mc_adjustments adj_mem,
11789: fa_transaction_headers th1,
11790: fa_transaction_headers th2
11791: where adj.transaction_header_id = th1.transaction_header_id
11792: and adj.asset_id = p_group_asset_id
11793: and adj.book_type_code = p_book_type_code
11794: and adj.period_counter_adjusted = p_period_counter