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 707: fa_transaction_headers th1,

703: decode(adj.debit_credit_flag,
704: 'DR',adj.adjustment_amount,
705: 'CR', -1 * adj.adjustment_amount)))
706: from fa_adjustments adj,
707: fa_transaction_headers th1,
708: fa_transaction_headers th2
709: where adj.transaction_header_id = th1.transaction_header_id
710: and adj.asset_id = h_group_asset_id
711: and adj.book_type_code = h_book_type_code

Line 708: fa_transaction_headers th2

704: 'DR',adj.adjustment_amount,
705: 'CR', -1 * adj.adjustment_amount)))
706: from fa_adjustments adj,
707: fa_transaction_headers th1,
708: fa_transaction_headers th2
709: where adj.transaction_header_id = th1.transaction_header_id
710: and adj.asset_id = h_group_asset_id
711: and adj.book_type_code = h_book_type_code
712: and adj.period_counter_adjusted = h_period_counter

Line 727: fa_transaction_headers th1,

723: decode(adj.debit_credit_flag,
724: 'DR',adj.adjustment_amount,
725: 'CR', -1 * adj.adjustment_amount)))
726: from fa_mc_adjustments adj,
727: fa_transaction_headers th1,
728: fa_transaction_headers th2
729: where adj.transaction_header_id = th1.transaction_header_id
730: and adj.asset_id = h_group_asset_id
731: and adj.book_type_code = h_book_type_code

Line 728: fa_transaction_headers th2

724: 'DR',adj.adjustment_amount,
725: 'CR', -1 * adj.adjustment_amount)))
726: from fa_mc_adjustments adj,
727: fa_transaction_headers th1,
728: fa_transaction_headers th2
729: where adj.transaction_header_id = th1.transaction_header_id
730: and adj.asset_id = h_group_asset_id
731: and adj.book_type_code = h_book_type_code
732: and adj.period_counter_adjusted = h_period_counter

Line 754: fa_transaction_headers th1,

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

Line 755: fa_transaction_headers th2

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

Line 772: fa_transaction_headers th

768: decode(adj.debit_credit_flag,
769: 'DR',adj.adjustment_amount,
770: 'CR', -1 * adj.adjustment_amount)))
771: from fa_adjustments adj,
772: fa_transaction_headers th
773: where adj.book_type_code = h_book_type_code
774: and adj.asset_id = h_unplanned_member_asset
775: and adj.period_counter_adjusted = h_period_counter
776: and adj.transaction_header_id = th.transaction_header_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_mc_adjustments adj,
786: fa_transaction_headers th1,
787: fa_transaction_headers th2
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 787: fa_transaction_headers th2

783: 'DR',adj.adjustment_amount,
784: 'CR', -1 * adj.adjustment_amount)))
785: from fa_mc_adjustments adj,
786: fa_transaction_headers th1,
787: fa_transaction_headers th2
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
791: and adj.period_counter_adjusted = h_period_counter

Line 805: fa_transaction_headers th

801: decode(adj.debit_credit_flag,
802: 'DR',adj.adjustment_amount,
803: 'CR', -1 * adj.adjustment_amount)))
804: from fa_mc_adjustments adj,
805: fa_transaction_headers th
806: where adj.book_type_code = h_book_type_code
807: and adj.asset_id = h_member_asset_id
808: and adj.set_of_books_id = h_set_of_books_id
809: and adj.period_counter_adjusted = h_period_counter

Line 3123: fa_transaction_headers th1,

3119: decode(adj.debit_credit_flag,
3120: 'DR',adj.adjustment_amount,
3121: 'CR', -1 * adj.adjustment_amount)))
3122: from fa_adjustments adj,
3123: fa_transaction_headers th1,
3124: fa_transaction_headers th2
3125: where adj.transaction_header_id = th1.transaction_header_id
3126: and adj.asset_id = p_group_asset_id
3127: and adj.book_type_code = p_book_type_code

