APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on BOM_RESOURCES

Line 2933: FROM bom_resources_val_v

2929: AND department_code = p_department_code;
2930:
2931: CURSOR res_cur IS
2932: SELECT resource_id
2933: FROM bom_resources_val_v
2934: WHERE organization_id = l_organization_id
2935: AND resource_code = p_resource_code;
2936:
2937: CURSOR res_seq_cur IS

Line 3542: FROM bom_std_op_resources bsor, bom_resources br

3538: SELECT bsor.resource_seq_num, bsor.resource_id, bsor.activity_id,
3539: bsor.assigned_units, bsor.basis_type, bsor.schedule_flag,
3540: bsor.standard_rate_flag, bsor.usage_rate_or_amount,
3541: bsor.autocharge_type, br.unit_of_measure
3542: FROM bom_std_op_resources bsor, bom_resources br
3543: WHERE bsor.resource_id = br.resource_id
3544: AND bsor.standard_operation_id = p_operation_id;
3545:
3546:

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