where LANGUAGE = 'US' AND Upper(lookup_type) LIKE Upper('WIP_JOB_STATUS') JOB_TYPE :Type of discrete job WIP_SUPPLY_TYPE :Method of material consumption within WIP START_QUANTITY:Job start quantity QUANTITY_COMPLETED:Current job quantity completed COMMON_BOM_SEQUENCE_ID:-->BOM_COMPONENTS_B.B...
and ML.LOOKUP_TYPE = 'WIP_SUPPLY' and ML.LOOKUP_CODE = WRO.WIP_SUPPLY_TYPE and (MFG_LOOKUPS_WJS.LOOKUP_TYPE = 'WIP_JOB_STATUS') and (wdj.STATUS_TYPE = MFG_LOOKUPS_WJS.LOOKUP_CODE) and CIC.INVENTORY_ITEM_ID = MSI2.INVENTORY_ITEM_ID and CIC.ORGANIZATION_ID = MSI2.ORGANIZATION_ID ...
WIP_SUPPLY_TYPE :Method of material consumption within WIP REQUIRED_QUANTITY:Component quantity required QUANTITY_ISSUED:Component quantity issued SUPPLY_SUBINVENTORY:Subinventory used to supply component to WIP SUPPLY_LOCATOR_ID:Locator used to supply component to WIP SEGMENT1:Component Item segment QUANTIT...
WIP_SUPPLY_TYPE :Method of material consumption within WIP REQUIRED_QUANTITY:Component quantity required QUANTITY_ISSUED:Component quantity issued SUPPLY_SUBINVENTORY:Subinventory used to supply component to WIP SUPPLY_LOCATOR_ID:Locator used to supply component to WIP SEGMENT1:Component Item segment QUANTIT...
ID, AA.SOURCE_LINE_ID 行 , AA.STATUS_TYPE 状态 TYPE AA.PRIMARY_ITEM_ID 装 ID, CC.SEGMENT1 物料编码 CC.DESCRIPTION 物料说明, AA.FIRM_PLANNED_FLAG, AA.JOB_TYPE 作业类型 AA.WIP_SUPPLY_TYPE 供应TYPE, AA.CLASS_CODE 任务类别, AA.SCHEDULED_START_DATE...
WIP_SUPPLY_TYPE :Method of material consumption within WIP Value Meaning START_QUANTITY:Job start quantity QUANTITY_COMPLETED:Current job quantity completed COMMON_BOM_SEQUENCE_ID:--> BOM_COMPONENTS_B.BILL_SEQUENCE_ID COMMON_ROUTING_SEQUENCE_ID:-->BOM_OPERATIONAL_ROUTINGS.ROUTING_SEQUENCE_ID ...
在WIP中制造: build_in_wip_flag 供应类型: wip_supply_type(推式:1,装配拉式:2,工序拉式:3,批量:4,供应商:5,虚拟:6) 供应子库存: wip_supply_subinventory 供应货位: wip_supply_locator_id 库存存储: inventory_carry_penalty 工序损耗: operation_slack_penalty ...
9、标准消耗量触发 消耗比较稳定的物料Operation Pull 拉式发料,工序移动至To Move时自动按标准消耗量触发 消耗比较稳定的物料BOM_COMPONENTS_B.WIP_SUPPLY_TYPE存储发料方式ValueMeaning1Push2Assembly Pull3Operation Pull4Bulk5Supplier6Phantom7Based on Bill 3.2 定义ROUTING路径:Bill Of Materials > Routings> Rout...
status_type数状态 primary_item_id数加工件内码 firm_planned_flag数 job_type数作业类型(1。标准,3。非标准) wip_supply_type数供应类型 class_code VARCHAR2(10)任务类别 material_account数物料帐目 material_overhead_account数物料经常费用帐目 resource_account数资源帐目 outside_processing_account数外(超)处...
status_type数状态 primary_item_id数加工件内码 firm_planned_flag数 job_type数作业类型(1。标准,3。非标准) wip_supply_type数供应类型 class_code VARCHAR2(10)任务类别 material_account数物料帐目 material_overhead_account数物料经常费用帐目 resource_account数资源帐目 outside_processing_account数外(超)处...