Line 3124: fa_transaction_headers th2

3120: 'DR',adj.adjustment_amount,
3121: 'CR', -1 * adj.adjustment_amount)))
3122: from fa_adjustments adj,
3123: fa_transaction_headers th1,
3124: fa_transaction_headers th2
3125: where adj.transaction_header_id = th1.transaction_header_id
3126: and adj.asset_id = p_group_asset_id
3127: and adj.book_type_code = p_book_type_code
3128: and adj.period_counter_adjusted = p_period_counter

Line 3144: fa_transaction_headers th1,

3140: decode(adj.debit_credit_flag,
3141: 'DR',adj.adjustment_amount,
3142: 'CR', -1 * adj.adjustment_amount)))
3143: from fa_mc_adjustments adj,
3144: fa_transaction_headers th1,
3145: fa_transaction_headers th2
3146: where adj.transaction_header_id = th1.transaction_header_id
3147: and adj.asset_id = p_group_asset_id
3148: and adj.book_type_code = p_book_type_code

Line 3145: fa_transaction_headers th2

3141: 'DR',adj.adjustment_amount,
3142: 'CR', -1 * adj.adjustment_amount)))
3143: from fa_mc_adjustments adj,
3144: fa_transaction_headers th1,
3145: fa_transaction_headers th2
3146: where adj.transaction_header_id = th1.transaction_header_id
3147: and adj.asset_id = p_group_asset_id
3148: and adj.book_type_code = p_book_type_code
3149: and adj.period_counter_adjusted = p_period_counter

Line 3906: fa_transaction_headers th1,

3902: decode(adj.debit_credit_flag,
3903: 'DR',adj.adjustment_amount,
3904: 'CR', -1 * adj.adjustment_amount)))
3905: from fa_adjustments adj,
3906: fa_transaction_headers th1,
3907: fa_transaction_headers th2
3908: where adj.transaction_header_id = th1.transaction_header_id
3909: and adj.asset_id = h_group_asset_id
3910: and adj.book_type_code = h_book_type_code

Line 3907: fa_transaction_headers th2

3903: 'DR',adj.adjustment_amount,
3904: 'CR', -1 * adj.adjustment_amount)))
3905: from fa_adjustments adj,
3906: fa_transaction_headers th1,
3907: fa_transaction_headers th2
3908: where adj.transaction_header_id = th1.transaction_header_id
3909: and adj.asset_id = h_group_asset_id
3910: and adj.book_type_code = h_book_type_code
3911: and adj.period_counter_adjusted = h_period_counter

Line 3941: fa_transaction_headers th1,

3937: decode(adj.debit_credit_flag,
3938: 'DR',adj.adjustment_amount,
3939: 'CR', -1 * adj.adjustment_amount)))
3940: from fa_mc_adjustments adj,
3941: fa_transaction_headers th1,
3942: fa_transaction_headers th2
3943: where adj.transaction_header_id = th1.transaction_header_id
3944: and adj.asset_id = h_group_asset_id
3945: and adj.book_type_code = h_book_type_code

Line 3942: fa_transaction_headers th2

3938: 'DR',adj.adjustment_amount,
3939: 'CR', -1 * adj.adjustment_amount)))
3940: from fa_mc_adjustments adj,
3941: fa_transaction_headers th1,
3942: fa_transaction_headers th2
3943: where adj.transaction_header_id = th1.transaction_header_id
3944: and adj.asset_id = h_group_asset_id
3945: and adj.book_type_code = h_book_type_code
3946: and adj.period_counter_adjusted = h_period_counter

Line 4034: fa_transaction_headers th1,

4030: decode(adj.debit_credit_flag,
4031: 'CR',adj.adjustment_amount,
4032: 'DR', -1 * adj.adjustment_amount))),0)
4033: from fa_adjustments adj,
4034: fa_transaction_headers th1,
4035: fa_transaction_headers th2
4036: where adj.transaction_header_id = th1.transaction_header_id
4037: and adj.asset_id = h_group_asset_id
4038: and adj.book_type_code = h_book_type_code

