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 IGI_IAC_ADJUSTMENTS

Line 177: IGI_IAC_ADJUSTMENTS AJ

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
180: AJ.Asset_ID = DH.Asset_ID AND
181: AJ.Book_Type_Code = p_Book AND

Line 228: IGI_IAC_ADJUSTMENTS AJ

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
231: AJ.Asset_ID = DH.Asset_ID AND
232: AJ.Book_Type_Code = p_Book AND

Line 317: IGI_IAC_ADJUSTMENTS AJ

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
320: AJ.Asset_ID = DH.Asset_ID AND
321: AJ.Book_Type_Code = p_Book AND

Line 361: IGI_IAC_ADJUSTMENTS AJ,

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
364: DH.Book_Type_Code = p_Distribution_Source_Book AND
365: AJ.Asset_ID = DH.Asset_ID AND

Line 362: IGI_IAC_ADJUSTMENTS SUB_AJ

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
364: DH.Book_Type_Code = p_Distribution_Source_Book AND
365: AJ.Asset_ID = DH.Asset_ID AND
366: AJ.Book_Type_Code = p_Book AND

Line 378: FROM igi_iac_adjustments x_aj

374: AJ.adjustment_id = SUB_AJ.adjustment_id AND
375: AJ.distribution_id = SUB_AJ.distribution_id AND
376: SUB_AJ.adjustment_type = p_report_type AND
377: SUB_AJ.rowid = (select min(x_aj.rowid)
378: FROM igi_iac_adjustments x_aj
379: WHERE x_aj.Book_Type_Code = p_book
380: AND x_aj.adjustment_id = sub_aj.adjustment_id
381: AND x_aj.distribution_id = sub_aj.distribution_id
382: AND x_aj.asset_id = sub_AJ.Asset_ID

Line 419: IGI_IAC_ADJUSTMENTS AJ

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
422: AJ.Asset_ID = DH.Asset_ID AND
423: AJ.Book_Type_Code = p_Book AND