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

Line 1351: from wip_operations

1347: --***VJ Changed for Performance Upgrade***--
1348: BEGIN
1349: select max(OPERATION_SEQ_NUM)
1350: into l_max_qty_op_seq_num
1351: from wip_operations
1352: where organization_id = p_org_id
1353: and wip_entity_id = l_wip_entity_id
1354: and ((QUANTITY_IN_QUEUE > 0) or
1355: (QUANTITY_RUNNING > 0) or

Line 1376: -- Find out at which operation/intra-op step the quantity lies in WIP_OPERATIONS table

1372: --***VJ End Changes***--
1373:
1374: l_stmt_num := 170;
1375:
1376: -- Find out at which operation/intra-op step the quantity lies in WIP_OPERATIONS table
1377: --bug 3370199 added wsm_op_seq_num
1378: select operation_seq_num,
1379: operation_sequence_id,
1380: standard_operation_id,

Line 1396: from wip_operations

1392: l_wo_qty_in_running,
1393: l_wo_qty_in_tomove,
1394: l_wo_qty_in_scrap,
1395: l_wo_rtg_op_seq_num
1396: from wip_operations
1397: where organization_id = p_org_id
1398: and wip_entity_id = l_wip_entity_id
1399: and OPERATION_SEQ_NUM = l_max_qty_op_seq_num; --***VJ Changed for Performance Upgrade***--
1400:

Line 1465: -- is not equal to l_wo_op_code (that in wip_operations table, we need

1461:
1462: -- begin 2363380 : Modified the cryptic logic and made it more readable.
1463: -- (for old code, checkout the previous version)
1464: -- Logic here is that If p_fm_op_code (populated in interface table)
1465: -- is not equal to l_wo_op_code (that in wip_operations table, we need
1466: -- to error out. If they have left it blank, populate it.
1467: if (p_fm_op_code is null and l_wo_op_code is null) then
1468: null; -- do nothing
1469:

Line 3617: FROM wip_operations

3613: ***********************************************/
3614: BEGIN
3615: SELECT operation_sequence_id, backflush_flag
3616: INTO l_temp, l_fm_op_bkflsh_flag
3617: FROM wip_operations
3618: WHERE operation_seq_num = p_fm_op_seq_num
3619: AND wip_entity_id = l_wip_entity_id
3620: AND ORGANIZATION_ID = p_org_id;
3621: EXCEPTION

Line 3910: FROM WIP_OPERATIONS WO

3906: UPDATE WSM_LOT_BASED_JOBS
3907: SET current_job_op_seq_num = l_cmp_fm_op_seq_num,
3908: current_rtg_op_seq_num =
3909: (SELECT wsm_op_seq_num
3910: FROM WIP_OPERATIONS WO
3911: WHERE WO.wip_entity_id = l_wip_entity_id
3912: AND WO.operation_seq_num = l_cmp_fm_op_seq_num)
3913: WHERE WIP_ENTITY_ID = l_wip_entity_id;
3914: END IF;

Line 4029: WIP_OPERATIONS WO

4025: BEGIN
4026: SELECT nvl(WCO.recommended, 'N')
4027: INTO l_recommended
4028: FROM WSM_COPY_OPERATIONS WCO,
4029: WIP_OPERATIONS WO
4030: WHERE WO.wip_entity_id = l_wip_entity_id
4031: AND WO.organization_id = p_org_id
4032: AND WO.operation_seq_num = l_cmp_fm_op_seq_num
4033: AND WCO.wip_entity_id = WO.wip_entity_id

Line 4341: from wip_operations

4337: --***VJ Changed for Performance Upgrade***--
4338: BEGIN
4339: select max(OPERATION_SEQ_NUM)
4340: into l_max_qty_op_seq_num
4341: from wip_operations
4342: where organization_id = p_org_id
4343: and wip_entity_id = l_wip_entity_id
4344: and ((QUANTITY_IN_QUEUE > 0) or
4345: (QUANTITY_RUNNING > 0) or

Line 4377: from wip_operations

4373: l_wo_qty_in_queue,
4374: l_wo_qty_in_running,
4375: l_wo_qty_in_tomove,
4376: l_wo_qty_in_scrap
4377: from wip_operations
4378: where organization_id = p_org_id
4379: and wip_entity_id = l_wip_entity_id
4380: and OPERATION_SEQ_NUM = l_max_qty_op_seq_num; --***VJ Changed for Performance Upgrade***--
4381:

Line 4556: FROM WIP_OPERATIONS WO

4552: UPDATE WSM_LOT_BASED_JOBS
4553: SET current_job_op_seq_num = l_fm_op_seq_num,
4554: current_rtg_op_seq_num =
4555: (SELECT wsm_op_seq_num
4556: FROM WIP_OPERATIONS WO
4557: WHERE WO.wip_entity_id = l_wip_entity_id
4558: AND WO.operation_seq_num = l_fm_op_seq_num)
4559: WHERE WIP_ENTITY_ID = l_wip_entity_id;
4560: END IF;

Line 4625: WIP_OPERATIONS WO

4621: BEGIN
4622: SELECT nvl(WCO.recommended, 'N')
4623: INTO l_recommended
4624: FROM WSM_COPY_OPERATIONS WCO,
4625: WIP_OPERATIONS WO
4626: WHERE WO.wip_entity_id = l_wip_entity_id
4627: AND WO.organization_id = p_org_id
4628: AND WO.operation_seq_num = l_fm_op_seq_num
4629: AND WCO.wip_entity_id = WO.wip_entity_id

Line 5260: FROM wip_operations

5256: l_stmt_num := 520;
5257: --Added to fix bug #1496147
5258: SELECT unique max(operation_seq_num)
5259: INTO l_max_op_seq
5260: FROM wip_operations
5261: WHERE WIP_ENTITY_ID = l_wip_entity_id;
5262: --***VJ: Start Deletion for removal of 9999 ***--
5263: -- AND operation_seq_num NOT IN
5264: -- ( SELECT nvl(last_operation_seq_num, 9999)

Line 5307: FND_MESSAGE.SET_TOKEN('TABLE', 'wip_operations');

5303:
5304: IF (x_return_code <> 0) THEN
5305: if x_err_buf is null then
5306: FND_MESSAGE.SET_NAME('WSM', 'WSM_INS_TBL_FAILED');
5307: FND_MESSAGE.SET_TOKEN('TABLE', 'wip_operations');
5308: x_err_buf := FND_MESSAGE.GET;
5309: end if;
5310:
5311: -- OSP FP I end changes

Line 5327: update wip_operations

5323: /* JUMP_ENH: Set the skip_flag to 1 if jump_from_queue is set to TRUE */
5324: l_stmt_num:=532;
5325: IF (l_jump_from_queue) THEN
5326: l_stmt_num:=533;
5327: update wip_operations
5328: set skip_flag=l_yes, -- Set skip_flag to Yes
5329: disable_date =p_txn_date -- Added this line for bug 5367603
5330: where organization_id = p_org_id
5331: and wip_entity_id = l_wip_entity_id

Line 5744: update wip_operations

5740: BEGIN
5741: l_stmt_num := 30;
5742: if (p_undo_jump_fromq) then
5743: l_stmt_num := 40;
5744: update wip_operations
5745: set skip_flag=l_no,
5746: disable_date = null -- Added this line for bug 5367603
5747: where organization_id = p_org_id
5748: and wip_entity_id = p_wip_entity_id

Line 8188: from wip_operations

8184: --move enh added IF condn
8185: IF (l_transaction_type <> 3) THEN
8186: select NVL(operation_sequence_id, -1) -- CZH.bug2393850 in op outside routing
8187: into l_fm_op_seq_id
8188: from wip_operations
8189: where wip_entity_id = l_wip_entity_id
8190: and operation_seq_num = l_fm_op_seq_num;
8191: END IF;
8192:

Line 8213: FROM wip_operations

8209: l_stmt_num := 190;
8210:
8211: SELECT unique max(operation_seq_num)
8212: INTO l_max_op_seq -- will be the newly added row in WO
8213: FROM wip_operations
8214: WHERE WIP_ENTITY_ID = l_wip_entity_id;
8215:
8216:
8217: END IF;

Line 8814: FROM wip_operations wo

8810: AND wro.wip_supply_type <> 4
8811: AND wro.wip_supply_type <> 5
8812: AND NOT EXISTS
8813: (SELECT 1
8814: FROM wip_operations wo
8815: WHERE wo.organization_id = wro.organization_id
8816: AND wo.wip_entity_id = wro.wip_entity_id
8817: AND wo.operation_seq_num = wro.operation_seq_num
8818: AND wo.count_point_type = 3);

Line 9146: FROM WIP_OPERATIONS

9142:
9143: --bug 5210799 Update quantity_completed to null if jump from queue
9144: UPDATE (
9145: SELECT quantity_completed
9146: FROM WIP_OPERATIONS
9147: WHERE wip_entity_id = l_wip_entity_id
9148: AND operation_seq_num = l_fm_op_seq_num
9149: AND skip_flag = 1
9150: )

Line 9398: UPDATE WIP_OPERATIONS

9394:
9395: END IF;
9396:
9397: l_stmt_num := 253.6121;
9398: UPDATE WIP_OPERATIONS
9399: SET actual_start_date = p_operation_start_date,
9400: projected_completion_date = p_expected_completion_date,
9401: employee_id = p_employee_id,
9402: wsm_bonus_quantity = p_bonus_quantity,

Line 9541: UPDATE WIP_OPERATIONS

9537:
9538: END IF;--IF (p_jobop_resource_usages_tbls IS NOT NULL)
9539:
9540: l_stmt_num := 253.611;
9541: UPDATE WIP_OPERATIONS
9542: SET actual_start_date = p_operation_start_date,
9543: actual_completion_date = p_operation_completion_date,
9544: employee_id = p_employee_id,
9545: wsm_bonus_quantity = p_bonus_quantity,

Line 9557: --FROM WSM_COPY_OPERATIONS WCO, WIP_OPERATIONS WO

9553: --BEGIN
9554: --if last op update wdj.actual_completion_date
9555: --SELECT WCO.network_start_end
9556: --INTO l_wco_to_op_network_end
9557: --FROM WSM_COPY_OPERATIONS WCO, WIP_OPERATIONS WO
9558: -- WHERE WCO.wip_entity_id = WO.wip_entity_id
9559: -- AND WCO.operation_seq_num = WO.wsm_op_seq_num
9560: --AND WO.wip_entity_id = l_wip_entity_id
9561: -- AND WO.operation_seq_num = l_job_to_op_seq_num;

Line 9591: --FROM WSM_COPY_OPERATIONS WCO, WIP_OPERATIONS WO

9587: --BEGIN
9588: --if 1st op update wdj.actual_start_date
9589: --SELECT WCO.network_start_end
9590: --INTO l_wco_fm_op_network_start
9591: --FROM WSM_COPY_OPERATIONS WCO, WIP_OPERATIONS WO
9592: --WHERE WCO.wip_entity_id = WO.wip_entity_id
9593: --AND WCO.operation_seq_num = WO.wsm_op_seq_num
9594: --AND WO.wip_entity_id = l_wip_entity_id
9595: --AND WO.operation_seq_num = l_fm_op_seq_num;

Line 9669: -- FROM WIP_OPERATIONS WO

9665: --undo of first move txn
9666: --Start of changes for 5480482
9667: --SELECT min(operation_seq_num)
9668: --INTO l_wo_min_op_seq_num
9669: -- FROM WIP_OPERATIONS WO
9670: -- WHERE WO.wip_entity_id = l_wip_entity_id;
9671:
9672: --IF (l_job_to_op_seq_num = l_wo_min_op_seq_num) AND (l_to_intraoperation_step_type = 1) THEN
9673: --l_stmt_num := 253.614;

Line 9694: UPDATE WIP_OPERATIONS

9690: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES
9691: where wip_entity_id = l_wip_entity_id
9692: and operation_seq_num = l_job_to_op_seq_num;
9693:
9694: UPDATE WIP_OPERATIONS
9695: SET actual_start_date = null,
9696: actual_completion_date = null,
9697: employee_id = null,
9698: LAST_UPDATE_DATE = sysdate,

Line 9719: UPDATE WIP_OPERATIONS

9715: ELSIF (((l_fm_intraoperation_step_type = 1) OR (l_fm_intraoperation_step_type = 3) OR (l_fm_intraoperation_step_type = 5))
9716: AND (l_to_intraoperation_step_type = 2)) THEN
9717: --Move In b4 Move Out
9718:
9719: UPDATE WIP_OPERATIONS
9720: SET actual_completion_date = null
9721: WHERE wip_entity_id = l_wip_entity_id
9722: AND operation_seq_num = l_job_to_op_seq_num;
9723:

Line 9749: UPDATE WIP_OPERATIONS

9745: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES
9746: where wip_entity_id = l_wip_entity_id
9747: and operation_seq_num = l_job_to_op_seq_num;
9748:
9749: UPDATE WIP_OPERATIONS
9750: SET actual_start_date = null,
9751: projected_completion_date = null,
9752: employee_id = null,
9753: LAST_UPDATE_DATE = sysdate,

Line 9968: UPDATE WIP_OPERATIONS

9964: );
9965: END IF;
9966: END IF;
9967: l_stmt_num := 253.61;
9968: UPDATE WIP_OPERATIONS
9969: SET WSM_UPDATE_QUANTITY_TXN_ID = l_wltx_transactions_rec.TRANSACTION_ID,
9970: LAST_UPDATE_DATE = sysdate,
9971: LAST_UPDATED_BY = g_user_id
9972: WHERE wip_entity_id = l_wip_entity_id

Line 10348: UPDATE WIP_OPERATIONS

10344:
10345: END IF;
10346:
10347: --bug 5210799 Update quantity_completed to null if jump from queue
10348: UPDATE WIP_OPERATIONS
10349: SET quantity_completed = 0
10350: WHERE rowid IN
10351: (
10352: SELECT WO.rowid

Line 10353: FROM WIP_OPERATIONS WO,

10349: SET quantity_completed = 0
10350: WHERE rowid IN
10351: (
10352: SELECT WO.rowid
10353: FROM WIP_OPERATIONS WO,
10354: WSM_LOT_MOVE_TXN_INTERFACE WLMTI
10355: WHERE WLMTI.group_id = p_group_id
10356: AND WLMTI.internal_group_id = l_wmti_group_id
10357: AND WLMTI.status = 4

Line 10397: FROM WIP_OPERATIONS wop2,

10393: program_id = g_program_id,
10394: program_update_date = DECODE(g_request_id,NULL,NULL,SYSDATE)
10395: WHERE woy.rowid IN ((
10396: SELECT woy2.rowid
10397: FROM WIP_OPERATIONS wop2,
10398: WIP_OPERATION_YIELDS woy2,
10399: WSM_PARAMETERS wp, -- ESA
10400: WIP_DISCRETE_JOBS wdj, -- NSLBJ
10401: WIP_MOVE_TRANSACTIONS wmt,

Line 10485: FROM WIP_OPERATIONS wop2,

10481: )
10482: UNION ALL
10483: (
10484: SELECT woy2.rowid
10485: FROM WIP_OPERATIONS wop2,
10486: WIP_OPERATION_YIELDS woy2,
10487: WSM_PARAMETERS wp, -- ESA
10488: WIP_DISCRETE_JOBS wdj, -- NSLBJ
10489: WIP_MOVE_TRANSACTIONS wmt,

Line 10586: FROM WIP_OPERATIONS wop2,

10582: program_id = g_program_id,
10583: program_update_date = DECODE(g_request_id,NULL,NULL,SYSDATE)
10584: WHERE woy.rowid IN (
10585: SELECT woy2.rowid
10586: FROM WIP_OPERATIONS wop2,
10587: WIP_OPERATION_YIELDS woy2,
10588: WSM_PARAMETERS wp, -- ESA
10589: WIP_DISCRETE_JOBS wdj, -- NSLBJ
10590: WIP_MOVE_TXN_INTERFACE wti

Line 11051: UPDATE WIP_OPERATIONS

11047: <>
11048: /****************************
11049: --mes
11050: BEGIN
11051: UPDATE WIP_OPERATIONS
11052: SET wsm_costed_quantity_completed = quantity_completed
11053: WHERE ROWID IN
11054: (SELECT WO.ROWID
11055: FROM WIP_OPERATIONS WO, WIP_MOVE_TRANSACTIONS WMT, WSM_LOT_MOVE_TXN_INTERFACE WLMTI

Line 11055: FROM WIP_OPERATIONS WO, WIP_MOVE_TRANSACTIONS WMT, WSM_LOT_MOVE_TXN_INTERFACE WLMTI

11051: UPDATE WIP_OPERATIONS
11052: SET wsm_costed_quantity_completed = quantity_completed
11053: WHERE ROWID IN
11054: (SELECT WO.ROWID
11055: FROM WIP_OPERATIONS WO, WIP_MOVE_TRANSACTIONS WMT, WSM_LOT_MOVE_TXN_INTERFACE WLMTI
11056: WHERE WLMTI.group_id = p_group_id
11057: AND WMT.transaction_id = WLMTI.transaction_id
11058: AND WO.wip_entity_id = WMT.wip_entity_id
11059: AND (WO.operation_seq_num IN (WMT.fm_operation_seq_num, WMT.to_operation_seq_num))

Line 11555: FROM WIP_OPERATIONS WO

11551: --operation seq nums so don't overwrite. Get department_id for each operation
11552: --operation_seq_num = p_fm_operation_seq_num,
11553: --department_id = p_fm_department_id
11554: MTL.department_id = (SELECT department_id
11555: FROM WIP_OPERATIONS WO
11556: WHERE WO.wip_entity_id = p_wip_entity_id
11557: AND WO.operation_seq_num = MTL.operation_seq_num)
11558: WHERE MTL.transaction_header_id = p_mtl_txn_hdr_id;
11559:

Line 12162: FROM BOM_OPERATION_SEQUENCES BOS, WIP_OPERATIONS WO

12158: reference_flag
12159: INTO l_bos_use_org_settings, l_bos_show_next_op_by_default,
12160: x_show_scrap_codes, l_bos_show_lot_attrib, l_bos_mul_res_usage_dates,
12161: l_bos_to_move_mandatory_flag, l_reference_flag
12162: FROM BOM_OPERATION_SEQUENCES BOS, WIP_OPERATIONS WO
12163: WHERE WO.wip_entity_id = p_wip_entity_id
12164: AND WO.operation_seq_num = p_operation_seq_num
12165: AND BOS.operation_sequence_id = WO.operation_sequence_id;
12166: ELSE

Line 12175: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO

12171: nvl(BSO.track_multiple_res_usage_dates, 0), nvl(BSO.to_move_mandatory_flag, 0)
12172: INTO l_bos_use_org_settings, l_bos_show_next_op_by_default,
12173: x_show_scrap_codes, l_bos_show_lot_attrib, l_bos_mul_res_usage_dates,
12174: l_bos_to_move_mandatory_flag
12175: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO
12176: WHERE WO.wip_entity_id = p_wip_entity_id
12177: AND WO.operation_seq_num = p_operation_seq_num
12178: AND BSO.standard_operation_id = WO.standard_operation_id
12179: AND BSO.organization_id = WO.organization_id;

Line 12189: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO

12185: nvl(BSO.track_multiple_res_usage_dates, 0), nvl(BSO.to_move_mandatory_flag, 0)
12186: INTO l_bos_use_org_settings, l_bos_show_next_op_by_default,
12187: x_show_scrap_codes, l_bos_show_lot_attrib, l_bos_mul_res_usage_dates,
12188: l_bos_to_move_mandatory_flag
12189: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO
12190: WHERE WO.wip_entity_id = p_wip_entity_id
12191: AND WO.operation_seq_num = p_operation_seq_num
12192: AND BSO.standard_operation_id = WO.standard_operation_id
12193: AND BSO.organization_id = WO.organization_id;

Line 12215: FROM WIP_OPERATIONS WO

12211:
12212: l_stmt_num := 50;
12213: SELECT WO.actual_start_date, WO.employee_id, nvl(WO.actual_completion_date, sysdate)
12214: INTO x_default_start_date, x_employee_id, x_default_completion_date
12215: FROM WIP_OPERATIONS WO
12216: WHERE WO.wip_entity_id = p_wip_entity_id
12217: AND WO.operation_seq_num = p_operation_seq_num;
12218:
12219: IF (l_end_routing_operation = p_routing_operation) THEN

Line 12847: FROM BOM_OPERATION_SEQUENCES BOS, WIP_OPERATIONS WO

12843: **show_lot_attrib is not applicable for job operation page - always set it to 1**
12844: IF (p_routing_operation IS NOT NULL) THEN
12845: SELECT nvl(BOS.show_lot_attrib, 0)
12846: INTO x_show_lot_attrib
12847: FROM BOM_OPERATION_SEQUENCES BOS, WIP_OPERATIONS WO
12848: WHERE WO.wip_entity_id = p_wip_entity_id
12849: AND WO.operation_seq_num = p_operation_seq_num
12850: AND BOS.operation_sequence_id = WO.operation_sequence_id;
12851: ELSE

Line 13105: UPDATE WIP_OPERATIONS

13101: l_to_costed_quantity_completed := p_primary_move_qty + p_primary_scrap_qty;
13102: END IF;
13103:
13104: IF (l_fm_costed_quantity_completed > 0) THEN
13105: UPDATE WIP_OPERATIONS
13106: SET wsm_costed_quantity_completed = nvl(wsm_costed_quantity_completed, 0) +
13107: l_fm_costed_quantity_completed
13108: WHERE wip_entity_id = p_wip_entity_id
13109: AND operation_seq_num = p_job_fm_op_seq_num;

Line 13113: UPDATE WIP_OPERATIONS

13109: AND operation_seq_num = p_job_fm_op_seq_num;
13110: END IF;
13111:
13112: IF (l_to_costed_quantity_completed > 0) THEN
13113: UPDATE WIP_OPERATIONS
13114: SET wsm_costed_quantity_completed = nvl(wsm_costed_quantity_completed, 0) +
13115: l_to_costed_quantity_completed
13116: WHERE wip_entity_id = p_wip_entity_id
13117: AND operation_seq_num = p_job_to_op_seq_num;

Line 13158: UPDATE WIP_OPERATIONS

13154: l_costed_quantity_completed := 0;
13155: END IF;
13156:
13157: IF (l_costed_quantity_completed > 0) THEN
13158: UPDATE WIP_OPERATIONS
13159: SET wsm_costed_quantity_completed = nvl(wsm_costed_quantity_completed, 0) + l_costed_quantity_completed
13160: WHERE wip_entity_id = p_wip_entity_id
13161: AND operation_seq_num = p_job_fm_op_seq_num;
13162: END IF;

Line 13278: UPDATE WIP_OPERATIONS

13274: l_fm_costed_quantity_completed := p_primary_move_qty + p_primary_scrap_qty;
13275: END IF;
13276:
13277: IF (l_fm_costed_quantity_completed > 0) THEN
13278: UPDATE WIP_OPERATIONS
13279: SET wsm_costed_quantity_completed = nvl(wsm_costed_quantity_completed, 0) -
13280: l_fm_costed_quantity_completed
13281: WHERE wip_entity_id = p_wip_entity_id
13282: AND operation_seq_num = p_job_fm_op_seq_num;

Line 13286: UPDATE WIP_OPERATIONS

13282: AND operation_seq_num = p_job_fm_op_seq_num;
13283: END IF;
13284:
13285: IF (l_to_costed_quantity_completed > 0) THEN
13286: UPDATE WIP_OPERATIONS
13287: SET wsm_costed_quantity_completed = nvl(wsm_costed_quantity_completed, 0) -
13288: l_to_costed_quantity_completed
13289: WHERE wip_entity_id = p_wip_entity_id
13290: AND operation_seq_num = p_job_to_op_seq_num;

Line 13331: UPDATE WIP_OPERATIONS

13327: l_costed_quantity_completed := 0;
13328: END IF;
13329:
13330: IF (l_costed_quantity_completed > 0) THEN
13331: UPDATE WIP_OPERATIONS
13332: SET wsm_costed_quantity_completed = nvl(wsm_costed_quantity_completed, 0) - l_costed_quantity_completed
13333: WHERE wip_entity_id = p_wip_entity_id
13334: AND operation_seq_num = p_job_fm_op_seq_num;
13335: END IF;