APPS.WSMPOPRN dependencies on WSM_COPY_OPERATIONS

Line 330: FROM WSM_COPY_OPERATIONS WCO

326: ELSIF ((g_aps_wps_profile='Y') AND (x_op_seq_id IS NOT NULL)) THEN
327: l_stat_num := 250;
328: SELECT count(*)
329: INTO l_count
330: FROM WSM_COPY_OPERATIONS WCO
331: WHERE WCO.WIP_ENTITY_ID = X_Wip_Entity_Id
332: AND wco.operation_sequence_id = x_op_seq_id;
333: END IF;
334:

Line 884: FROM WSM_COPY_OPERATIONS WCO

880: SELECT nvl(WCO.recommended, 'N'), WCO.RECO_START_DATE, WCO.reco_completion_date,
881: WCO.DEPARTMENT_ID, WCO.SCRAP_ACCOUNT, WCO.EST_ABSORPTION_ACCOUNT
882: INTO l_recommended_op, l_reco_start_date, l_reco_completion_date,
883: l_dept_id, l_scrap_account, l_est_absorption_account
884: FROM WSM_COPY_OPERATIONS WCO
885: WHERE wip_entity_id = X_Wip_Entity_Id
886: AND operation_sequence_id = x_op_seq_id;
887:
888: l_stat_num := 60;

Line 922: FROM WSM_COPY_OPERATIONS WCO

918: /* l_stat_num := 71;
919:
920: SELECT WCO.DEPARTMENT_ID, WCO.SCRAP_ACCOUNT, WCO.EST_ABSORPTION_ACCOUNT
921: into l_dept_id, l_scrap_account, l_est_absorption_account
922: FROM WSM_COPY_OPERATIONS WCO
923: WHERE WCO.WIP_ENTITY_ID = X_Wip_Entity_Id
924: AND WCO.OPERATION_SEQ_NUM = p_to_rtg_op_seq_num
925: AND WCO.ORGANIZATION_ID = X_Organization_Id;
926: */

Line 2361: FROM WSM_COPY_OPERATIONS WCO,

2357: WDJ.QUANTITY_SCRAPPED,
2358: WCO.operation_seq_num,
2359: 0,
2360: WCO.LOWEST_ACCEPTABLE_YIELD
2361: FROM WSM_COPY_OPERATIONS WCO,
2362: WIP_DISCRETE_JOBS WDJ
2363: WHERE WCO.wip_entity_id=p_wip_entity_id
2364: AND WCO.organization_id=p_org_id
2365: AND WCO.operation_seq_num = p_to_rtg_op_seq_num

Line 2443: WSM_COPY_OPERATIONS WCO

2439: DECODE(p_commit, 1, p_program_id, -999),
2440: DECODE(p_program_id, 0, '', SYSDATE),
2441: NULL, WCO.SCRAP_ACCOUNT, WCO.EST_ABSORPTION_ACCOUNT
2442: FROM WIP_OPERATIONS WO,
2443: WSM_COPY_OPERATIONS WCO
2444: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
2445: AND WO.OPERATION_SEQ_NUM = p_to_job_op_seq_num
2446: AND WO.ORGANIZATION_ID = p_org_id
2447: AND WCO.WIP_ENTITY_ID = WO.WIP_ENTITY_ID

Line 3588: FROM WSM_COPY_OPERATIONS

3584: l_stmt_num := 10;
3585: BEGIN
3586: SELECT nvl(recommended, 'N'), RECO_START_DATE, reco_completion_date
3587: INTO l_recommended_op, l_reco_start_date, l_reco_completion_date
3588: FROM WSM_COPY_OPERATIONS
3589: WHERE wip_entity_id = p_wip_entity_id
3590: AND operation_sequence_id = p_to_op_seq_id;
3591: EXCEPTION
3592: WHEN no_data_found THEN

Line 3594: fnd_file.put_line(fnd_file.log, 'To Op not present in WSM_COPY_OPERATIONS');

3590: AND operation_sequence_id = p_to_op_seq_id;
3591: EXCEPTION
3592: WHEN no_data_found THEN
3593: IF (l_debug = 'Y') THEN
3594: fnd_file.put_line(fnd_file.log, 'To Op not present in WSM_COPY_OPERATIONS');
3595: END IF;
3596: null;
3597: END;
3598: