APPS.WSM_JOBCOPIES_PVT dependencies on WSM_COPY_OP_RESOURCE_USAGE

Line 1082: DELETE WSM_COPY_OP_RESOURCE_USAGE

1078:
1079: DELETE WSM_COPY_OP_RESOURCE_INSTANCES
1080: WHERE wip_entity_id = p_wip_entity_id;
1081:
1082: DELETE WSM_COPY_OP_RESOURCE_USAGE
1083: WHERE wip_entity_id = p_wip_entity_id;
1084:
1085: DELETE WSM_COPY_REQUIREMENT_OPS
1086: WHERE wip_entity_id = p_wip_entity_id;

Line 3940: DELETE WSM_COPY_OP_RESOURCE_USAGE

3936:
3937: DELETE WSM_COPY_OP_RESOURCE_INSTANCES
3938: WHERE wip_entity_id = p_new_wip_entity_id;
3939:
3940: DELETE WSM_COPY_OP_RESOURCE_USAGE
3941: WHERE wip_entity_id = p_new_wip_entity_id;
3942:
3943: DELETE WSM_COPY_REQUIREMENT_OPS
3944: WHERE wip_entity_id = p_new_wip_entity_id;

Line 5081: DELETE WSM_COPY_OP_RESOURCE_USAGE

5077:
5078: DELETE WSM_COPY_OP_RESOURCE_INSTANCES
5079: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5080:
5081: DELETE WSM_COPY_OP_RESOURCE_USAGE
5082: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5083:
5084: DELETE WSM_COPY_REQUIREMENT_OPS
5085: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);

Line 5775: WSM_COPY_OP_RESOURCE_USAGE WCORU

5771: WCORU.INSTANCE_ID,
5772: WCORU.SERIAL_NUMBER,
5773: WCORU.CUMULATIVE_PROCESSING_TIME
5774: FROM WIP_OPERATION_RESOURCES WOR,
5775: WSM_COPY_OP_RESOURCE_USAGE WCORU
5776: WHERE WCORU.WIP_ENTITY_ID= p_wip_entity_id
5777: AND WCORU.Operation_seq_num = l_curr_op_seq_num
5778: AND WOR.WIP_ENTITY_ID= WCORU.WIP_ENTITY_ID
5779: AND WOR.Operation_seq_num= WCORU.Operation_seq_num