DBA Data[Home] [Help]

APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on BOM_DEPARTMENTS_VAL_V

Line 2912: FROM bom_standard_operations_all_v bsoav, bom_departments_val_v bdvv

2908: AND organization_id = l_organization_id;
2909:
2910: CURSOR op_cur IS
2911: SELECT bsoav.standard_operation_id
2912: FROM bom_standard_operations_all_v bsoav, bom_departments_val_v bdvv
2913: WHERE bsoav.organization_id = l_organization_id
2914: AND bsoav.department_id = bdvv.department_id
2915: AND NVL (bsoav.operation_type, 1) = 1
2916: AND bsoav.operation_code = p_operation_code;