[Home] [Help]
50: ** X_Wip_Entity_Id IN NUMBER,
51: ** X_Organization_Id IN NUMBER,
52: ** X_From_Op IN NUMBER,
53: ** X_To_Op IN NUMBER, -- op seq num to be added in WO
54: ** X_Standard_Operation_Id IN NUMBER,
55: ** x_error_code OUT NUMBER,
56: ** x_error_msg OUT VARCHAR2
57: ** ) IS
58: */
65: X_Organization_Id IN NUMBER,
66: X_From_Op IN NUMBER,
67: X_To_Op IN NUMBER,
68: --NSO Modification by abedajna
69: X_Standard_Operation_Id IN NUMBER,
70: X_Op_Seq_Id IN NUMBER,
71: x_error_code OUT NOCOPY NUMBER,
72: x_error_msg OUT NOCOPY VARCHAR2)
73: IS
78: X_Wip_Entity_Id,
79: X_Organization_Id,
80: X_From_Op,
81: X_To_Op,
82: X_Standard_Operation_Id,
83: X_Op_Seq_Id,
84: x_error_code,
85: x_error_msg,
86: null,
97: X_Wip_Entity_Id IN NUMBER,
98: X_Organization_Id IN NUMBER,
99: X_From_Op IN NUMBER,
100: X_To_Op IN NUMBER, -- op seq num to be added in WO
101: X_Standard_Operation_Id IN NUMBER,
102: X_Op_Seq_Id IN NUMBER, -- CZH.I_OED-2, this is the replacement
103: x_error_code OUT NOCOPY NUMBER,
104: x_error_msg OUT NOCOPY VARCHAR2,
105: p_txn_quantity IN NUMBER,
158: ' X_Wip_Entity_Id '||X_Wip_Entity_Id||
159: ' X_Organization_Id '||X_Organization_Id||
160: ' X_From_Op '||X_From_Op||
161: ' X_To_Op '||X_To_Op||
162: ' X_Standard_Operation_Id '||X_Standard_Operation_Id||
163: ' X_Op_Seq_Id '||X_Op_Seq_Id||
164: ' p_txn_quantity '||p_txn_quantity||
165: ' p_reco_op_flag '||p_reco_op_flag||
166: ' p_to_rtg_op_seq_num '||p_to_rtg_op_seq_num||
289:
290: --move enh added the IF
291: IF ((g_aps_wps_profile='N') AND (X_Op_Seq_Id IS NOT NULL)) THEN
292: -- NSO Modification by abedajna begin
293: -- Replaced Standard Operation Id by the op_seq_id
294:
295: -- BA: CZH.I_OED-1, should honor ROUTING_REVISION_DATE
296: l_stat_num := 230;
297: --move enh added start_quantity
308: FROM BOM_OPERATION_SEQUENCES bos,
309: WIP_DISCRETE_JOBS wdj
310: WHERE wdj.WIP_ENTITY_ID = X_Wip_Entity_Id
311: AND wdj.ORGANIZATION_ID = X_Organization_Id
312: -- AND bos.standard_operation_id = X_Standard_Operation_Id
313: AND bos.operation_sequence_id = X_Op_Seq_Id
314: AND bos.routing_sequence_id = wdj.common_routing_sequence_id
315: --BC: CZH.I_OED-1, should honor ROUTING_REVISION_DATE
316: --bug1725145
378: PROGRAM_APPLICATION_ID,
379: PROGRAM_ID,
380: PROGRAM_UPDATE_DATE,
381: OPERATION_SEQUENCE_ID,
382: STANDARD_OPERATION_ID,
383: DEPARTMENT_ID,
384: DESCRIPTION,
385: SCHEDULED_QUANTITY,
386: QUANTITY_IN_QUEUE,
434: DECODE(p_appl_id, 0, '', p_appl_id),
435: DECODE(p_commit, 1, p_prog_id, -999),
436: DECODE(p_prog_id, 0, '', p_curdate),
437: SEQ.OPERATION_SEQUENCE_ID,
438: SEQ.STANDARD_OPERATION_ID,
439: SEQ.DEPARTMENT_ID,
440: SEQ.OPERATION_DESCRIPTION,
441: ROUND(DJ.Start_Quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
442: 0, 0, 0, 0, 0, 0,
489: AND DJ.WIP_ENTITY_ID = X_Wip_Entity_Id
490: AND DJ.ORGANIZATION_ID = X_Organization_Id
491: AND SEQ.operation_sequence_id = X_Op_Seq_Id
492: --NSO Modification by abedajna begin
493: --AND SEQ.Standard_operation_id = X_Standard_Operation_Id
494: --NSO Modification by abedajna end
495: AND SEQ.routing_sequence_id = dj.common_routing_sequence_id;
496:
497: --bugfix 2026218
533:
534: -- OSP FP I begin
535: l_stat_num := 290;
536: l_po_move_exists := WSMPUTIL.check_po_move (
537: p_sequence_id => x_standard_operation_id,
538: p_sequence_id_type => 'S' ,
539: p_routing_rev_date => p_rtg_rev_date,
540: x_err_code => x_error_code ,
541: x_err_msg => x_error_msg ) ;
579: PROGRAM_APPLICATION_ID,
580: PROGRAM_ID,
581: PROGRAM_UPDATE_DATE,
582: OPERATION_SEQUENCE_ID,
583: STANDARD_OPERATION_ID,
584: DEPARTMENT_ID,
585: DESCRIPTION,
586: SCHEDULED_QUANTITY,
587: QUANTITY_IN_QUEUE,
636: DECODE(p_appl_id, 0, '', p_appl_id),
637: DECODE(p_commit, 1, p_prog_id, -999),
638: DECODE(p_prog_id, 0, '', p_curdate),
639: NULL, --SEQ.OPERATION_SEQUENCE_ID,
640: bso.STANDARD_OPERATION_ID,
641: bso.DEPARTMENT_ID,
642: bso.OPERATION_DESCRIPTION,
643: ROUND(DJ.Start_Quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
644: 0, 0, 0, 0, 0, 0,
674: l_fm_op_seq_id, --EC: BUG2256872
675: DJ.QUANTITY_SCRAPPED,
676: 0,
677: BSO.LOWEST_ACCEPTABLE_YIELD
678: FROM BOM_STANDARD_OPERATIONS bso,
679: WIP_DISCRETE_JOBS DJ
680: WHERE DJ.WIP_ENTITY_ID = X_Wip_Entity_Id
681: AND DJ.ORGANIZATION_ID = X_Organization_Id
682: AND bso.Standard_operation_id = X_Standard_Operation_Id;
678: FROM BOM_STANDARD_OPERATIONS bso,
679: WIP_DISCRETE_JOBS DJ
680: WHERE DJ.WIP_ENTITY_ID = X_Wip_Entity_Id
681: AND DJ.ORGANIZATION_ID = X_Organization_Id
682: AND bso.Standard_operation_id = X_Standard_Operation_Id;
683:
684: -- BA: bugfix 2626658/2681671 moved to here from below
685: --copy attachment from operations document attachment defined in the BOM standard operation form.
686: if sql%rowcount > 0 then
681: AND DJ.ORGANIZATION_ID = X_Organization_Id
682: AND bso.Standard_operation_id = X_Standard_Operation_Id;
683:
684: -- BA: bugfix 2626658/2681671 moved to here from below
685: --copy attachment from operations document attachment defined in the BOM standard operation form.
686: if sql%rowcount > 0 then
687: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
688: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',
689: X_FROM_PK1_VALUE => to_char(x_STANDARD_OPERATION_ID),
684: -- BA: bugfix 2626658/2681671 moved to here from below
685: --copy attachment from operations document attachment defined in the BOM standard operation form.
686: if sql%rowcount > 0 then
687: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
688: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',
689: X_FROM_PK1_VALUE => to_char(x_STANDARD_OPERATION_ID),
690: X_TO_ENTITY_NAME => 'WSM_LOT_BASED_OPERATIONS',
691: X_TO_PK1_VALUE => to_char(x_wip_entity_id),
692: X_TO_PK2_VALUE => to_char(x_to_op),
685: --copy attachment from operations document attachment defined in the BOM standard operation form.
686: if sql%rowcount > 0 then
687: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
688: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',
689: X_FROM_PK1_VALUE => to_char(x_STANDARD_OPERATION_ID),
690: X_TO_ENTITY_NAME => 'WSM_LOT_BASED_OPERATIONS',
691: X_TO_PK1_VALUE => to_char(x_wip_entity_id),
692: X_TO_PK2_VALUE => to_char(x_to_op),
693: X_TO_PK3_VALUE => to_char(x_organization_id),
744: -- BD: bugfix 2626658/2681671
745: -- the following attachement is for jump operation. should move inside Jump condition
746: /******
747: --bugfix 2026218
748: --copy attachment from operations document attachment defined in the BOM standard operation form.
749: if sql%rowcount > 0 then
750: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
751: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',
752: X_FROM_PK1_VALUE => to_char(x_STANDARD_OPERATION_ID),
747: --bugfix 2026218
748: --copy attachment from operations document attachment defined in the BOM standard operation form.
749: if sql%rowcount > 0 then
750: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
751: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',
752: X_FROM_PK1_VALUE => to_char(x_STANDARD_OPERATION_ID),
753: X_TO_ENTITY_NAME => 'WSM_LOT_BASED_OPERATIONS',
754: X_TO_PK1_VALUE => to_char(x_wip_entity_id),
755: X_TO_PK2_VALUE => to_char(x_to_op),
748: --copy attachment from operations document attachment defined in the BOM standard operation form.
749: if sql%rowcount > 0 then
750: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
751: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',
752: X_FROM_PK1_VALUE => to_char(x_STANDARD_OPERATION_ID),
753: X_TO_ENTITY_NAME => 'WSM_LOT_BASED_OPERATIONS',
754: X_TO_PK1_VALUE => to_char(x_wip_entity_id),
755: X_TO_PK2_VALUE => to_char(x_to_op),
756: X_TO_PK3_VALUE => to_char(x_organization_id),
1002: scheduled_flag,
1003: assigned_units,
1004: maximum_assigned_units, /* ST : Detailed Scheduling */
1005: autocharge_type,
1006: standard_rate_flag,
1007: applied_resource_units,
1008: applied_resource_value,
1009: attribute_category,
1010: attribute1,
1052: BSSOR.schedule_flag,
1053: BSSOR.assigned_units,
1054: BSSOR.assigned_units, /* ST : Detailed Scheduling */
1055: BSSOR.autocharge_type,
1056: BSSOR.standard_rate_flag,
1057: 0, --WCOR.applied_resource_units,
1058: 0, -- WCOR.applied_resource_value,
1059: BSSOR.attribute_category,
1060: BSSOR.attribute1,
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;
1088: END IF;
1089: --moved the following code to after processing move in form and interface
1090:
1295: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE,
1296: RESOURCE_ID, UOM_CODE,
1297: BASIS_TYPE, USAGE_RATE_OR_AMOUNT, ACTIVITY_ID,
1298: SCHEDULED_FLAG, ASSIGNED_UNITS, AUTOCHARGE_TYPE,
1299: STANDARD_RATE_FLAG, APPLIED_RESOURCE_UNITS, APPLIED_RESOURCE_VALUE,
1300: START_DATE, COMPLETION_DATE,
1301: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1302: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5,
1303: ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,
1315: OPS.PROGRAM_APPLICATION_ID, OPS.PROGRAM_ID,
1316: OPS.PROGRAM_UPDATE_DATE, ORS.RESOURCE_ID, RSC.UNIT_OF_MEASURE,
1317: ORS.BASIS_TYPE, ORS.USAGE_RATE_OR_AMOUNT, ORS.ACTIVITY_ID,
1318: ORS.SCHEDULE_FLAG, ORS.ASSIGNED_UNITS, ORS.AUTOCHARGE_TYPE,
1319: ORS.STANDARD_RATE_FLAG, 0, 0,
1320: OPS.FIRST_UNIT_START_DATE, OPS.LAST_UNIT_COMPLETION_DATE,
1321: ORS.ATTRIBUTE_CATEGORY, ORS.ATTRIBUTE1, ORS.ATTRIBUTE2,
1322: ORS.ATTRIBUTE3, ORS.ATTRIBUTE4, ORS.ATTRIBUTE5,
1323: ORS.ATTRIBUTE6, ORS.ATTRIBUTE7, ORS.ATTRIBUTE8,
1352: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE,
1353: RESOURCE_ID, UOM_CODE,
1354: BASIS_TYPE, USAGE_RATE_OR_AMOUNT, ACTIVITY_ID,
1355: SCHEDULED_FLAG, ASSIGNED_UNITS, AUTOCHARGE_TYPE,
1356: STANDARD_RATE_FLAG, APPLIED_RESOURCE_UNITS, APPLIED_RESOURCE_VALUE,
1357: START_DATE, COMPLETION_DATE,
1358: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1359: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5,
1360: ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,
1371: OPS.PROGRAM_APPLICATION_ID, OPS.PROGRAM_ID,
1372: OPS.PROGRAM_UPDATE_DATE, ORS.RESOURCE_ID, RSC.UNIT_OF_MEASURE,
1373: ORS.BASIS_TYPE, ORS.USAGE_RATE_OR_AMOUNT, ORS.ACTIVITY_ID,
1374: ORS.SCHEDULE_FLAG, ORS.ASSIGNED_UNITS, ORS.AUTOCHARGE_TYPE,
1375: ORS.STANDARD_RATE_FLAG, 0, 0,
1376: OPS.FIRST_UNIT_START_DATE, OPS.LAST_UNIT_COMPLETION_DATE,
1377: ORS.ATTRIBUTE_CATEGORY, ORS.ATTRIBUTE1, ORS.ATTRIBUTE2,
1378: ORS.ATTRIBUTE3, ORS.ATTRIBUTE4, ORS.ATTRIBUTE5,
1379: ORS.ATTRIBUTE6, ORS.ATTRIBUTE7, ORS.ATTRIBUTE8,
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
1393: AND ORS.RESOURCE_ID = RSC.RESOURCE_ID
1394: AND RSC.ORGANIZATION_ID = OPS.ORGANIZATION_ID;
1395: END IF;
1396: -- End bugfix 1523334
1536: l_stat_num := 5;
1537: BEGIN
1538: SELECT operation_seq_num,
1539: WIP_CONSTANTS.SCRAP,
1540: nvl(to_number(STANDARD_OPERATION_ID),0),
1541: ml.meaning
1542: INTO l_op,
1543: l_step,
1544: l_std_operation_id,
1571: SELECT operation_seq_num,
1572: decode(quantity_in_queue, 0,
1573: decode(quantity_running, 0, WIP_CONSTANTS.TOMOVE, WIP_CONSTANTS.RUN),
1574: WIP_CONSTANTS.QUEUE),
1575: nvl(to_number(STANDARD_OPERATION_ID),0),
1576: ml.meaning
1577: INTO l_op,
1578: l_step,
1579: l_std_operation_id,
1632: l_stat_num := 10;
1633:
1634: --***VJ Changed for Performance Upgrade***--
1635: BEGIN
1636: --MES replacing WSM_OPERATION_DETAILS with BOM_STANDARD_OPERATIONS
1637: /*
1638: SELECT QUEUE_MANDATORY_FLAG,
1639: RUN_MANDATORY_FLAG,
1640: TO_MOVE_MANDATORY_FLAG
1641: INTO l_queue_flag,
1642: l_run_flag,
1643: l_to_move_flag
1644: FROM WSM_OPERATION_DETAILS
1645: WHERE STANDARD_OPERATION_ID = p_std_op_id;
1646: */
1647: SELECT decode(QUEUE_MANDATORY_FLAG, 0, 2, NULL, 2, QUEUE_MANDATORY_FLAG),
1648: decode(RUN_MANDATORY_FLAG, 0, 2, NULL, 2, RUN_MANDATORY_FLAG),
1649: decode(TO_MOVE_MANDATORY_FLAG, 0, 2, NULL, 2, TO_MOVE_MANDATORY_FLAG)
1649: decode(TO_MOVE_MANDATORY_FLAG, 0, 2, NULL, 2, TO_MOVE_MANDATORY_FLAG)
1650: INTO l_queue_flag,
1651: l_run_flag,
1652: l_to_move_flag
1653: FROM BOM_STANDARD_OPERATIONS
1654: WHERE STANDARD_OPERATION_ID = p_std_op_id;
1655: EXCEPTION
1656: WHEN NO_DATA_FOUND THEN
1657: return(1);
1650: INTO l_queue_flag,
1651: l_run_flag,
1652: l_to_move_flag
1653: FROM BOM_STANDARD_OPERATIONS
1654: WHERE STANDARD_OPERATION_ID = p_std_op_id;
1655: EXCEPTION
1656: WHEN NO_DATA_FOUND THEN
1657: return(1);
1658: END;
1665: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1666: l_msg_tokens.delete;
1667: WSM_log_PVT.logMessage (
1668: p_module_name => l_module,
1669: p_msg_text => 'After SELECT from BOM_STANDARD_OPERATIONS '||
1670: ';l_queue_flag '||
1671: l_queue_flag||
1672: ';l_run_flag '||
1673: l_run_flag||
1685: -- Replaced by above BEGIN-END block--
1686: --*** SELECT COUNT(*)
1687: --*** INTO l_row_count
1688: --*** FROM WSM_OPERATION_DETAILS
1689: --*** WHERE STANDARD_OPERATION_ID = p_std_op_id;
1690: --***
1691: --*** IF l_row_count = 0 THEN
1692: --*** return(1);
1693: --*** END IF;
1700: --*** INTO l_queue_flag,
1701: --*** l_run_flag,
1702: --*** l_to_move_flag
1703: --*** FROM WSM_OPERATION_DETAILS
1704: --*** WHERE STANDARD_OPERATION_ID = p_std_op_id;
1705: --***VJ End Deletions***--
1706:
1707: IF l_queue_flag = 2 AND l_run_flag = 2 AND l_to_move_flag = 2 THEN
1708: return(1);
1793: x_error_code,
1794: x_error_msg);
1795:
1796: l_stat_num := 20;
1797: --MES replacing WSM_OPERATION_DETAILS with BOM_STANDARD_OPERATIONS
1798: /*
1799: SELECT SECONDARY_INVENTORY_NAME,
1800: INVENTORY_LOCATION_ID
1801: INTO l_secondary_inventory_name,
1801: INTO l_secondary_inventory_name,
1802: l_secondary_locator
1803: FROM WSM_OPERATION_DETAILS WOD,
1804: BOM_OPERATION_SEQUENCES BOS
1805: WHERE WOD.STANDARD_OPERATION_ID = BOS.STANDARD_OPERATION_ID
1806: AND BOS.OPERATION_SEQUENCE_ID = l_end_op_seq_id;
1807: */
1808: SELECT DEFAULT_SUBINVENTORY,
1809: DEFAULT_LOCATOR_ID
1808: SELECT DEFAULT_SUBINVENTORY,
1809: DEFAULT_LOCATOR_ID
1810: INTO l_secondary_inventory_name,
1811: l_secondary_locator
1812: FROM BOM_STANDARD_OPERATIONS BSO,
1813: BOM_OPERATION_SEQUENCES BOS
1814: WHERE BSO.STANDARD_OPERATION_ID = BOS.STANDARD_OPERATION_ID
1815: AND BOS.OPERATION_SEQUENCE_ID = l_end_op_seq_id;
1816:
1810: INTO l_secondary_inventory_name,
1811: l_secondary_locator
1812: FROM BOM_STANDARD_OPERATIONS BSO,
1813: BOM_OPERATION_SEQUENCES BOS
1814: WHERE BSO.STANDARD_OPERATION_ID = BOS.STANDARD_OPERATION_ID
1815: AND BOS.OPERATION_SEQUENCE_ID = l_end_op_seq_id;
1816:
1817: EXCEPTION
1818: WHEN others then
2261: PROGRAM_APPLICATION_ID,
2262: PROGRAM_ID,
2263: PROGRAM_UPDATE_DATE,
2264: OPERATION_SEQUENCE_ID,
2265: STANDARD_OPERATION_ID,
2266: DEPARTMENT_ID,
2267: DESCRIPTION,
2268: SCHEDULED_QUANTITY,
2269: QUANTITY_IN_QUEUE,
2317: DECODE(p_program_application_id, 0, '', p_program_application_id),
2318: DECODE(p_commit, 1, p_program_id, -999),
2319: DECODE(p_program_id, 0, '', SYSDATE),
2320: WCO.OPERATION_SEQUENCE_ID,
2321: WCO.STANDARD_OPERATION_ID,
2322: WCO.DEPARTMENT_ID,
2323: WCO.OPERATION_DESCRIPTION,
2324: /*bug 3686872 added nvl(WCO.RECO_SCHEDULED_QUANTITY to the code below removed p_txn_quantity*/
2325: --ROUND(nvl(p_txn_quantity, 0), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
3183: group_sequence_number,
3184: parent_resource_seq,
3185: /* ST : Detailed Scheduling */
3186: AUTOCHARGE_TYPE,
3187: STANDARD_RATE_FLAG, APPLIED_RESOURCE_UNITS, APPLIED_RESOURCE_VALUE,
3188: START_DATE, COMPLETION_DATE,
3189: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
3190: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5,
3191: ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,
3226: , WCOR.group_sequence_num
3227: , WCOR.parent_resource_seq_num
3228: /* ST : Detailed Scheduling */
3229: , WCOR.AUTOCHARGE_TYPE
3230: , WCOR.STANDARD_RATE_FLAG
3231: , 0
3232: , 0
3233: , decode(recommended, 'Y', nvl(RECO_START_DATE, p_txn_date), p_txn_date)
3234: , decode(recommended, 'Y', nvl(RECO_COMPLETION_DATE, p_txn_date), p_txn_date)
3287: scheduled_flag,
3288: assigned_units,
3289: maximum_assigned_units, /* ST : Detailed Scheduling */
3290: autocharge_type,
3291: standard_rate_flag,
3292: applied_resource_units,
3293: applied_resource_value,
3294: attribute_category,
3295: attribute1,
3332: WCOR.schedule_flag,
3333: WCOR.assigned_units,
3334: WCOR.max_assigned_units,
3335: WCOR.autocharge_type,
3336: WCOR.standard_rate_flag,
3337: 0, --WCOR.applied_resource_units,--move enh?
3338: 0, -- WCOR.applied_resource_value, --move enh?
3339: WCOR.attribute_category,
3340: WCOR.attribute1,
3777: FROM BOM_STD_OP_SCRAP_CODES BSOSC,
3778: WIP_OPERATIONS WO
3779: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
3780: AND WO.OPERATION_SEQ_NUM = p_to_job_op_seq_num
3781: AND BSOSC.STANDARD_OPERATION_ID = WO.STANDARD_OPERATION_ID;
3782:
3783: l_stmt_num := 93;
3784: INSERT INTO WSM_OP_REASON_CODES
3785: (
3809: FROM BOM_STD_OP_BONUS_CODES BSOSC,
3810: WIP_OPERATIONS WO
3811: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
3812: AND WO.OPERATION_SEQ_NUM = p_to_job_op_seq_num
3813: AND BSOSC.STANDARD_OPERATION_ID = WO.STANDARD_OPERATION_ID;
3814:
3815: UPDATE WSM_LOT_BASED_JOBS
3816: SET current_job_op_seq_num = p_to_job_op_seq_num,
3817: current_rtg_op_seq_num = p_to_rtg_op_seq_num