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_ADJUSTMENTS

Line 162: IGI_IAC_ADJUSTMENTS AJ

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

Line 213: IGI_IAC_ADJUSTMENTS AJ

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

Line 302: IGI_IAC_ADJUSTMENTS AJ

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

Line 346: IGI_IAC_ADJUSTMENTS AJ,

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

Line 347: IGI_IAC_ADJUSTMENTS SUB_AJ

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

Line 363: FROM igi_iac_adjustments x_aj

359: AJ.adjustment_id = SUB_AJ.adjustment_id AND
360: AJ.distribution_id = SUB_AJ.distribution_id AND
361: SUB_AJ.adjustment_type = p_report_type AND
362: SUB_AJ.rowid = (select min(x_aj.rowid)
363: FROM igi_iac_adjustments x_aj
364: WHERE x_aj.Book_Type_Code = p_book
365: AND x_aj.adjustment_id = sub_aj.adjustment_id
366: AND x_aj.distribution_id = sub_aj.distribution_id
367: AND x_aj.asset_id = sub_AJ.Asset_ID

Line 404: IGI_IAC_ADJUSTMENTS AJ

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