APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on BOM_RESOURCES

Line 2917: FROM bom_resources_val_v

2913: AND department_code = p_department_code;
2914:
2915: CURSOR res_cur IS
2916: SELECT resource_id
2917: FROM bom_resources_val_v
2918: WHERE organization_id = l_organization_id
2919: AND resource_code = p_resource_code;
2920:
2921: CURSOR res_seq_cur IS

Line 3526: FROM bom_std_op_resources bsor, bom_resources br

3522: SELECT bsor.resource_seq_num, bsor.resource_id, bsor.activity_id,
3523: bsor.assigned_units, bsor.basis_type, bsor.schedule_flag,
3524: bsor.standard_rate_flag, bsor.usage_rate_or_amount,
3525: bsor.autocharge_type, br.unit_of_measure
3526: FROM bom_std_op_resources bsor, bom_resources br
3527: WHERE bsor.resource_id = br.resource_id
3528: AND bsor.standard_operation_id = p_operation_id;
3529:
3530:

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