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

Line 183: IGI_IAC_ADJUSTMENTS AJ

179: 2
180: FROM
181: FA_DISTRIBUTION_HISTORY DH,
182: IGI_IAC_TRANSACTION_HEADERS TH,
183: IGI_IAC_ADJUSTMENTS AJ
184: WHERE
185: DH.Book_Type_Code = p_Distribution_Source_Book AND
186: AJ.Asset_ID = DH.Asset_ID AND
187: AJ.Book_Type_Code = p_Book AND

Line 234: IGI_IAC_ADJUSTMENTS AJ

230: 2
231: FROM
232: FA_DISTRIBUTION_HISTORY DH,
233: IGI_IAC_TRANSACTION_HEADERS TH,
234: IGI_IAC_ADJUSTMENTS AJ
235: WHERE
236: DH.Book_Type_Code = p_Distribution_Source_Book AND
237: AJ.Asset_ID = DH.Asset_ID AND
238: AJ.Book_Type_Code = p_Book AND

Line 323: IGI_IAC_ADJUSTMENTS AJ

319: l_display_order
320: FROM
321: FA_DISTRIBUTION_HISTORY DH,
322: IGI_IAC_TRANSACTION_HEADERS TH,
323: IGI_IAC_ADJUSTMENTS AJ
324: WHERE
325: DH.Book_Type_Code = p_Distribution_Source_Book AND
326: AJ.Asset_ID = DH.Asset_ID AND
327: AJ.Book_Type_Code = p_Book AND

Line 367: IGI_IAC_ADJUSTMENTS AJ,

363: l_display_order
364: FROM
365: FA_DISTRIBUTION_HISTORY DH,
366: IGI_IAC_TRANSACTION_HEADERS TH,
367: IGI_IAC_ADJUSTMENTS AJ,
368: IGI_IAC_ADJUSTMENTS SUB_AJ
369: WHERE
370: DH.Book_Type_Code = p_Distribution_Source_Book AND
371: AJ.Asset_ID = DH.Asset_ID AND

Line 368: IGI_IAC_ADJUSTMENTS SUB_AJ

364: FROM
365: FA_DISTRIBUTION_HISTORY DH,
366: IGI_IAC_TRANSACTION_HEADERS TH,
367: IGI_IAC_ADJUSTMENTS AJ,
368: IGI_IAC_ADJUSTMENTS SUB_AJ
369: WHERE
370: DH.Book_Type_Code = p_Distribution_Source_Book AND
371: AJ.Asset_ID = DH.Asset_ID AND
372: AJ.Book_Type_Code = p_Book AND

Line 384: FROM igi_iac_adjustments x_aj

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

Line 425: IGI_IAC_ADJUSTMENTS AJ

421: l_display_order
422: FROM
423: FA_DISTRIBUTION_HISTORY DH,
424: IGI_IAC_TRANSACTION_HEADERS TH,
425: IGI_IAC_ADJUSTMENTS AJ
426: WHERE
427: DH.Book_Type_Code = p_Distribution_Source_Book AND
428: AJ.Asset_ID = DH.Asset_ID AND
429: AJ.Book_Type_Code = p_Book AND