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_IGIIAOPD_XMLP_PKG dependencies on IGI_IAC_ADJUSTMENTS

Line 178: IGI_IAC_ADJUSTMENTS AJ

174: 2
175: FROM
176: FA_DISTRIBUTION_HISTORY DH,
177: IGI_IAC_TRANSACTION_HEADERS TH,
178: IGI_IAC_ADJUSTMENTS AJ
179: WHERE
180: DH.Book_Type_Code = p_Distribution_Source_Book AND
181: AJ.Asset_ID = DH.Asset_ID AND
182: AJ.Book_Type_Code = p_Book AND

Line 229: IGI_IAC_ADJUSTMENTS AJ

225: 2
226: FROM
227: FA_DISTRIBUTION_HISTORY DH,
228: IGI_IAC_TRANSACTION_HEADERS TH,
229: IGI_IAC_ADJUSTMENTS AJ
230: WHERE
231: DH.Book_Type_Code = p_Distribution_Source_Book AND
232: AJ.Asset_ID = DH.Asset_ID AND
233: AJ.Book_Type_Code = p_Book AND

Line 318: IGI_IAC_ADJUSTMENTS AJ

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

Line 362: IGI_IAC_ADJUSTMENTS AJ,

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

Line 363: IGI_IAC_ADJUSTMENTS SUB_AJ

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

Line 379: FROM igi_iac_adjustments x_aj

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

Line 420: IGI_IAC_ADJUSTMENTS AJ

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