DBA Data[Home] [Help]

APPS.CN_RAM_ADJUSTMENTS_PKG dependencies on MTL_ITEM_CATEGORIES

Line 202: from mtl_item_categories mic

198: from ra_customer_trx_lines rctl
199: where rctl.customer_trx_id = adj.customer_trx_id and
200: exists
201: (select 1
202: from mtl_item_categories mic
203: where mic.category_id = adj.from_category_id and
204: mic.inventory_item_id = rctl.inventory_item_id)
205: ) r
206: where cnt.not_trx_id = adj.not_trx_id and

Line 227: mtl_item_categories mic

223: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)
224: where trx_line_id in (
225: select ctl.trx_line_id
226: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl,
227: mtl_item_categories mic
228: where cnt.not_trx_id = adj.not_trx_id and
229: ct.not_trx_id = cnt.not_trx_id and
230: ctl.trx_id = ct.trx_id and
231: cnt.source_trx_id = adj.customer_trx_id and