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_IGIIABLD_XMLP_PKG dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 180: IGI_IAC_TRANSACTION_HEADERS TH,

176: 'IAC',
177: 2
178: FROM
179: FA_DISTRIBUTION_HISTORY DH,
180: IGI_IAC_TRANSACTION_HEADERS TH,
181: IGI_IAC_ADJUSTMENTS AJ
182: WHERE
183: DH.Book_Type_Code = p_Distribution_Source_Book AND
184: AJ.Asset_ID = DH.Asset_ID AND

Line 231: IGI_IAC_TRANSACTION_HEADERS TH,

227: 'IAC',
228: 2
229: FROM
230: FA_DISTRIBUTION_HISTORY DH,
231: IGI_IAC_TRANSACTION_HEADERS TH,
232: IGI_IAC_ADJUSTMENTS AJ
233: WHERE
234: DH.Book_Type_Code = p_Distribution_Source_Book AND
235: AJ.Asset_ID = DH.Asset_ID AND

Line 320: IGI_IAC_TRANSACTION_HEADERS TH,

316: l_data_source,
317: l_display_order
318: FROM
319: FA_DISTRIBUTION_HISTORY DH,
320: IGI_IAC_TRANSACTION_HEADERS TH,
321: IGI_IAC_ADJUSTMENTS AJ
322: WHERE
323: DH.Book_Type_Code = p_Distribution_Source_Book AND
324: AJ.Asset_ID = DH.Asset_ID AND

Line 364: IGI_IAC_TRANSACTION_HEADERS TH,

360: l_data_source,
361: l_display_order
362: FROM
363: FA_DISTRIBUTION_HISTORY DH,
364: IGI_IAC_TRANSACTION_HEADERS TH,
365: IGI_IAC_ADJUSTMENTS AJ,
366: IGI_IAC_ADJUSTMENTS SUB_AJ
367: WHERE
368: DH.Book_Type_Code = p_Distribution_Source_Book AND

Line 422: IGI_IAC_TRANSACTION_HEADERS TH,

418: l_data_source,
419: l_display_order
420: FROM
421: FA_DISTRIBUTION_HISTORY DH,
422: IGI_IAC_TRANSACTION_HEADERS TH,
423: IGI_IAC_ADJUSTMENTS AJ
424: WHERE
425: DH.Book_Type_Code = p_Distribution_Source_Book AND
426: AJ.Asset_ID = DH.Asset_ID AND

Line 678: IGI_IAC_TRANSACTION_HEADERS ITH

674: FA_ASSET_HISTORY AH,
675: FA_CATEGORY_BOOKS CB,
676: IGI_IAC_CATEGORY_BOOKS ICB,
677: FA_BOOKS BK,
678: IGI_IAC_TRANSACTION_HEADERS ITH
679: WHERE
680: DH.Book_Type_Code = p_Distribution_Source_Book AND
681: DD.Asset_ID = DH.Asset_ID AND
682: DD.Book_Type_Code = p_Book AND

Line 687: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH

683: DD.Distribution_ID = DH.Distribution_ID AND
684: DD.Period_Counter <= p_Period_PC AND
685: DD.adjustment_id =
686: (SELECT MAX (SUB_TH.adjustment_id)
687: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH
688: WHERE SUB_TH.Book_Type_Code = p_Book AND
689: SUB_TH.Asset_ID = DH.Asset_ID AND
690: SUB_TH.Period_Counter <= p_Period_PC AND
691: SUB_TH.adjustment_status NOT IN ('PREVIEW','OBSOLETE')) AND

Line 800: IGI_IAC_TRANSACTION_HEADERS ITH

796: FA_ASSET_HISTORY AH,
797: FA_CATEGORY_BOOKS CB,
798: IGI_IAC_CATEGORY_BOOKS ICB,
799: FA_BOOKS BK,
800: IGI_IAC_TRANSACTION_HEADERS ITH
801: WHERE
802: DH.Book_Type_Code = p_Distribution_Source_Book AND
803: DD.Asset_ID = DH.Asset_ID AND
804: DD.Book_Type_Code = p_Book AND

Line 809: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH

805: DD.Distribution_ID = DH.Distribution_ID AND
806: DD.Period_Counter <= p_Period_PC AND
807: DD.adjustment_id =
808: (SELECT MAX (SUB_TH.adjustment_id)
809: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH
810: WHERE SUB_TH.Book_Type_Code = p_Book AND
811: SUB_TH.Asset_ID = DH.Asset_ID AND
812: SUB_TH.Period_Counter <= p_Period_PC AND
813: SUB_TH.adjustment_status NOT IN ('PREVIEW','OBSOLETE')) AND

Line 992: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

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

Line 998: FROM igi_iac_transaction_headers

994:
995: /* Cursor for fetching all retirement, reinstatement transactions */
996: CURSOR c_get_transactions(cp_book fa_books.book_type_code%TYPE) IS
997: SELECT *
998: FROM igi_iac_transaction_headers
999: WHERE book_type_code = cp_book
1000: AND period_counter BETWEEN p_period1_pc AND p_period2_pc
1001: AND transaction_type_code IN ('PARTIAL RETIRE', 'FULL RETIREMENT', 'REINSTATEMENT');
1002:

Line 1005: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

