开发工具:
文件大小: 2kb
下载次数: 0
上传时间: 2007-08-28
详细说明： SELECT OPERATION_SEQ_NUM,
STANDARD_OPERATION_CODE,
REFERENCE_FLAG,
DEPARTMENT_CODE,
EFFECTIVITY_DATE,DISABLE_DATE,
OPTION_DEPENDENT_FLAG,
OPERATION_LEAD_TIME_PERCENT,
PROCESS_SEQ_NUM,
PROCES S_CODE,
LINE_OP_SEQ_NUM,
LINE_OP_CODE,
YIELD,
CUMULATIVE_YIELD,
REVERSE_CUMULATIVE_YIELD,
INCLUDE_IN_ROLLUP,
OPERATION_YIELD_ENABLED,
NET_PLANNING_PERCENT,
COUNT_POINT_FLAG,
AUTOCHARGE_FLAG,
BACKFLUSH_FLAG,
MINIMUM_TRANSFER_QUANTITY,
SHUTDOWN_TYPE_VALUE,
SHUTDOWN_TYPE,
IMPL_CB,
CHANGE_NOTICE,
OPERATION_DESCRIPTION,
LONG_DESCRIPTION,
LABOR_TIME_CALC,
MACHINE_TIME_CALC,
TOTAL_TIME_CALC,
LABOR_TIME_USER,
MACHINE_TIME_USER,
TOTAL_TIME_USER,
ROW_ID,
OPERATION_SEQUENCE_ID,
ROUTING_SEQUENCE_ID,
STANDARD_OPERATION_ID,
DEPARTMENT_ID,
LOCATION_ID,
PROCESS_OP_SEQ_ID,
LINE_OP_SEQ_ID,
COUNT_POINT_TYPE,
CREATION_DATE,
LAST_UPDATE_DATE,
PROGRAM_UPDATE_DATE,
IMPLEMENTATION_DATE,
LAST_UPDATED_BY,
CREATED_BY,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,
OPERATION_TYPE
FROM BOM_OPERATION_SEQUENCES_V
WHERE (
(2 IN (2,3) and NVL(operation_type, 1) =1 ) OR(2 = 1 and operation_type = DECODE(1, 4, 1, 1))
)
AND (
('' = 2 AND process_op_seq_id = '')OR ('' = 3 and line_op_seq_id = '') OR ('' is null)
)
and (
1 = 1 or (1 = 2 and (effectivity_date <= to_date('28-08-2007 11:39:33','DD-MM-YYYY HH24:MI:SS') and nvl(disable_date, to_date('28-08-2007 11:39:33','DD-MM-YYYY HH24:MI:SS') + 1) >= to_date('28-08-2007 11:39:33','DD-MM-YYYY HH24:MI:SS'))) or (1 = 3 and (nvl(disable_date, to_date('28-08-2007 11:39:33','DD-MM-YYYY HH24:MI:SS') + 1) >= to_date('28-08-2007 11:39:33','DD-MM-YYYY HH24:MI:SS')))
)
AND (
(('' = 1 and implementation_date is not null) or ('' = 2 and implementation_date is null) or '' is null ) AND ((1 = 1 and implementation_date is not null) or 1 = 2)
)
and (ROUTING_SEQUENCE_ID=22274)
order by OPERATION_SEQ_NUM
...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
