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 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;

Line 2926: FROM bom_departments

2922: AND operation_seq_num = p_op_seq_num;
2923:
2924: CURSOR dept_cur IS
2925: SELECT department_id
2926: FROM bom_departments
2927: WHERE organization_id = l_organization_id
2928: AND nvl(disable_date, sysdate + 2) > sysdate
2929: AND department_code = p_department_code;
2930:

Line 3348: FROM bom_departments bdp, bom_standard_operations bso

3344:
3345: CURSOR op_det IS
3346: SELECT bdp.department_id, nvl(bso.count_point_type, 1) count_point_type,
3347: bso.backflush_flag, nvl(bso.minimum_transfer_quantity, 0) minimum_transfer_quantity
3348: FROM bom_departments bdp, bom_standard_operations bso
3349: WHERE bso.organization_id = p_organization_id
3350: AND bso.line_id is null
3351: AND nvl(bso.operation_type,1) = 1
3352: AND bdp.organization_id = p_organization_id