[Home] [Help]
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;
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),
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),
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
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);
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||
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,
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: