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_ADJUSTMENTS

Line 181: IGI_IAC_ADJUSTMENTS AJ

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
185: AJ.Book_Type_Code = p_Book AND

Line 232: IGI_IAC_ADJUSTMENTS AJ

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
236: AJ.Book_Type_Code = p_Book AND

Line 321: IGI_IAC_ADJUSTMENTS AJ

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
325: AJ.Book_Type_Code = p_Book AND

Line 365: IGI_IAC_ADJUSTMENTS AJ,

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
369: AJ.Asset_ID = DH.Asset_ID AND

Line 366: IGI_IAC_ADJUSTMENTS SUB_AJ

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

Line 382: FROM igi_iac_adjustments x_aj

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

Line 423: IGI_IAC_ADJUSTMENTS AJ

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
427: AJ.Book_Type_Code = p_Book AND