eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSM_JOBCOPIES_PVT dependencies on WSM_COPY_OPERATIONS

Line 303: FROM wsm_copy_operations

299: network_start_end,
300: reco_start_date,
301: reco_completion_date,
302: department_id
303: FROM wsm_copy_operations
304: WHERE wip_entity_id = p_wip_entity_id
305: ORDER BY operation_seq_num;
306:
307: -- OptII Perf: New cursors ......

Line 432: type t_job_ops is table of WSM_COPY_OPERATIONS%rowtype index by binary_integer;

428: AND p_rtg_rev_date between BOS1.effectivity_date and nvl(BOS1.disable_date, p_rtg_rev_date+1);
429:
430:
431:
432: type t_job_ops is table of WSM_COPY_OPERATIONS%rowtype index by binary_integer;
433: type t_job_nw is table of WSM_COPY_OP_NETWORKS%rowtype index by binary_integer;
434:
435:
436: v_job_ops t_job_ops;

Line 609: FROM WSM_COPY_OPERATIONS O,

605: a.attribute12,
606: a.attribute13,
607: a.attribute14,
608: a.attribute15
609: FROM WSM_COPY_OPERATIONS O,
610: BOM_INVENTORY_COMPONENTS A,
611: MTL_SYSTEM_ITEMS C,
612: BOM_EXPLOSION_TEMP BE
613: WHERE be.group_id = l_explosion_group_id

Line 621: FROM WSM_COPY_OPERATIONS

