DBA Data[Home] [Help]

APPS.WSM_WLT_VALIDATE_PVT dependencies on BOM_DEPARTMENTS

Line 6902: bom_departments BD

6898: p_new_std_op_id,
6899: p_new_dept_id
6900: FROM bom_standard_operations BSO,
6901: bom_operation_sequences BOS,
6902: bom_departments BD
6903: WHERE BOS.routing_sequence_id = p_new_comm_rtg_seq_id
6904: AND BSO.standard_operation_id = BOS.standard_operation_id
6905: AND BSO.standard_operation_id = p_curr_std_op_id
6906: AND BD.department_id = BOS.department_id

Line 7050: bom_departments BD

7046: p_new_std_op_id,
7047: p_new_dept_id
7048: FROM bom_standard_operations BSO,
7049: bom_operation_sequences BOS,
7050: bom_departments BD
7051: WHERE BOS.routing_sequence_id = p_new_comm_rtg_seq_id
7052: AND BOS.operation_seq_num = nvl(p_new_op_seq_num,BOS.operation_seq_num)
7053: AND BOS.operation_sequence_id = nvl(p_new_op_seq_id,BOS.operation_sequence_id)
7054: AND BOS.standard_operation_id = BSO.standard_operation_id (+)

Line 7086: bom_departments BD

7082: p_new_std_op_id,
7083: p_new_dept_id
7084: FROM bom_standard_operations BSO,
7085: bom_operation_sequences BOS,
7086: bom_departments BD
7087: WHERE BOS.routing_sequence_id = p_new_comm_rtg_seq_id
7088: AND BOS.operation_seq_num = nvl(p_new_op_seq_num,BOS.operation_seq_num)
7089: AND BOS.operation_sequence_id = nvl(p_new_op_seq_id,BOS.operation_sequence_id)
7090: AND BOS.standard_operation_id = BSO.standard_operation_id