DBA Data[Home] [Help]

APPS.POR_AUTOSOURCE_UTIL_PKG dependencies on MRP_ITEM_SOURCING_LEVELS_V

Line 245: FROM MRP_ITEM_SOURCING_LEVELS_V

241: FROM
242: (
243: SELECT SOURCE_ORGANIZATION_ID, SOURCE_TYPE, VENDOR_ID, VENDOR_SITE_ID,
244: RANK, ALLOCATION_PERCENT, SOURCING_LEVEL
245: FROM MRP_ITEM_SOURCING_LEVELS_V
246: WHERE INVENTORY_ITEM_ID = p_item_id
247: AND ORGANIZATION_ID = p_dest_organization_id
248: AND ASSIGNMENT_SET_ID = l_set_id
249: AND (SOURCE_TYPE = 1 OR