DBA Data[Home] [Help]

APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on BOM_DEPARTMENT_RESOURCES

Line 3552: FROM bom_resources res, bom_department_resources bdr

3548: SELECT res.unit_of_measure, nvl(res.default_basis_type,1) basis_type,
3549: 2 "scheduled_flag", res.default_activity_id,
3550: nvl(res.autocharge_type, 1) autocharge_type,
3551: nvl(res.standard_rate_flag,1) standard_rate_flag
3552: FROM bom_resources res, bom_department_resources bdr
3553: WHERE res.organization_id = p_organization_id
3554: AND nvl(res.disable_date, sysdate + 2) > sysdate
3555: AND res.resource_id = bdr.resource_id
3556: AND bdr.department_id = p_department_id