617: AND c.organization_id = p_org_id
618: AND o.wip_entity_id = p_wip_entity_id
619: AND o.operation_sequence_id = l_curr_op_seq_id
620: AND ((A.operation_seq_num = (SELECT operation_seq_num
621: FROM WSM_COPY_OPERATIONS
622: WHERE operation_sequence_id =
623: l_curr_op_seq_id
624: AND wip_entity_id = p_wip_entity_id
625: )

Line 822: FROM WSM_COPY_OPERATIONS O,

818: s.attribute12,
819: s.attribute13,
820: s.attribute14,
821: s.attribute15
822: FROM WSM_COPY_OPERATIONS O,
823: BOM_INVENTORY_COMPONENTS A,
824: BOM_SUBSTITUTE_COMPONENTS S,
825: MTL_SYSTEM_ITEMS C,
826: BOM_EXPLOSION_TEMP BE

Line 837: FROM WSM_COPY_OPERATIONS

833: AND C.ORGANIZATION_ID = p_org_id
834: AND O.wip_entity_id = p_wip_entity_id
835: AND O.operation_sequence_id = l_curr_op_seq_id
836: AND ((A.operation_seq_num = (SELECT operation_seq_num
837: FROM WSM_COPY_OPERATIONS
838: WHERE operation_sequence_id =
839: l_curr_op_seq_id
840: AND wip_entity_id = p_wip_entity_id
841: )

Line 1071: DELETE WSM_COPY_OPERATIONS

1067: -- Delete COPY tables --
1068: --Delete only when l_new_job is false....
1069: if p_new_job is NULL or p_new_job = 2 then
1070:
1071: DELETE WSM_COPY_OPERATIONS
1072: WHERE wip_entity_id = p_wip_entity_id;
1073:
1074: DELETE WSM_COPY_OP_NETWORKS
1075: WHERE wip_entity_id = p_wip_entity_id;

Line 1588: INSERT INTO WSM_COPY_OPERATIONS(

1584: END IF;
1585:
1586: -- Insert the records into WCO ---
1587: forall l_index in v_job_ops.first..v_job_ops.last
1588: INSERT INTO WSM_COPY_OPERATIONS(
1589: WIP_ENTITY_ID,
1590: OPERATION_SEQ_NUM,
1591: RECOMMENDED,
1592: RECO_PATH_SEQ_NUM,

Line 1994: wsm_copy_operations wco

1990: bor.ATTRIBUTE15,
1991: bor.ORIGINAL_SYSTEM_REFERENCE
1992: FROM BOM_RESOURCES br,
1993: BOM_OPERATION_RESOURCES bor,
1994: wsm_copy_operations wco
1995: WHERE wco.wip_entity_id = p_wip_entity_id
1996: AND WCO.OPERATION_SEQUENCE_ID = bor.OPERATION_SEQUENCE_ID
1997: AND bor.RESOURCE_ID = br.RESOURCE_ID
1998: AND br.ORGANIZATION_ID = p_org_id;

Line 2150: WSM_COPY_OPERATIONS WCO

2146: bsor.ATTRIBUTE15,
2147: bsor.ORIGINAL_SYSTEM_REFERENCE
2148: FROM BOM_RESOURCES br,
2149: BOM_SUB_OPERATION_RESOURCES bsor,
2150: WSM_COPY_OPERATIONS WCO
2151: WHERE WCO.wip_entity_id = p_wip_entity_id
2152: AND bsor.RESOURCE_ID = br.RESOURCE_ID
2153: AND WCO.OPERATION_SEQUENCE_ID = bsor.OPERATION_SEQUENCE_ID;
2154:

Line 3819: FROM wsm_copy_operations

3815: BEGIN
3816: -- Start : Changes to fix bug 3452913 --
3817: SELECT recommended
3818: INTO l_is_curr_op_reco
3819: FROM wsm_copy_operations
3820: WHERE wip_entity_id = p_wip_entity_id
3821: AND operation_sequence_id = WSMPUTIL.replacement_copy_op_seq_id
3822: (l_curr_op_seq_id,
3823: p_wip_entity_id);

Line 3845: FROM wsm_copy_operations

3841: l_stmt_num := 315;
3842:
3843: SELECT 0-operation_seq_num
3844: INTO l_curr_op_seq_num -- Storing this as -ve, since finally a +ve opseq to be sent
3845: FROM wsm_copy_operations
3846: WHERE wip_entity_id = p_wip_entity_id
3847: AND network_start_end = l_network_start; --'S'; --Fixed bug #3761385
3848:
3849:

Line 4162: DELETE WSM_COPY_OPERATIONS

4158: /*
4159: DELETE WSM_COPY_OP_NETWORKS
4160: WHERE wip_entity_id = p_new_wip_entity_id;
4161:
4162: DELETE WSM_COPY_OPERATIONS
4163: WHERE wip_entity_id = p_new_wip_entity_id;
4164:
4165: DELETE WSM_COPY_OP_RESOURCES
4166: WHERE wip_entity_id = p_new_wip_entity_id;

Line 4266: INSERT INTO WSM_COPY_OPERATIONS

4262: END IF;
4263:
4264: -- ***** Make a copy of the Routing for the job ***** --
4265: l_stmt_num := 30;
4266: INSERT INTO WSM_COPY_OPERATIONS
4267: (WIP_ENTITY_ID,
4268: OPERATION_SEQ_NUM,
4269: RECOMMENDED,
4270: RECO_PATH_SEQ_NUM,

Line 4423: FROM WSM_COPY_OPERATIONS

4419: ATTRIBUTE14,
4420: ATTRIBUTE15,
4421: ORIGINAL_SYSTEM_REFERENCE,
4422: LOWEST_ACCEPTABLE_YIELD
4423: FROM WSM_COPY_OPERATIONS
4424: WHERE wip_entity_id = p_rep_wip_entity_id;
4425:
4426:
4427:

Line 5300: DELETE WSM_COPY_OPERATIONS

5296:
5297: l_stmt_num := 90;
5298:
5299: -- Delete COPY tables --
5300: DELETE WSM_COPY_OPERATIONS
5301: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5302:
5303: DELETE WSM_COPY_OP_NETWORKS
5304: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);

Line 5607: FROM WSM_COPY_OPERATIONS WCO,

5603: to_char(WCO.OPERATION_YIELD_ENABLED),
5604: nvl(RECOMMENDED, 'N'),
5605: WDJ.QUANTITY_SCRAPPED,
5606: WCO.operation_seq_num
5607: FROM WSM_COPY_OPERATIONS WCO,
5608: WIP_DISCRETE_JOBS WDJ
5609: WHERE WDJ.wip_entity_id = WCO.wip_entity_id
5610: AND WCO.network_start_end = 'S'
5611: AND WCO.wip_entity_id = p_wip_entity_id;