Line 4035: fa_transaction_headers th2

4031: 'CR',adj.adjustment_amount,
4032: 'DR', -1 * adj.adjustment_amount))),0)
4033: from fa_adjustments adj,
4034: fa_transaction_headers th1,
4035: fa_transaction_headers th2
4036: where adj.transaction_header_id = th1.transaction_header_id
4037: and adj.asset_id = h_group_asset_id
4038: and adj.book_type_code = h_book_type_code
4039: and adj.period_counter_adjusted = h_period_counter

Line 4065: fa_transaction_headers th1

4061: decode(adj.debit_credit_flag,
4062: 'CR',adj.adjustment_amount,
4063: 'DR', -1 * adj.adjustment_amount))),0)
4064: from fa_adjustments adj,
4065: fa_transaction_headers th1
4066: where adj.transaction_header_id = th1.transaction_header_id
4067: and adj.asset_id = h_member_asset_id
4068: and adj.book_type_code = h_book_type_code
4069: and adj.period_counter_adjusted = h_period_counter

Line 4118: fa_transaction_headers th1,

4114: decode(adj.debit_credit_flag,
4115: 'CR',adj.adjustment_amount,
4116: 'DR', -1 * adj.adjustment_amount))),0)
4117: from fa_mc_adjustments adj,
4118: fa_transaction_headers th1,
4119: fa_transaction_headers th2
4120: where adj.transaction_header_id = th1.transaction_header_id
4121: and adj.asset_id = h_group_asset_id
4122: and adj.book_type_code = h_book_type_code

Line 4119: fa_transaction_headers th2

4115: 'CR',adj.adjustment_amount,
4116: 'DR', -1 * adj.adjustment_amount))),0)
4117: from fa_mc_adjustments adj,
4118: fa_transaction_headers th1,
4119: fa_transaction_headers th2
4120: where adj.transaction_header_id = th1.transaction_header_id
4121: and adj.asset_id = h_group_asset_id
4122: and adj.book_type_code = h_book_type_code
4123: and adj.period_counter_adjusted = h_period_counter

Line 4156: from fa_transaction_headers th,

4152: and nvl(adj.track_member_flag, 'N') = 'N'; -- ENERGY
4153:
4154: cursor GET_TRANS_ASSET_TYPE is
4155: select ad.asset_type
4156: from fa_transaction_headers th,
4157: fa_additions_b ad
4158: where th.transaction_header_id = p_group_rule_in.adj_transaction_header_id
4159: and ad.asset_id = th.asset_id;
4160:

Line 4300: from fa_transaction_headers

4296: end if;
4297:
4298: select asset_id,transaction_type_code,transaction_key,nvl(amortization_start_date,transaction_date_entered)
4299: into h_asset_id,h_transaction_type_code,h_transaction_key,l_transaction_date_entered
4300: from fa_transaction_headers
4301: where transaction_header_id = h_adj_member_trans_header_id;
4302:
4303: h_period_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
4304:

Line 4926: from fa_transaction_headers

4922:
4923: if h_adj_member_trans_header_id is not null then
4924: select asset_id,transaction_type_code
4925: into h_asset_id,h_transaction_type_code
4926: from fa_transaction_headers
4927: where transaction_header_id = h_adj_member_trans_header_id;
4928: else
4929: h_asset_id := null;
4930: end if;

Line 5151: from fa_transaction_headers

5147:
5148: if h_adj_member_trans_header_id is not null then
5149: select asset_id,transaction_type_code
5150: into h_asset_id,h_transaction_type_code
5151: from fa_transaction_headers
5152: where transaction_header_id = h_adj_member_trans_header_id;
5153: else
5154: h_asset_id := null;
5155: end if;

Line 5452: select fa_transaction_headers_s.nextval

