DBA Data[Home] [Help]

APPS.INV_RCV_STD_RCPT_APIS dependencies on MTL_ITEM_CATEGORIES

Line 423: FROM mtl_item_categories

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