DBA Data[Home] [Help]

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 8816: FROM wip_operations wo

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

Line 9148: FROM WIP_OPERATIONS

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

Line 9400: UPDATE WIP_OPERATIONS

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

Line 9543: UPDATE WIP_OPERATIONS

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

Line 9559: --FROM WSM_COPY_OPERATIONS WCO, WIP_OPERATIONS WO

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

Line 9593: --FROM WSM_COPY_OPERATIONS WCO, WIP_OPERATIONS WO

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

Line 9671: -- FROM WIP_OPERATIONS WO

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

Line 9696: UPDATE WIP_OPERATIONS

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

Line 9721: UPDATE WIP_OPERATIONS

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

Line 9751: UPDATE WIP_OPERATIONS

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

Line 9970: UPDATE WIP_OPERATIONS

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

Line 10350: UPDATE WIP_OPERATIONS

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

Line 10355: FROM WIP_OPERATIONS WO,

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

Line 10399: FROM WIP_OPERATIONS wop2,

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

Line 10487: FROM WIP_OPERATIONS wop2,

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

Line 10588: FROM WIP_OPERATIONS wop2,

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

Line 11053: UPDATE WIP_OPERATIONS

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

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

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

Line 11557: FROM WIP_OPERATIONS WO

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

Line 12164: FROM BOM_OPERATION_SEQUENCES BOS, WIP_OPERATIONS WO

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

Line 12177: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO

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

Line 12191: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO

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

Line 12217: FROM WIP_OPERATIONS WO

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

Line 12849: FROM BOM_OPERATION_SEQUENCES BOS, WIP_OPERATIONS WO

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

Line 13107: UPDATE WIP_OPERATIONS

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

Line 13115: UPDATE WIP_OPERATIONS

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

Line 13160: UPDATE WIP_OPERATIONS

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

Line 13280: UPDATE WIP_OPERATIONS

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

Line 13288: UPDATE WIP_OPERATIONS

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

Line 13333: UPDATE WIP_OPERATIONS

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