DBA Data[Home] [Help]

APPS.WIP_WPS_COMMON dependencies on WSM_COPY_OP_RESOURCE_USAGE

Line 1853: delete wsm_copy_op_resource_usage wcoru

1849: where wcor.wip_entity_id = p_wip_entity_id
1850: and wcor.operation_seq_num = p_operation_seq_num
1851: and wcor.resource_seq_num = p_resource_seq_num;
1852: -- delete usage
1853: delete wsm_copy_op_resource_usage wcoru
1854: where wcoru.wip_entity_id = p_wip_entity_id
1855: and wcoru.operation_seq_num = p_operation_seq_num
1856: and wcoru.resource_seq_num = p_resource_seq_num;
1857: -- update instances if any

Line 1877: delete wsm_copy_op_resource_usage wcoru

1873: and wcor.operation_seq_num = p_operation_seq_num
1874: and wcor.schedule_seq_num = l_sched_seq_num
1875: and wcor.recommended = 'Y';
1876: -- delete usages
1877: delete wsm_copy_op_resource_usage wcoru
1878: where wcoru.wip_entity_id = p_wip_entity_id
1879: and wcoru.operation_seq_num = p_operation_seq_num
1880: and wcoru.resource_seq_num in
1881: ( select wcor.resource_seq_num