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 836: FROM WSM_COPY_OPERATIONS

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

Line 1070: DELETE WSM_COPY_OPERATIONS

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

Line 1587: INSERT INTO WSM_COPY_OPERATIONS

1583: END IF;
1584:
1585: -- Insert the records into WCO ---
1586: forall l_index in v_job_ops.first..v_job_ops.last
1587: INSERT INTO WSM_COPY_OPERATIONS
1588: values v_job_ops(l_index);
1589:
1590: --Start changes for 4448718
1591: -- insert records..

Line 1764: wsm_copy_operations wco

1760: bor.ATTRIBUTE15,
1761: bor.ORIGINAL_SYSTEM_REFERENCE
1762: FROM BOM_RESOURCES br,
1763: BOM_OPERATION_RESOURCES bor,
1764: wsm_copy_operations wco
1765: WHERE wco.wip_entity_id = p_wip_entity_id
1766: AND WCO.OPERATION_SEQUENCE_ID = bor.OPERATION_SEQUENCE_ID
1767: AND bor.RESOURCE_ID = br.RESOURCE_ID
1768: AND br.ORGANIZATION_ID = p_org_id;

Line 1920: WSM_COPY_OPERATIONS WCO

1916: bsor.ATTRIBUTE15,
1917: bsor.ORIGINAL_SYSTEM_REFERENCE
1918: FROM BOM_RESOURCES br,
1919: BOM_SUB_OPERATION_RESOURCES bsor,
1920: WSM_COPY_OPERATIONS WCO
1921: WHERE WCO.wip_entity_id = p_wip_entity_id
1922: AND bsor.RESOURCE_ID = br.RESOURCE_ID
1923: AND WCO.OPERATION_SEQUENCE_ID = bsor.OPERATION_SEQUENCE_ID;
1924:

Line 3588: FROM wsm_copy_operations

3584: BEGIN
3585: -- Start : Changes to fix bug 3452913 --
3586: SELECT recommended
3587: INTO l_is_curr_op_reco
3588: FROM wsm_copy_operations
3589: WHERE wip_entity_id = p_wip_entity_id
3590: AND operation_sequence_id = WSMPUTIL.replacement_copy_op_seq_id
3591: (l_curr_op_seq_id,
3592: p_wip_entity_id);

Line 3614: FROM wsm_copy_operations

3610: l_stmt_num := 315;
3611:
3612: SELECT 0-operation_seq_num
3613: INTO l_curr_op_seq_num -- Storing this as -ve, since finally a +ve opseq to be sent
3614: FROM wsm_copy_operations
3615: WHERE wip_entity_id = p_wip_entity_id
3616: AND network_start_end = l_network_start; --'S'; --Fixed bug #3761385
3617:
3618:

Line 3931: DELETE WSM_COPY_OPERATIONS

3927: /*
3928: DELETE WSM_COPY_OP_NETWORKS
3929: WHERE wip_entity_id = p_new_wip_entity_id;
3930:
3931: DELETE WSM_COPY_OPERATIONS
3932: WHERE wip_entity_id = p_new_wip_entity_id;
3933:
3934: DELETE WSM_COPY_OP_RESOURCES
3935: WHERE wip_entity_id = p_new_wip_entity_id;

Line 4035: INSERT INTO WSM_COPY_OPERATIONS

4031: END IF;
4032:
4033: -- ***** Make a copy of the Routing for the job ***** --
4034: l_stmt_num := 30;
4035: INSERT INTO WSM_COPY_OPERATIONS
4036: (WIP_ENTITY_ID,
4037: OPERATION_SEQ_NUM,
4038: RECOMMENDED,
4039: RECO_PATH_SEQ_NUM,

Line 4192: FROM WSM_COPY_OPERATIONS

4188: ATTRIBUTE14,
4189: ATTRIBUTE15,
4190: ORIGINAL_SYSTEM_REFERENCE,
4191: LOWEST_ACCEPTABLE_YIELD
4192: FROM WSM_COPY_OPERATIONS
4193: WHERE wip_entity_id = p_rep_wip_entity_id;
4194:
4195:
4196:

Line 5069: DELETE WSM_COPY_OPERATIONS

5065:
5066: l_stmt_num := 90;
5067:
5068: -- Delete COPY tables --
5069: DELETE WSM_COPY_OPERATIONS
5070: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5071:
5072: DELETE WSM_COPY_OP_NETWORKS
5073: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);

Line 5376: FROM WSM_COPY_OPERATIONS WCO,

5372: to_char(WCO.OPERATION_YIELD_ENABLED),
5373: nvl(RECOMMENDED, 'N'),
5374: WDJ.QUANTITY_SCRAPPED,
5375: WCO.operation_seq_num
5376: FROM WSM_COPY_OPERATIONS WCO,
5377: WIP_DISCRETE_JOBS WDJ
5378: WHERE WDJ.wip_entity_id = WCO.wip_entity_id
5379: AND WCO.network_start_end = 'S'
5380: AND WCO.wip_entity_id = p_wip_entity_id;