DBA Data[Home] [Help]

APPS.BOM_DEPARTMENTS_PKG dependencies on BOM_DEPARTMENT_RESOURCES

Line 365: SELECT COUNT(RESOURCE_ID) INTO resources_exist FROM BOM_DEPARTMENT_RESOURCES

361: FUNCTION Resources_OSP_POReceipt(X_Department_Id NUMBER,
362: X_Organization_Id NUMBER) RETURN NUMBER IS
363: resources_exist NUMBER;
364: BEGIN
365: SELECT COUNT(RESOURCE_ID) INTO resources_exist FROM BOM_DEPARTMENT_RESOURCES
366: WHERE DEPARTMENT_ID = X_Department_Id
367: AND RESOURCE_ID IN
368: (SELECT RESOURCE_ID FROM BOM_RESOURCES
369: WHERE COST_CODE_TYPE = 4