文件名称：please help me
文件大小：2KB
文件格式：TXT
更新时间：2010-09-17 07:18:22
,select oracle
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,
PROCESS_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