DBA Data[Home] [Help]

APPS.INV_RCV_COMMON_APIS dependencies on MTL_ITEM_SUB_INVENTORIES

Line 3114: FROM mtl_item_sub_inventories mis

3110: INTO l_dummy
3111: FROM DUAL
3112: WHERE EXISTS(
3113: SELECT 1
3114: FROM mtl_item_sub_inventories mis
3115: WHERE mis.organization_id = p_organization_id
3116: AND mis.inventory_item_id = p_item_id
3117: AND mis.secondary_inventory = l_sub
3118: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, l_transaction_type, NULL, NULL, p_organization_id