DBA Data[Home] [Help]

APPS.EAM_AUTOMATICEST dependencies on WIP_OPERATION_RESOURCES

Line 191: FROM WIP_OPERATION_RESOURCES wor , WIP_DISCRETE_JOBS wdj

187: l_stmt_num := 10;
188:
189: SELECT wor.wip_entity_id BULK COLLECT
190: INTO l_wip_entity_tbl
191: FROM WIP_OPERATION_RESOURCES wor , WIP_DISCRETE_JOBS wdj
192: WHERE wdj.wip_entity_id = wor.wip_entity_id
193: AND wdj.status_type
194: IN ( WIP_CONSTANTS.UNRELEASED , WIP_CONSTANTS.RELEASED ,
195: WIP_CONSTANTS.COMP_CHRG , WIP_CONSTANTS.HOLD ,