DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on WSM_COPY_OPERATIONS

Line 5960: FROM wsm_copy_operations wco,

5956: BEGIN
5957:
5958: SELECT distinct(wco.operation_sequence_id) -- Added distinct to fix bug #3507878
5959: INTO l_copy_op_seq_id
5960: FROM wsm_copy_operations wco,
5961: wip_operations wo
5962: WHERE wo.operation_sequence_id = p_job_op_seq_id
5963: AND wo.wip_entity_id = p_wip_entity_id
5964: AND wo.wip_entity_id = wco.wip_entity_id

Line 6241: from wsm_copy_operations

6237: l_stmt_num := 10;
6238: begin
6239: select operation_seq_num
6240: into l_nw_start
6241: from wsm_copy_operations
6242: where wip_entity_id = p_wip_entity_id
6243: and network_start_end = 'S';
6244: exception
6245: when others then

Line 6252: from wsm_copy_operations

6248: l_stmt_num := 20;
6249: begin
6250: select operation_seq_num
6251: into l_nw_end
6252: from wsm_copy_operations
6253: where wip_entity_id = p_wip_entity_id
6254: and network_start_end = 'E';
6255: exception
6256: when others then