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

Line 161: IGI_IAC_TRANSACTION_HEADERS TH,

157: 'IAC',
158: 2
159: FROM
160: FA_DISTRIBUTION_HISTORY DH,
161: IGI_IAC_TRANSACTION_HEADERS TH,
162: IGI_IAC_ADJUSTMENTS AJ
163: WHERE
164: DH.Book_Type_Code = p_Distribution_Source_Book AND
165: AJ.Asset_ID = DH.Asset_ID AND

Line 212: IGI_IAC_TRANSACTION_HEADERS TH,

208: 'IAC',
209: 2
210: FROM
211: FA_DISTRIBUTION_HISTORY DH,
212: IGI_IAC_TRANSACTION_HEADERS TH,
213: IGI_IAC_ADJUSTMENTS AJ
214: WHERE
215: DH.Book_Type_Code = p_Distribution_Source_Book AND
216: AJ.Asset_ID = DH.Asset_ID AND

Line 301: IGI_IAC_TRANSACTION_HEADERS TH,

297: l_data_source,
298: l_display_order
299: FROM
300: FA_DISTRIBUTION_HISTORY DH,
301: IGI_IAC_TRANSACTION_HEADERS TH,
302: IGI_IAC_ADJUSTMENTS AJ
303: WHERE
304: DH.Book_Type_Code = p_Distribution_Source_Book AND
305: AJ.Asset_ID = DH.Asset_ID AND

Line 345: IGI_IAC_TRANSACTION_HEADERS TH,

341: l_data_source,
342: l_display_order
343: FROM
344: FA_DISTRIBUTION_HISTORY DH,
345: IGI_IAC_TRANSACTION_HEADERS TH,
346: IGI_IAC_ADJUSTMENTS AJ,
347: IGI_IAC_ADJUSTMENTS SUB_AJ
348: WHERE
349: DH.Book_Type_Code = p_Distribution_Source_Book AND

Line 403: IGI_IAC_TRANSACTION_HEADERS TH,

399: l_data_source,
400: l_display_order
401: FROM
402: FA_DISTRIBUTION_HISTORY DH,
403: IGI_IAC_TRANSACTION_HEADERS TH,
404: IGI_IAC_ADJUSTMENTS AJ
405: WHERE
406: DH.Book_Type_Code = p_Distribution_Source_Book AND
407: AJ.Asset_ID = DH.Asset_ID AND

Line 659: IGI_IAC_TRANSACTION_HEADERS ITH

655: FA_ASSET_HISTORY AH,
656: FA_CATEGORY_BOOKS CB,
657: IGI_IAC_CATEGORY_BOOKS ICB,
658: FA_BOOKS BK,
659: IGI_IAC_TRANSACTION_HEADERS ITH
660: WHERE
661: DH.Book_Type_Code = p_Distribution_Source_Book AND
662: DD.Asset_ID = DH.Asset_ID AND
663: DD.Book_Type_Code = p_Book AND

Line 668: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH

664: DD.Distribution_ID = DH.Distribution_ID AND
665: DD.Period_Counter <= p_Period_PC AND
666: DD.adjustment_id =
667: (SELECT MAX (SUB_TH.adjustment_id)
668: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH
669: WHERE SUB_TH.Book_Type_Code = p_Book AND
670: SUB_TH.Asset_ID = DH.Asset_ID AND
671: SUB_TH.Period_Counter <= p_Period_PC AND
672: SUB_TH.adjustment_status NOT IN ('PREVIEW','OBSOLETE')) AND

Line 781: IGI_IAC_TRANSACTION_HEADERS ITH

777: FA_ASSET_HISTORY AH,
778: FA_CATEGORY_BOOKS CB,
779: IGI_IAC_CATEGORY_BOOKS ICB,
780: FA_BOOKS BK,
781: IGI_IAC_TRANSACTION_HEADERS ITH
782: WHERE
783: DH.Book_Type_Code = p_Distribution_Source_Book AND
784: DD.Asset_ID = DH.Asset_ID AND
785: DD.Book_Type_Code = p_Book AND

Line 790: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH

786: DD.Distribution_ID = DH.Distribution_ID AND
787: DD.Period_Counter <= p_Period_PC AND
788: DD.adjustment_id =
789: (SELECT MAX (SUB_TH.adjustment_id)
790: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH
791: WHERE SUB_TH.Book_Type_Code = p_Book AND
792: SUB_TH.Asset_ID = DH.Asset_ID AND
793: SUB_TH.Period_Counter <= p_Period_PC AND
794: SUB_TH.adjustment_status NOT IN ('PREVIEW','OBSOLETE')) AND

Line 973: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

969: p_period2_pc number,
970: p_report_type varchar2,
971: p_balance_type varchar2)
972: IS
973: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
974: l_distribution_ccid fa_distribution_history.code_combination_id%TYPE;
975:
976: /* Cursor for fetching all retirement, reinstatement transactions */
977: CURSOR c_get_transactions(cp_book fa_books.book_type_code%TYPE) IS

Line 979: FROM igi_iac_transaction_headers

975:
976: /* Cursor for fetching all retirement, reinstatement transactions */
977: CURSOR c_get_transactions(cp_book fa_books.book_type_code%TYPE) IS
978: SELECT *
979: FROM igi_iac_transaction_headers
980: WHERE book_type_code = cp_book
981: AND period_counter BETWEEN p_period1_pc AND p_period2_pc
982: AND transaction_type_code IN ('PARTIAL RETIRE', 'FULL RETIREMENT', 'REINSTATEMENT');
983:

Line 986: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

