DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on WSM_COPY_OPERATIONS

Line 5957: FROM wsm_copy_operations wco,

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

Line 6238: from wsm_copy_operations

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

Line 6249: from wsm_copy_operations

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