eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on BOM_DEPARTMENTS

Line 2896: FROM bom_standard_operations_all_v bsoav, bom_departments_val_v bdvv

2892: AND organization_id = l_organization_id;
2893:
2894: CURSOR op_cur IS
2895: SELECT bsoav.standard_operation_id
2896: FROM bom_standard_operations_all_v bsoav, bom_departments_val_v bdvv
2897: WHERE bsoav.organization_id = l_organization_id
2898: AND bsoav.department_id = bdvv.department_id
2899: AND NVL (bsoav.operation_type, 1) = 1
2900: AND bsoav.operation_code = p_operation_code;

Line 2910: FROM bom_departments

2906: AND operation_seq_num = p_op_seq_num;
2907:
2908: CURSOR dept_cur IS
2909: SELECT department_id
2910: FROM bom_departments
2911: WHERE organization_id = l_organization_id
2912: AND nvl(disable_date, sysdate + 2) > sysdate
2913: AND department_code = p_department_code;
2914:

Line 3332: FROM bom_departments bdp, bom_standard_operations bso

3328:
3329: CURSOR op_det IS
3330: SELECT bdp.department_id, nvl(bso.count_point_type, 1) count_point_type,
3331: bso.backflush_flag, nvl(bso.minimum_transfer_quantity, 0) minimum_transfer_quantity
3332: FROM bom_departments bdp, bom_standard_operations bso
3333: WHERE bso.organization_id = p_organization_id
3334: AND bso.line_id is null
3335: AND nvl(bso.operation_type,1) = 1
3336: AND bdp.organization_id = p_organization_id