1001: AND transaction_type_code IN ('PARTIAL RETIRE', 'FULL RETIREMENT', 'REINSTATEMENT');
1002:
1003: /* Cursor for fetching the transaction previous to retirement or reinstatement */
1004: CURSOR c_get_Prev_transaction(cp_book fa_books.book_type_code%TYPE,
1005: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1006: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1007: SELECT max(adjustment_id)
1008: FROM igi_iac_transaction_headers
1009: WHERE book_type_code = cp_book

Line 1006: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

1002:
1003: /* Cursor for fetching the transaction previous to retirement or reinstatement */
1004: CURSOR c_get_Prev_transaction(cp_book fa_books.book_type_code%TYPE,
1005: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1006: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1007: SELECT max(adjustment_id)
1008: FROM igi_iac_transaction_headers
1009: WHERE book_type_code = cp_book
1010: AND asset_id = cp_asset_id

Line 1008: FROM igi_iac_transaction_headers

1004: CURSOR c_get_Prev_transaction(cp_book fa_books.book_type_code%TYPE,
1005: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1006: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1007: SELECT max(adjustment_id)
1008: FROM igi_iac_transaction_headers
1009: WHERE book_type_code = cp_book
1010: AND asset_id = cp_asset_id
1011: AND adjustment_id < cp_adjustment_id
1012: AND adjustment_status NOT IN ('PREVIEW','OBSOLETE');

Line 1018: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

1014: /* Cursor to fetch the general fund movement from previous transaction
1015: to current transaction for the distributions which exist in both
1016: transactions */
1017: CURSOR c_get_dists(cp_book fa_books.book_type_code%TYPE,
1018: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1019: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1020: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1021: SELECT curr_adj.distribution_id distribution_id,
1022: (curr_adj.reval_reserve_cost - prev_adj.reval_reserve_cost) reval_reserve_cost,

Line 1019: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,

1015: to current transaction for the distributions which exist in both
1016: transactions */
1017: CURSOR c_get_dists(cp_book fa_books.book_type_code%TYPE,
1018: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1019: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1020: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1021: SELECT curr_adj.distribution_id distribution_id,
1022: (curr_adj.reval_reserve_cost - prev_adj.reval_reserve_cost) reval_reserve_cost,
1023: (curr_adj.reval_reserve_backlog - prev_adj.reval_reserve_backlog) reval_reserve_backlog,

Line 1020: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

1016: transactions */
1017: CURSOR c_get_dists(cp_book fa_books.book_type_code%TYPE,
1018: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1019: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1020: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1021: SELECT curr_adj.distribution_id distribution_id,
1022: (curr_adj.reval_reserve_cost - prev_adj.reval_reserve_cost) reval_reserve_cost,
1023: (curr_adj.reval_reserve_backlog - prev_adj.reval_reserve_backlog) reval_reserve_backlog,
1024: (curr_adj.general_fund_acc - prev_adj.general_fund_acc) general_fund,

Line 1041: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

1037: /* Cursor to fetch the general fund movement from previous transaction
1038: to current transaction for the distributions which exist only in the
1039: latest transaction */
1040: CURSOR c_get_new_dists(cp_book fa_books.book_type_code%TYPE,
1041: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1042: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1043: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1044: SELECT adj.distribution_id,
1045: adj.reval_reserve_cost reval_reserve_cost,

Line 1042: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,

1038: to current transaction for the distributions which exist only in the
1039: latest transaction */
1040: CURSOR c_get_new_dists(cp_book fa_books.book_type_code%TYPE,
1041: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1042: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1043: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1044: SELECT adj.distribution_id,
1045: adj.reval_reserve_cost reval_reserve_cost,
1046: adj.reval_reserve_backlog reval_reserve_backlog,

Line 1043: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

1039: latest transaction */
1040: CURSOR c_get_new_dists(cp_book fa_books.book_type_code%TYPE,
1041: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1042: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1043: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1044: SELECT adj.distribution_id,
1045: adj.reval_reserve_cost reval_reserve_cost,
1046: adj.reval_reserve_backlog reval_reserve_backlog,
1047: adj.general_fund_acc general_fund,

Line 1065: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

1061: /* Cursor to fetch the general fund movement from previous transaction
1062: to current transaction for the distributions which exist only in the
1063: previous transaction */
1064: CURSOR c_get_old_dists(cp_book fa_books.book_type_code%TYPE,
1065: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1066: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1067: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1068: SELECT adj.distribution_id,
1069: (adj.reval_reserve_cost * -1) reval_reserve_cost,

Line 1066: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,

1062: to current transaction for the distributions which exist only in the
1063: previous transaction */
1064: CURSOR c_get_old_dists(cp_book fa_books.book_type_code%TYPE,
1065: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1066: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1067: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1068: SELECT adj.distribution_id,
1069: (adj.reval_reserve_cost * -1) reval_reserve_cost,
1070: (adj.reval_reserve_backlog * -1) reval_reserve_backlog,

Line 1067: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

1063: previous transaction */
1064: CURSOR c_get_old_dists(cp_book fa_books.book_type_code%TYPE,
1065: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1066: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1067: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1068: SELECT adj.distribution_id,
1069: (adj.reval_reserve_cost * -1) reval_reserve_cost,
1070: (adj.reval_reserve_backlog * -1) reval_reserve_backlog,
1071: (adj.general_fund_acc * -1) general_fund,

Line 1088: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS

1084:
1085: /* Cursor to fetch the category for the asset */
1086: CURSOR c_get_category(cp_book fa_books.book_type_code%TYPE,
1087: cp_asset_id fa_additions.asset_id%TYPE,
1088: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS
1089: SELECT ah.category_id
1090: FROM fa_asset_history ah,
1091: fa_transaction_headers th
1092: WHERE ah.asset_id = cp_asset_id