982: AND transaction_type_code IN ('PARTIAL RETIRE', 'FULL RETIREMENT', 'REINSTATEMENT');
983:
984: /* Cursor for fetching the transaction previous to retirement or reinstatement */
985: CURSOR c_get_Prev_transaction(cp_book fa_books.book_type_code%TYPE,
986: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
987: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
988: SELECT max(adjustment_id)
989: FROM igi_iac_transaction_headers
990: WHERE book_type_code = cp_book

Line 987: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

983:
984: /* Cursor for fetching the transaction previous to retirement or reinstatement */
985: CURSOR c_get_Prev_transaction(cp_book fa_books.book_type_code%TYPE,
986: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
987: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
988: SELECT max(adjustment_id)
989: FROM igi_iac_transaction_headers
990: WHERE book_type_code = cp_book
991: AND asset_id = cp_asset_id

Line 989: FROM igi_iac_transaction_headers

985: CURSOR c_get_Prev_transaction(cp_book fa_books.book_type_code%TYPE,
986: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
987: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
988: SELECT max(adjustment_id)
989: FROM igi_iac_transaction_headers
990: WHERE book_type_code = cp_book
991: AND asset_id = cp_asset_id
992: AND adjustment_id < cp_adjustment_id
993: AND adjustment_status NOT IN ('PREVIEW','OBSOLETE');

Line 999: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

995: /* Cursor to fetch the general fund movement from previous transaction
996: to current transaction for the distributions which exist in both
997: transactions */
998: CURSOR c_get_dists(cp_book fa_books.book_type_code%TYPE,
999: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1000: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1001: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1002: SELECT curr_adj.distribution_id distribution_id,
1003: (curr_adj.reval_reserve_cost - prev_adj.reval_reserve_cost) reval_reserve_cost,

Line 1000: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,

996: to current transaction for the distributions which exist in both
997: transactions */
998: CURSOR c_get_dists(cp_book fa_books.book_type_code%TYPE,
999: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1000: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1001: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1002: SELECT curr_adj.distribution_id distribution_id,
1003: (curr_adj.reval_reserve_cost - prev_adj.reval_reserve_cost) reval_reserve_cost,
1004: (curr_adj.reval_reserve_backlog - prev_adj.reval_reserve_backlog) reval_reserve_backlog,

Line 1001: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

997: transactions */
998: CURSOR c_get_dists(cp_book fa_books.book_type_code%TYPE,
999: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1000: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1001: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1002: SELECT curr_adj.distribution_id distribution_id,
1003: (curr_adj.reval_reserve_cost - prev_adj.reval_reserve_cost) reval_reserve_cost,
1004: (curr_adj.reval_reserve_backlog - prev_adj.reval_reserve_backlog) reval_reserve_backlog,
1005: (curr_adj.general_fund_acc - prev_adj.general_fund_acc) general_fund,

Line 1022: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

1018: /* Cursor to fetch the general fund movement from previous transaction
1019: to current transaction for the distributions which exist only in the
1020: latest transaction */
1021: CURSOR c_get_new_dists(cp_book fa_books.book_type_code%TYPE,
1022: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1023: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1024: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1025: SELECT adj.distribution_id,
1026: adj.reval_reserve_cost reval_reserve_cost,

Line 1023: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,

1019: to current transaction for the distributions which exist only in the
1020: latest transaction */
1021: CURSOR c_get_new_dists(cp_book fa_books.book_type_code%TYPE,
1022: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1023: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1024: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1025: SELECT adj.distribution_id,
1026: adj.reval_reserve_cost reval_reserve_cost,
1027: adj.reval_reserve_backlog reval_reserve_backlog,

Line 1024: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

1020: latest transaction */
1021: CURSOR c_get_new_dists(cp_book fa_books.book_type_code%TYPE,
1022: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1023: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1024: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1025: SELECT adj.distribution_id,
1026: adj.reval_reserve_cost reval_reserve_cost,
1027: adj.reval_reserve_backlog reval_reserve_backlog,
1028: adj.general_fund_acc general_fund,

Line 1046: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

1042: /* Cursor to fetch the general fund movement from previous transaction
1043: to current transaction for the distributions which exist only in the
1044: previous transaction */
1045: CURSOR c_get_old_dists(cp_book fa_books.book_type_code%TYPE,
1046: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1047: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1048: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1049: SELECT adj.distribution_id,
1050: (adj.reval_reserve_cost * -1) reval_reserve_cost,

Line 1047: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,

1043: to current transaction for the distributions which exist only in the
1044: previous transaction */
1045: CURSOR c_get_old_dists(cp_book fa_books.book_type_code%TYPE,
1046: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1047: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1048: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1049: SELECT adj.distribution_id,
1050: (adj.reval_reserve_cost * -1) reval_reserve_cost,
1051: (adj.reval_reserve_backlog * -1) reval_reserve_backlog,

Line 1048: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

1044: previous transaction */
1045: CURSOR c_get_old_dists(cp_book fa_books.book_type_code%TYPE,
1046: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1047: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1048: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1049: SELECT adj.distribution_id,
1050: (adj.reval_reserve_cost * -1) reval_reserve_cost,
1051: (adj.reval_reserve_backlog * -1) reval_reserve_backlog,
1052: (adj.general_fund_acc * -1) general_fund,

Line 1069: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS

1065:
1066: /* Cursor to fetch the category for the asset */
1067: CURSOR c_get_category(cp_book fa_books.book_type_code%TYPE,
1068: cp_asset_id fa_additions.asset_id%TYPE,
1069: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS
1070: SELECT ah.category_id
1071: FROM fa_asset_history ah,
1072: fa_transaction_headers th
1073: WHERE ah.asset_id = cp_asset_id