DBA Data[Home] [Help]

APPS.INV_RCV_STD_RCPT_APIS dependencies on MTL_ITEM_CATEGORIES

Line 425: FROM mtl_item_categories

421: IF l_rcv_transaction_rec.item_category_id IS NULL THEN
422: BEGIN
423: SELECT MAX(category_id)
424: INTO l_rcv_transaction_rec.item_category_id
425: FROM mtl_item_categories
426: WHERE inventory_item_id = l_rcv_transaction_rec.item_id
427: AND organization_id = p_organization_id
428: AND category_set_id = inv_rcv_common_apis.g_po_startup_value.category_set_id;
429: EXCEPTION