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.IGI_IGIIARRD_XMLP_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 94: FA_DISTRIBUTION_HISTORY DH,

90: AJ.Adjustment_Amount),
91: 'FA',
92: 1
93: FROM
94: FA_DISTRIBUTION_HISTORY DH,
95: FA_TRANSACTION_HEADERS TH,
96: FA_ASSET_HISTORY AH,
97: FA_ADJUSTMENTS AJ
98:

Line 175: FA_DISTRIBUTION_HISTORY DH,

171: AJ.Amount),
172: 'IAC',
173: 2
174: FROM
175: FA_DISTRIBUTION_HISTORY DH,
176: IGI_IAC_TRANSACTION_HEADERS TH,
177: IGI_IAC_ADJUSTMENTS AJ
178: WHERE
179: DH.Book_Type_Code = p_Distribution_Source_Book AND

Line 226: FA_DISTRIBUTION_HISTORY DH,

222: AJ.Amount),
223: 'IAC',
224: 2
225: FROM
226: FA_DISTRIBUTION_HISTORY DH,
227: IGI_IAC_TRANSACTION_HEADERS TH,
228: IGI_IAC_ADJUSTMENTS AJ
229: WHERE
230: DH.Book_Type_Code = p_Distribution_Source_Book AND

Line 315: FA_DISTRIBUTION_HISTORY DH,

311: SUM (DECODE (AJ.Dr_Cr_Flag, l_Balance_Type, 1, -1) * AJ.Amount),
312: l_data_source,
313: l_display_order
314: FROM
315: FA_DISTRIBUTION_HISTORY DH,
316: IGI_IAC_TRANSACTION_HEADERS TH,
317: IGI_IAC_ADJUSTMENTS AJ
318: WHERE
319: DH.Book_Type_Code = p_Distribution_Source_Book AND

Line 359: FA_DISTRIBUTION_HISTORY DH,

355: SUM (DECODE (AJ.Dr_Cr_Flag, l_Balance_Type, 1, -1) * AJ.Amount),
356: l_data_source,
357: l_display_order
358: FROM
359: FA_DISTRIBUTION_HISTORY DH,
360: IGI_IAC_TRANSACTION_HEADERS TH,
361: IGI_IAC_ADJUSTMENTS AJ,
362: IGI_IAC_ADJUSTMENTS SUB_AJ
363: WHERE

Line 417: FA_DISTRIBUTION_HISTORY DH,

413: SUM (DECODE (AJ.Dr_Cr_Flag, l_Balance_Type, 1, -1) * AJ.Amount),
414: l_data_source,
415: l_display_order
416: FROM
417: FA_DISTRIBUTION_HISTORY DH,
418: IGI_IAC_TRANSACTION_HEADERS TH,
419: IGI_IAC_ADJUSTMENTS AJ
420: WHERE
421: DH.Book_Type_Code = p_Distribution_Source_Book AND

Line 485: FA_DISTRIBUTION_HISTORY DH,

481: sum(DD.DEPRN_RESERVE),
482: 'FA',
483: 1
484: FROM
485: FA_DISTRIBUTION_HISTORY DH,
486: FA_CATEGORY_BOOKS CB,
487: FA_ASSET_HISTORY AH,
488: FA_DEPRN_DETAIL DD
489: WHERE

Line 581: FA_DISTRIBUTION_HISTORY DH,

577: 'REVAL RESERVE', DD.Reval_Reserve),
578: 'FA',
579: 1
580: FROM
581: FA_DISTRIBUTION_HISTORY DH,
582: FA_DEPRN_DETAIL DD,
583: FA_ASSET_HISTORY AH,
584: FA_CATEGORY_BOOKS CB,
585: FA_BOOKS BK

Line 668: FA_DISTRIBUTION_HISTORY DH,

664: 'REVAL RESERVE', DD.Reval_Reserve_Net),
665: 'IAC',
666: 2
667: FROM
668: FA_DISTRIBUTION_HISTORY DH,
669: IGI_IAC_DET_BALANCES DD,
670: FA_ASSET_HISTORY AH,
671: FA_CATEGORY_BOOKS CB,
672: IGI_IAC_CATEGORY_BOOKS ICB,

Line 790: FA_DISTRIBUTION_HISTORY DH,

786: 'BACKLOG',3,
787: 'GENERAL FUND',2,
788: 'NET',4) )
789: FROM
790: FA_DISTRIBUTION_HISTORY DH,
791: IGI_IAC_DET_BALANCES DD,
792: FA_ASSET_HISTORY AH,
793: FA_CATEGORY_BOOKS CB,
794: IGI_IAC_CATEGORY_BOOKS ICB,

Line 869: fa_distribution_history dh,

865: 'BACKLOG',2,
866: 'NET',3)
867: FROM
868: igi_iac_det_balances db,
869: fa_distribution_history dh,
870: fa_asset_history ah,
871: igi_iac_category_books icb
872: WHERE
873: dh.book_type_code = p_book AND

Line 936: FA_DISTRIBUTION_HISTORY DH,

932: 'FA',
933: 1
934: FROM
935: FA_CATEGORY_BOOKS CB,
936: FA_DISTRIBUTION_HISTORY DH,
937: FA_ASSET_HISTORY AH,
938: FA_DEPRN_DETAIL DD,
939: FA_DEPRN_PERIODS DP
940: WHERE

Line 989: l_distribution_ccid fa_distribution_history.code_combination_id%TYPE;

985: p_report_type varchar2,
986: p_balance_type varchar2)
987: IS
988: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
989: l_distribution_ccid fa_distribution_history.code_combination_id%TYPE;
990:
991: /* Cursor for fetching all retirement, reinstatement transactions */
992: CURSOR c_get_transactions(cp_book fa_books.book_type_code%TYPE) IS
993: SELECT *

Line 1109: CURSOR c_get_dist_ccid( cp_book fa_distribution_history.book_type_code%TYPE,

1105: WHERE book_type_code = cp_book
1106: AND category_id = cp_category_id;
1107:
1108: /* Cursor to fetch the distribution ccid for a distribution */
1109: CURSOR c_get_dist_ccid( cp_book fa_distribution_history.book_type_code%TYPE,
1110: cp_asset_id fa_distribution_history.asset_id%TYPE,
1111: cp_distribution_id fa_distribution_history.distribution_id%TYPE) IS
1112: SELECT code_combination_id
1113: FROM fa_distribution_history

Line 1110: cp_asset_id fa_distribution_history.asset_id%TYPE,

1106: AND category_id = cp_category_id;
1107:
1108: /* Cursor to fetch the distribution ccid for a distribution */
1109: CURSOR c_get_dist_ccid( cp_book fa_distribution_history.book_type_code%TYPE,
1110: cp_asset_id fa_distribution_history.asset_id%TYPE,
1111: cp_distribution_id fa_distribution_history.distribution_id%TYPE) IS
1112: SELECT code_combination_id
1113: FROM fa_distribution_history
1114: WHERE book_type_code = cp_book

Line 1111: cp_distribution_id fa_distribution_history.distribution_id%TYPE) IS

1107:
1108: /* Cursor to fetch the distribution ccid for a distribution */
1109: CURSOR c_get_dist_ccid( cp_book fa_distribution_history.book_type_code%TYPE,
1110: cp_asset_id fa_distribution_history.asset_id%TYPE,
1111: cp_distribution_id fa_distribution_history.distribution_id%TYPE) IS
1112: SELECT code_combination_id
1113: FROM fa_distribution_history
1114: WHERE book_type_code = cp_book
1115: AND asset_id = cp_asset_id

Line 1113: FROM fa_distribution_history

1109: CURSOR c_get_dist_ccid( cp_book fa_distribution_history.book_type_code%TYPE,
1110: cp_asset_id fa_distribution_history.asset_id%TYPE,
1111: cp_distribution_id fa_distribution_history.distribution_id%TYPE) IS
1112: SELECT code_combination_id
1113: FROM fa_distribution_history
1114: WHERE book_type_code = cp_book
1115: AND asset_id = cp_asset_id
1116: AND distribution_id = cp_distribution_id;
1117: