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.WSMPOPRN dependencies on WIP_OPERATIONS

Line 9: | This package body is used to add WIP Operations to the WIP routing |

5: | Copyright (c) 1996 Oracle Corporation, Redwood Shores, California, USA |
6: | All rights reserved. |
7: | |
8: | DESCRIPTION |
9: | This package body is used to add WIP Operations to the WIP routing |
10: | from the custom move transactions form |
11: | |
12: | HISTORY |
13: | 06/23/97 DJOFFE Created |

Line 246: FROM wip_operations

242: /***********************
243: BEGIN
244: SELECT unique max(operation_seq_num)
245: INTO l_max_op_seq
246: FROM wip_operations
247: WHERE WIP_ENTITY_ID = x_wip_entity_id
248: AND operation_seq_num NOT IN
249: ( SELECT nvl(last_operation_seq_num, 9999)
250: FROM wsm_parameters

Line 368: INSERT INTO WIP_OPERATIONS

364: END IF;
365: -- OSP FP I end
366: l_stat_num := 270;
367: --bug 3162358 115.78 added CUMULATIVE_SCRAP_QUANTITY
368: INSERT INTO WIP_OPERATIONS
369: (WIP_ENTITY_ID,
370: OPERATION_SEQ_NUM,
371: ORGANIZATION_ID,
372: LAST_UPDATE_DATE,

Line 503: from wip_operations

499: if sql%rowcount > 0 then
500: l_stat_num := 280;
501: select operation_sequence_id
502: into l_op_seq_id
503: from wip_operations
504: where wip_entity_id = x_wip_entity_id
505: and operation_seq_num = x_to_op
506: and organization_id = x_organization_id;
507:

Line 561: from wip_operations

557: -- BA: BUG2256872, fetch previous_operation_seq_id only if operation_sequence_id is NULL
558: l_stat_num := 300;
559: select nvl(operation_sequence_id, previous_operation_seq_id)
560: into l_fm_op_seq_id
561: from wip_operations
562: where wip_entity_id = x_wip_entity_id
563: and operation_seq_num = x_from_op
564: and organization_id = x_organization_id;
565: -- EA: BUG2256872

Line 569: INSERT INTO WIP_OPERATIONS

565: -- EA: BUG2256872
566:
567: l_stat_num := 310;
568: --bug 3162358 115.78 added CUMULATIVE_SCRAP_QUANTITY
569: INSERT INTO WIP_OPERATIONS
570: (WIP_ENTITY_ID,
571: OPERATION_SEQ_NUM,
572: ORGANIZATION_ID,
573: LAST_UPDATE_DATE,

Line 806: FROM WIP_OPERATIONS WO,

802:
803: l_stat_num := 40.1;
804: SELECT BD.DEPARTMENT_ID, BD.SCRAP_ACCOUNT, BD.EST_ABSORPTION_ACCOUNT
805: into l_dept_id, l_scrap_account, l_est_absorption_account
806: FROM WIP_OPERATIONS WO,
807: BOM_DEPARTMENTS BD
808: WHERE WO.WIP_ENTITY_ID = x_wip_entity_id
809: AND WO.OPERATION_SEQ_NUM = x_to_op
810: AND WO.ORGANIZATION_ID = x_organization_id

Line 1083: WIP_OPERATIONS wo

1079: BSSOR.replacement_group_num, --replacement_group_num,
1080: NULL --setup_id
1081: FROM BOM_RESOURCES BR,
1082: BOM_STD_SUB_OP_RESOURCES BSSOR,
1083: WIP_OPERATIONS wo
1084: WHERE WO.WIP_ENTITY_ID = x_wip_entity_id
1085: AND WO.OPERATION_SEQ_NUM = x_to_op
1086: AND BSSOR.standard_operation_id = WO.standard_operation_id
1087: AND BSSOR.RESOURCE_ID = BR.RESOURCE_ID;

Line 1097: FROM WIP_OPERATIONS

1093: OR (l_reco_completion_date IS NULL)) THEN
1094:
1095: SELECT last_unit_completion_date
1096: INTO l_infi_start_date
1097: FROM WIP_OPERATIONS
1098: WHERE wip_entity_id = X_Wip_Entity_Id
1099: AND organization_id = X_Organization_Id
1100: AND operation_seq_num = X_From_Op;
1101:

Line 1155: UPDATE wip_operations

1151: -- CZH.I_9999, Disable_operations should be called before insert the
1152: -- operation in to WO, hence, all the operations with op_seq_num
1153: -- greater than x_from_op should be disabled!
1154:
1155: UPDATE wip_operations
1156: SET count_point_type = 3,
1157: scheduled_quantity = 0, -- Added to fix bug #2686501
1158: --bug 3595728 change from sysdate to p_txn_date-1 second
1159: -- disable_date = sysdate -- Bug 2931071

Line 1219: DELETE FROM WIP_OPERATIONS

1215: l_stat_num NUMBER;
1216:
1217: BEGIN
1218: l_stat_num := 10;
1219: DELETE FROM WIP_OPERATIONS
1220: WHERE WIP_ENTITY_ID = X_Wip_Entity_id
1221: --AND OPERATION_SEQ_NUM > X_From_Op
1222: AND OPERATION_SEQ_NUM = X_To_Op
1223: AND PROGRAM_ID = -999

Line 1229: --delete attached document, since operation was deleted from wip_operations table.

1225:
1226: IF SQL%ROWCOUNT > 0 THEN
1227: l_stat_num := 20;
1228: --bugfix 2026218
1229: --delete attached document, since operation was deleted from wip_operations table.
1230:
1231: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(
1232: X_entity_name => 'WSM_LOT_BASED_OPERATIONS',
1233: X_pk1_value => to_char(x_wip_entity_id),

Line 1333: WIP_OPERATIONS OPS

1329: ORS.PRINCIPLE_FLAG,
1330: ORS.SETUP_ID
1331: FROM BOM_RESOURCES RSC,
1332: BOM_OPERATION_RESOURCES ORS,
1333: WIP_OPERATIONS OPS
1334: WHERE OPS.ORGANIZATION_ID = X_Organization_Id
1335: AND OPS.WIP_ENTITY_ID = X_Wip_Entity_Id
1336: AND OPS.OPERATION_SEQ_NUM = X_op_seq_num
1337: AND OPS.OPERATION_SEQUENCE_ID = ORS.OPERATION_SEQUENCE_ID

Line 1388: WIP_OPERATIONS OPS

1384: ORS.SUBSTITUTE_GROUP_NUM, --Added : -- bug 7371846
1385: 0 --Added : -- make it as zero on resources level -- bug 7371846
1386: FROM BOM_RESOURCES RSC,
1387: BOM_STD_OP_RESOURCES ORS,
1388: WIP_OPERATIONS OPS
1389: WHERE OPS.ORGANIZATION_ID = X_Organization_Id
1390: AND OPS.WIP_ENTITY_ID = X_Wip_Entity_Id
1391: AND OPS.OPERATION_SEQ_NUM = X_op_seq_num
1392: AND OPS.STANDARD_OPERATION_ID = ORS.STANDARD_OPERATION_ID

Line 1399: -- for jumping operation, the operation_seq_id insert into the wip_operations table will be null,

1395: END IF;
1396: -- End bugfix 1523334
1397:
1398: -- bugfix 1611094
1399: -- for jumping operation, the operation_seq_id insert into the wip_operations table will be null,
1400: -- so the previous select statment will not insert row into wip_operation_yields,
1401: -- changed where clause, so that new record will be insert into the wip_operation_yields with jumping operation
1402:
1403: -- The below insert is used for Costing Changes (OP Yield)

Line 1416: FROM WIP_OPERATIONS WO,

1412: WO.LAST_UPDATE_DATE, WO.LAST_UPDATED_BY, WO.CREATION_DATE,
1413: WO.CREATED_BY, WO.LAST_UPDATE_LOGIN, WO.REQUEST_ID,
1414: WO.PROGRAM_APPLICATION_ID, WO.PROGRAM_ID, WO.PROGRAM_UPDATE_DATE,
1415: NULL, BD.SCRAP_ACCOUNT, BD.EST_ABSORPTION_ACCOUNT
1416: FROM WIP_OPERATIONS WO,
1417: -- BOM_OPERATION_SEQUENCES BOS, fix bug 1611094
1418: BOM_DEPARTMENTS BD
1419: WHERE WO.WIP_ENTITY_ID = X_Wip_Entity_Id
1420: AND WO.OPERATION_SEQ_NUM = X_op_seq_num

Line 1450: UPDATE WIP_OPERATIONS WO

1446: ) IS
1447: l_stat_num NUMBER;
1448: BEGIN
1449: l_stat_num := 10;
1450: UPDATE WIP_OPERATIONS WO
1451: SET WO.PREVIOUS_OPERATION_SEQ_NUM =
1452: (SELECT MAX(OPERATION_SEQ_NUM)
1453: FROM WIP_OPERATIONS
1454: WHERE WIP_ENTITY_ID = X_Wip_Entity_Id

Line 1453: FROM WIP_OPERATIONS

1449: l_stat_num := 10;
1450: UPDATE WIP_OPERATIONS WO
1451: SET WO.PREVIOUS_OPERATION_SEQ_NUM =
1452: (SELECT MAX(OPERATION_SEQ_NUM)
1453: FROM WIP_OPERATIONS
1454: WHERE WIP_ENTITY_ID = X_Wip_Entity_Id
1455: -- bugfix 2644217: AND ORGANIZATION_ID = X_Organization_Id
1456: AND OPERATION_SEQ_NUM < WO.OPERATION_SEQ_NUM),
1457: WO.NEXT_OPERATION_SEQ_NUM =

Line 1459: FROM WIP_OPERATIONS

1455: -- bugfix 2644217: AND ORGANIZATION_ID = X_Organization_Id
1456: AND OPERATION_SEQ_NUM < WO.OPERATION_SEQ_NUM),
1457: WO.NEXT_OPERATION_SEQ_NUM =
1458: (SELECT MIN(OPERATION_SEQ_NUM)
1459: FROM WIP_OPERATIONS
1460: WHERE WIP_ENTITY_ID = X_Wip_Entity_Id
1461: -- bugfix 2644217: AND ORGANIZATION_ID = X_Organization_Id
1462: AND OPERATION_SEQ_NUM > WO.OPERATION_SEQ_NUM)
1463: WHERE WO.WIP_ENTITY_ID = X_Wip_Entity_Id

Line 1495: UPDATE WIP_OPERATIONS WO

1491:
1492: l_stat_num := 10;
1493:
1494:
1495: UPDATE WIP_OPERATIONS WO
1496: SET WO.PREVIOUS_OPERATION_SEQ_NUM = decode(WO.OPERATION_SEQ_NUM - x_op_seq_incr,0,null,WO.OPERATION_SEQ_NUM - x_op_seq_incr) ,
1497: -- Bug 5336643 Added decode so that null is populated instead of zero
1498: WO.NEXT_OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM + x_op_seq_incr
1499: WHERE WO.WIP_ENTITY_ID = X_Wip_Entity_Id

Line 1548: wip_operations wo

1544: l_std_operation_id,
1545: l_step_code
1546: FROM
1547: mfg_lookups ml,
1548: wip_operations wo
1549: WHERE wip_entity_id = p_wip_entity_id
1550: AND quantity_in_queue = 0
1551: AND quantity_running = 0
1552: AND quantity_waiting_to_move = 0

Line 1583: wip_operations wo

1579: l_std_operation_id,
1580: l_step_code
1581: FROM
1582: mfg_lookups ml,
1583: wip_operations wo
1584: WHERE wip_entity_id = p_wip_entity_id
1585: AND (quantity_in_queue <> 0
1586: OR quantity_running <> 0
1587: OR quantity_waiting_to_move <> 0)

Line 2251: INSERT INTO WIP_OPERATIONS

2247:
2248: --move enh? ask vj abt recommended col in WO
2249: --bug 3162358 115.78 added CUMULATIVE_SCRAP_QUANTITY
2250: --bug 3370199 added wsm_op_seq_num
2251: INSERT INTO WIP_OPERATIONS
2252: (WIP_ENTITY_ID,
2253: OPERATION_SEQ_NUM,
2254: ORGANIZATION_ID,
2255: LAST_UPDATE_DATE,

Line 2417: FROM WIP_OPERATIONS WO,

2413: DECODE(p_program_application_id, 0, '', p_program_application_id),
2414: DECODE(p_commit, 1, p_program_id, -999),
2415: DECODE(p_program_id, 0, '', SYSDATE),
2416: NULL, BD.SCRAP_ACCOUNT, BD.EST_ABSORPTION_ACCOUNT
2417: FROM WIP_OPERATIONS WO,
2418: BOM_DEPARTMENTS BD
2419: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
2420: AND WO.OPERATION_SEQ_NUM = p_to_job_op_seq_num
2421: AND WO.ORGANIZATION_ID = p_org_id

Line 2442: FROM WIP_OPERATIONS WO,

2438: DECODE(p_program_application_id, 0, '', p_program_application_id),
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

Line 3605: FROM WIP_OPERATIONS

3601: l_stmt_num := 20;
3602:
3603: SELECT last_unit_completion_date
3604: INTO l_infi_start_date
3605: FROM WIP_OPERATIONS
3606: WHERE wip_entity_id = p_wip_entity_id
3607: AND organization_id = p_org_id
3608: AND operation_seq_num = p_fm_job_op_seq_num;
3609:

Line 3655: UPDATE WIP_OPERATIONS WO

3651: IS
3652: l_stmt_num NUMBER;
3653: BEGIN
3654: l_stmt_num := 10;
3655: UPDATE WIP_OPERATIONS WO
3656: SET cumulative_scrap_quantity =
3657: (SELECT quantity_scrapped
3658: FROM WIP_DISCRETE_JOBS WDJ
3659: WHERE WDJ.wip_entity_id = p_wip_entity_id

Line 3779: WIP_OPERATIONS WO

3775: p_user,
3776: SYSDATE,
3777: p_login
3778: FROM BOM_STD_OP_SCRAP_CODES BSOSC,
3779: WIP_OPERATIONS WO
3780: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
3781: AND WO.OPERATION_SEQ_NUM = p_to_job_op_seq_num
3782: AND BSOSC.STANDARD_OPERATION_ID = WO.STANDARD_OPERATION_ID;
3783:

Line 3811: WIP_OPERATIONS WO

3807: p_user,
3808: SYSDATE,
3809: p_login
3810: FROM BOM_STD_OP_BONUS_CODES BSOSC,
3811: WIP_OPERATIONS WO
3812: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
3813: AND WO.OPERATION_SEQ_NUM = p_to_job_op_seq_num
3814: AND BSOSC.STANDARD_OPERATION_ID = WO.STANDARD_OPERATION_ID;
3815: