DBA Data[Home] [Help]

APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on BOM_DEPARTMENT_RESOURCES

Line 3536: FROM bom_resources res, bom_department_resources bdr

3532: SELECT res.unit_of_measure, nvl(res.default_basis_type,1) basis_type,
3533: 2 "scheduled_flag", res.default_activity_id,
3534: nvl(res.autocharge_type, 1) autocharge_type,
3535: nvl(res.standard_rate_flag,1) standard_rate_flag
3536: FROM bom_resources res, bom_department_resources bdr
3537: WHERE res.organization_id = p_organization_id
3538: AND nvl(res.disable_date, sysdate + 2) > sysdate
3539: AND res.resource_id = bdr.resource_id
3540: AND bdr.department_id = p_department_id