DBA Data[Home] [Help]

APPS.IGI_IGIIAOPE_XMLP_PKG dependencies on IGI_IAC_ADJUSTMENTS

Line 164: IGI_IAC_ADJUSTMENTS AJ

160: 2
161: FROM
162: FA_DISTRIBUTION_HISTORY DH,
163: IGI_IAC_TRANSACTION_HEADERS TH,
164: IGI_IAC_ADJUSTMENTS AJ
165: WHERE
166: DH.Book_Type_Code = p_Distribution_Source_Book AND
167: AJ.Asset_ID = DH.Asset_ID AND
168: AJ.Book_Type_Code = p_Book AND

Line 215: IGI_IAC_ADJUSTMENTS AJ

211: 2
212: FROM
213: FA_DISTRIBUTION_HISTORY DH,
214: IGI_IAC_TRANSACTION_HEADERS TH,
215: IGI_IAC_ADJUSTMENTS AJ
216: WHERE
217: DH.Book_Type_Code = p_Distribution_Source_Book AND
218: AJ.Asset_ID = DH.Asset_ID AND
219: AJ.Book_Type_Code = p_Book AND

Line 304: IGI_IAC_ADJUSTMENTS AJ

300: l_display_order
301: FROM
302: FA_DISTRIBUTION_HISTORY DH,
303: IGI_IAC_TRANSACTION_HEADERS TH,
304: IGI_IAC_ADJUSTMENTS AJ
305: WHERE
306: DH.Book_Type_Code = p_Distribution_Source_Book AND
307: AJ.Asset_ID = DH.Asset_ID AND
308: AJ.Book_Type_Code = p_Book AND

Line 348: IGI_IAC_ADJUSTMENTS AJ,

344: l_display_order
345: FROM
346: FA_DISTRIBUTION_HISTORY DH,
347: IGI_IAC_TRANSACTION_HEADERS TH,
348: IGI_IAC_ADJUSTMENTS AJ,
349: IGI_IAC_ADJUSTMENTS SUB_AJ
350: WHERE
351: DH.Book_Type_Code = p_Distribution_Source_Book AND
352: AJ.Asset_ID = DH.Asset_ID AND

Line 349: IGI_IAC_ADJUSTMENTS SUB_AJ

345: FROM
346: FA_DISTRIBUTION_HISTORY DH,
347: IGI_IAC_TRANSACTION_HEADERS TH,
348: IGI_IAC_ADJUSTMENTS AJ,
349: IGI_IAC_ADJUSTMENTS SUB_AJ
350: WHERE
351: DH.Book_Type_Code = p_Distribution_Source_Book AND
352: AJ.Asset_ID = DH.Asset_ID AND
353: AJ.Book_Type_Code = p_Book AND

Line 365: FROM igi_iac_adjustments x_aj

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

Line 406: IGI_IAC_ADJUSTMENTS AJ

402: l_display_order
403: FROM
404: FA_DISTRIBUTION_HISTORY DH,
405: IGI_IAC_TRANSACTION_HEADERS TH,
406: IGI_IAC_ADJUSTMENTS AJ
407: WHERE
408: DH.Book_Type_Code = p_Distribution_Source_Book AND
409: AJ.Asset_ID = DH.Asset_ID AND
410: AJ.Book_Type_Code = p_Book AND