DBA Data[Home] [Help]

APPS.RCV_RMA_TRANSACTIONS dependencies on MTL_ITEM_CATEGORIES

Line 2032: FROM mtl_item_categories

2028: -- get the category_id for this item, org, and category_set
2029: -- based on RCV_RECEIPTS_EH.event('POST-QUERY')
2030: SELECT MAX(category_id)
2031: INTO x_cascaded_table(n).category_id
2032: FROM mtl_item_categories
2033: WHERE inventory_item_id = x_cascaded_table(n).item_id
2034: AND organization_id = x_cascaded_table(n).to_organization_id
2035: AND category_set_id = l_category_set_id;
2036: