DBA Data[Home] [Help]

APPS.BOM_VALIDATE_OP_RES dependencies on WIP_OPERATION_RESOURCES

Line 79: FROM WIP_OPERATION_RESOURCES wor

75: FROM WIP_DISCRETE_JOBS wdj
76: WHERE (wdj.status_type <> 1
77: OR
78: NOT EXISTS(SELECT NULL
79: FROM WIP_OPERATION_RESOURCES wor
80: WHERE wor.resource_seq_num = p_resource_seq_num
81: AND wor.operation_seq_num = p_operation_seq_num
82: AND wor.wip_entity_id = wdj.wip_entity_id)
83: )

Line 105: FROM WIP_OPERATION_RESOURCES wor

101: , WIP_ENTITIES we2
102: WHERE (wdj.status_type <> 1
103: OR
104: NOT EXISTS (SELECT NULL
105: FROM WIP_OPERATION_RESOURCES wor
106: WHERE resource_seq_num = p_resource_seq_num
107: AND operation_seq_num = p_operation_seq_num
108: AND wip_entity_id = wdj.wip_entity_id)
109: )

Line 131: FROM WIP_OPERATION_RESOURCES wor

127: FROM WIP_DISCRETE_JOBS wdj
128: WHERE (wdj.status_type <> 1
129: OR
130: NOT EXISTS(SELECT NULL
131: FROM WIP_OPERATION_RESOURCES wor
132: WHERE resource_seq_num = p_resource_seq_num
133: AND operation_seq_num = p_operation_seq_num
134: AND wip_entity_id = wdj.wip_entity_id)
135: )