5448: raise ins_dd_adj_err;
5449: end if;
5450:
5451: -- Get new Transaction Header ID
5452: select fa_transaction_headers_s.nextval
5453: into p_transaction_header_id
5454: from dual;
5455:
5456: FA_TRANSACTION_HEADERS_PKG.Insert_Row

Line 5456: FA_TRANSACTION_HEADERS_PKG.Insert_Row

5452: select fa_transaction_headers_s.nextval
5453: into p_transaction_header_id
5454: from dual;
5455:
5456: FA_TRANSACTION_HEADERS_PKG.Insert_Row
5457: (X_Rowid => l_rowid,
5458: X_Transaction_Header_Id => p_transaction_header_id,
5459: X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
5460: X_Asset_Id => p_asset_hdr_rec.asset_id,

Line 5872: from fa_transaction_headers mth

5868: l_member_asset_id number;
5869:
5870: cursor c_get_member_asset_id is
5871: select mth.asset_id
5872: from fa_transaction_headers mth
5873: -- , fa_transaction_headers gth
5874: -- where gth.transaction_header_id = p_transaction_header_id
5875: -- and mth.transaction_header_id = gth.member_transaction_header_id;
5876: where mth.transaction_header_id = p_transaction_header_id;

Line 5873: -- , fa_transaction_headers gth

5869:
5870: cursor c_get_member_asset_id is
5871: select mth.asset_id
5872: from fa_transaction_headers mth
5873: -- , fa_transaction_headers gth
5874: -- where gth.transaction_header_id = p_transaction_header_id
5875: -- and mth.transaction_header_id = gth.member_transaction_header_id;
5876: where mth.transaction_header_id = p_transaction_header_id;
5877:

Line 5896: from fa_transaction_headers

5892:
5893: -- cursor to get period close date
5894: cursor GET_TRANS_DATE is
5895: select nvl(amortization_start_date,transaction_date_entered), asset_id, transaction_type_code
5896: from fa_transaction_headers
5897: where book_type_code = h_book_type_code
5898: and transaction_header_id = p_transaction_header_id;
5899:
5900: -- cursor to get all members at the specified period

Line 6169: from fa_transaction_headers th1,

6165: where ret.book_type_code = h_book_type_code
6166: and ret.asset_id = h_member_asset_id
6167: and exists
6168: (select th1.transaction_header_id
6169: from fa_transaction_headers th1,
6170: fa_deprn_periods dp1,
6171: fa_deprn_periods dp3
6172: where th1.asset_id = ret.asset_id
6173: and dp1.book_type_code = h_book_type_code

Line 6195: from fa_transaction_headers th1,

6191: and ret.asset_id = h_member_asset_id
6192: and ret.set_of_books_id = h_set_of_books_id
6193: and exists
6194: (select th1.transaction_header_id
6195: from fa_transaction_headers th1,
6196: fa_deprn_periods dp1,
6197: fa_deprn_periods dp3
6198: where th1.asset_id = ret.asset_id
6199: and dp1.book_type_code = h_book_type_code

Line 6275: from fa_transaction_headers

6271: and ds.set_of_books_id=h_set_of_books_id;
6272:
6273: cursor ADDITION_DATE is
6274: select nvl(amortization_start_date,transaction_date_entered)
6275: from fa_transaction_headers
6276: where transaction_type_code = 'ADDITION'
6277: and asset_id = h_member_asset_id;
6278:
6279: --* Get latest transaction id for the member asset

Line 6282: from FA_TRANSACTION_HEADERS TH,

6278:
6279: --* Get latest transaction id for the member asset
6280: cursor GET_LAST_TRANS_ID(p_member_asset_id number, p_trans_id number) is
6281: select TH.TRANSACTION_HEADER_ID
6282: from FA_TRANSACTION_HEADERS TH,
6283: FA_TRANSACTION_HEADERS TH1,
6284: FA_CALENDAR_PERIODS DP,
6285: FA_FISCAL_YEAR FY
6286: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar

Line 6283: FA_TRANSACTION_HEADERS TH1,

6279: --* Get latest transaction id for the member asset
6280: cursor GET_LAST_TRANS_ID(p_member_asset_id number, p_trans_id number) is
6281: select TH.TRANSACTION_HEADER_ID
6282: from FA_TRANSACTION_HEADERS TH,
6283: FA_TRANSACTION_HEADERS TH1,
6284: FA_CALENDAR_PERIODS DP,
6285: FA_FISCAL_YEAR FY
6286: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6287: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

Line 6986: from FA_TRANSACTION_HEADERS TH,

6982:
6983: --* Get all transaction headers exists until the specified period
6984: cursor ALL_TRANS_IN_PERIOD(p_fiscal_year number, p_period_num number,p_member_asset_id number) is
6985: select TH.TRANSACTION_HEADER_ID
6986: from FA_TRANSACTION_HEADERS TH,
6987: FA_FISCAL_YEAR FY,
6988: FA_CALENDAR_PERIODS DP
6989: where DP.calendar_type = h_calendar_type
6990: and DP.period_num = p_period_num

Line 7046: from FA_TRANSACTION_HEADERS TH1,

7042: and bk.group_asset_id = h_group_asset_id
7043: and bk.depreciate_flag = 'YES'
7044: and exists
7045: (select TH1.TRANSACTION_HEADER_ID
7046: from FA_TRANSACTION_HEADERS TH1,
7047: FA_CALENDAR_PERIODS DP1,
7048: FA_FISCAL_YEAR FY
7049: where TH1.book_type_code = BK.book_type_code
7050: and DP1.calendar_type = h_calendar_type

Line 7070: from FA_TRANSACTION_HEADERS TH1,

7066: and bk.group_asset_id = h_group_asset_id
7067: and bk.depreciate_flag = 'YES'
7068: and exists
7069: (select TH1.TRANSACTION_HEADER_ID
7070: from FA_TRANSACTION_HEADERS TH1,
7071: FA_CALENDAR_PERIODS DP1,
7072: FA_FISCAL_YEAR FY
7073: where TH1.book_type_code = BK.book_type_code
7074: and DP1.calendar_type = h_calendar_type

Line 7759: from fa_transaction_headers mth

7755: l_member_asset_id number;
7756:
7757: cursor c_get_member_asset_id is
7758: select mth.asset_id
7759: from fa_transaction_headers mth
7760: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id;
7761:
7762: -- cursor to get period_counter
7763: cursor GET_PERIOD_COUNTER is

Line 8347: from FA_TRANSACTION_HEADERS TH1,

8343: where BK.book_type_code = h_book_type_code
8344: and BK.group_asset_id = h_group_asset_id
8345: and exists
8346: (select TH1.TRANSACTION_HEADER_ID
8347: from FA_TRANSACTION_HEADERS TH1,
8348: FA_CALENDAR_PERIODS DP1,
8349: FA_FISCAL_YEAR FY
8350: where TH1.book_type_code = BK.book_type_code
8351: and DP1.calendar_type = h_deprn_calendar

Line 8371: from FA_TRANSACTION_HEADERS TH1,

8367: where BK.book_type_code = h_book_type_code
8368: and BK.group_asset_id = h_group_asset_id
8369: and exists
8370: (select TH1.TRANSACTION_HEADER_ID
8371: from FA_TRANSACTION_HEADERS TH1,
8372: FA_CALENDAR_PERIODS DP1,
8373: FA_FISCAL_YEAR FY
8374: where TH1.book_type_code = BK.book_type_code
8375: and DP1.calendar_type = h_deprn_calendar

Line 8396: from FA_TRANSACTION_HEADERS TH1,

8392: and BK1.asset_id = p_member_asset_id
8393: and BK1.group_asset_id = h_group_asset_id
8394: and exists
8395: (select TH1.TRANSACTION_HEADER_ID
8396: from FA_TRANSACTION_HEADERS TH1,
8397: FA_CALENDAR_PERIODS DP1,
8398: FA_FISCAL_YEAR FY
8399: where TH1.book_type_code = BK1.book_type_code
8400: and TH1.asset_id = BK1.asset_id

Line 8418: from FA_TRANSACTION_HEADERS TH1,

8414: and BK1.asset_id = p_member_asset_id
8415: and BK1.group_asset_id <> h_group_asset_id
8416: and exists
8417: (select TH1.TRANSACTION_HEADER_ID
8418: from FA_TRANSACTION_HEADERS TH1,
8419: FA_CALENDAR_PERIODS DP1,
8420: FA_FISCAL_YEAR FY
8421: where TH1.book_type_code = BK1.book_type_code
8422: and TH1.asset_id = BK1.asset_id

Line 8440: from FA_TRANSACTION_HEADERS TH1,

8436: and BK1.asset_id = p_member_asset_id
8437: and BK1.group_asset_id = h_group_asset_id
8438: and exists
8439: (select TH1.TRANSACTION_HEADER_ID
8440: from FA_TRANSACTION_HEADERS TH1,
8441: FA_CALENDAR_PERIODS DP1,
8442: FA_FISCAL_YEAR FY
8443: where TH1.book_type_code = BK1.book_type_code
8444: and TH1.asset_id = BK1.asset_id

Line 8462: from FA_TRANSACTION_HEADERS TH1,

8458: and BK1.asset_id = p_member_asset_id
8459: and BK1.group_asset_id <> h_group_asset_id
8460: and exists
8461: (select TH1.TRANSACTION_HEADER_ID
8462: from FA_TRANSACTION_HEADERS TH1,
8463: FA_CALENDAR_PERIODS DP1,
8464: FA_FISCAL_YEAR FY
8465: where TH1.book_type_code = BK1.book_type_code
8466: and TH1.asset_id = BK1.asset_id

Line 8500: from FA_TRANSACTION_HEADERS TH,

8496:
8497: --* Get all transaction headers exists in the specified period
8498: cursor ALL_TRANS_IN_PERIOD(p_fiscal_year number, p_period_num number, p_member_asset_id number) is
8499: select TH.TRANSACTION_HEADER_ID, TH.TRANSACTION_TYPE_CODE
8500: from FA_TRANSACTION_HEADERS TH,
8501: FA_CALENDAR_PERIODS DP,
8502: FA_FISCAL_YEAR FY
8503: where DP.calendar_type = h_deprn_calendar
8504: and DP.period_num = p_period_num

Line 10324: from fa_transaction_headers

10320:
10321: --* Cursor to populate the member level amounts
10322: cursor FETCH_MEMBER_ASSET is
10323: select asset_id
10324: from fa_transaction_headers
10325: where transaction_header_id = p_trans_rec.member_transaction_header_id;
10326:
10327: --* Cursor to get current open period
10328: cursor GET_CUR_PERIOD is

Line 10378: from fa_transaction_headers th1,

10374: where ret.book_type_code = h_book_type_code
10375: and ret.asset_id = h_member_asset_id
10376: and exists
10377: (select th1.transaction_header_id
10378: from fa_transaction_headers th1,
10379: fa_deprn_periods dp1,
10380: fa_deprn_periods dp3
10381: where th1.asset_id = ret.asset_id
10382: and dp1.book_type_code = h_book_type_code

Line 10403: from fa_transaction_headers th1,

10399: where ret.book_type_code = h_book_type_code
10400: and ret.asset_id = h_member_asset_id
10401: and exists
10402: (select th1.transaction_header_id
10403: from fa_transaction_headers th1,
10404: fa_deprn_periods_mrc_v dp1,
10405: fa_deprn_periods_mrc_v dp3
10406: where th1.asset_id = ret.asset_id
10407: and dp1.book_type_code = h_book_type_code