DBA Data[Home] [Help]

APPS.RCV_RMA_TRANSACTIONS dependencies on MTL_ITEM_CATEGORIES

Line 1998: FROM mtl_item_categories

1994: -- get the category_id for this item, org, and category_set
1995: -- based on RCV_RECEIPTS_EH.event('POST-QUERY')
1996: SELECT MAX(category_id)
1997: INTO x_cascaded_table(n).category_id
1998: FROM mtl_item_categories
1999: WHERE inventory_item_id = x_cascaded_table(n).item_id
2000: AND organization_id = x_cascaded_table(n).to_organization_id
2001: AND category_set_id = l_category_set_id;
2002: