产线数据查询表记录1

//祇,癘魁
select * from sfism4.r_smt_log_t
where line_name='S216' and feeder_no='117' and key_part_no='0303312225'//癘魁

select * from sfism4.r_pkg_managed_t //讽玡PKG篈
where pkg_id='SHKPODAK012111208001336'

SFISM4.R_PKG_CURRENT_T

select * from kitting.r_cbjb_t_kit_out_detail//祇癘魁

select * from KITTING.R_CBJB_T_KIT_SMTTOKIT//癶

select * from sfism4.r_pkg_managed_detail_t//玻絬篈

SELECT * FROM SFISM4.R_CBJB_T_KIT_OUT_CHECK_SCAN
祇簗苯磞,簗苯磞

select * from kitting.c_cbjb_t_curr
–兵絬讽玡

琩高 秨 SFISM4.R_MO_BASE_T

SFISM4.R_TEMP_LINE_CUREENT_MODEL_T
–兵絬讽玡诀贺

select * from kitting.c_cbjb_t_kit_cbcode
kitting]

select * from kitting.c_cbjb_t_line
kitting祇(称)絬


讽玡ノPKG,穦update赣,uapdateê瓂笵ノPKG_ID单獺
SELECT * FROM SFISM4.R_PKG_CURRENT_T

岿粇癘魁,岿癘魁
SFISM4.R_SMT_LOG_ERROR_T
岿癘魁
SELECT * FROM SFIS1.C_SMT_WARNING_T
SELECT * FROM SFISM4.R_SMT_WARNING_T
SELECT * FROM SFISM4.R_SMT_LOG_ERROR_T


SMO跌瓜
SELECT a.hostid, a.station_number, a.node_ip, b.line_name, section_name,
b.group_name, b.station_name, c.station_type, d.work_type,
d.work_type_index, d.SECOND, d.fork, d.LENGTH, d.rule, https://www.360docs.net/doc/d48907582.html,ST,
e.code AS code, e.param2, f.storedproc, f.storedproc_index,
f.return_flag, g.storedparam, a.in_type, a.out_type, d.run_prior
FROM sfis1.c_qway_config_t a,
sfis1.c_station_config_t b,
sfis1.c_station_type c,
sfis1.c_work_type d,
sfis1.c_work_type_name e,
sfis1.c_work_type_storedproc f,
sfis1.c_storedproc_param_t g
WHERE a.hostid = b.hostid
AND a.station_number = b.station_number
AND b.station_number = c.station_number
AND c.station_type = d.station_type
AND d.work_type = e.work_type
AND d.station_type = f.station_type
AND d.work_type = f.work_type
AND f.storedproc = g.storedname
ORDER BY station_number, work_type_index, storedproc_index;


SELECT * FROM SFIS1.MYSMO_CONFIG

select * from sfis1.c_qway_config_t

select * from sfis1.c_station_config_t

select * from sfis1.c_station_type

select * from sfis1.c_work_type

select * from sfis1.c_work_type_name

select * from sfis1.c_work_type_storedproc

select * from sfis1.c_storedproc_param_t



sfis1.C_GROUP_CONFIG_T ゲ斗ノ

sfis1.C_STATION_TYPE_NAME ゲ斗ノ

select * from sfis1.c_work_type_name---纗筁祘摸穝纗筁祘

SELECT * FROM SFIS1. C_STATION_TYPE_NAME--摸(穝

纗筁祘

SFIS1. C_LINE_DESC_T

SFIS1. C_HOST_NAME_T ミ絬砰

埃狡纗摸:
sfis1.c_work_type_storedproc
sfis1.c_work_type
sfis1.c_work_type_storedproc




秆姜╰参
SFIS1.UNHOLD_CREATE_TEMP_APPLY
SELECT GROUP_NAME INTO GROUP_N FROM SFIS1.C_GROUP_SEQUENCE_T

select * from SFISM4.R_TEMP_SNS_T
where ssn='M$35-D065876-L$VD4202061707'

select * from SFISM4.R_APPLY_SN_LIST_T
where serial_number='M$35-D065876-L$VD4202061707'

select * from SFISM4.R_APPLY_SN_LIST_T
where table_no='H12011105'

select * from SFISM4.R_PART_MAP_T

select * from SFISM4.R_TEMP_UNHOLD_TABLE_T

select * from SFIS1.C_HOLD_LIST_T
where table_no like'%12011105%'


kitting
q1w2e3r4

瞶砯
SHIPPING_LIST_CHECK_SCAN


纗筁祘礚猭穝.
SELECT * FROM sfis1.c_storedproc_param_t
纗筁祘㎝把计礚猭穝,穝纗筁祘礚猭础sfis1.c_storedproc_param_t

TESTDATA TABLE


絚腹綪腹 璶猔種Τ⊿Τ畐!

秈畐 SFISM4.R_INOUT_STOCK_T
SFISM4.R_INOUT_STOCK_ADD_T


Data Source=10.106.136.130; server=PCBADB;user id=sfis1;pwd=sfis1
Data Source=oracle10g; server=PCBADB;user id=sfis1;pwd=sfis1

ICT祘ΑUPDATE 计沮 SFIS1.ICT_AUTO_LOGGING


奎籌兵絏/╰参ノ
select * from sfism4.r_tinsolder_basis_t

select * from sfism4.r_tinsolder_color_t

select * from sfism4.r_tinsolder_infor_t

SFISM4.R_TINSOLDER_BASIS_T



祇癶纗筁祘
KITTING.KIT_KPOUT_FINISH_PCB

秨
SFISM4.R_MO_BASE_T
兵絏癘魁
SFISM4.R_MO_USE_LIST_T

隔パ璶ノΤ
sfis1.c_route_control_t
sfis1.c_route_name_t
sfis1.c_route_desc_T
sfis1.c_group_sequence_t
ミSFIS1.C_GROUP_CONFIG_T

芠┮ΤDBA_TABLES
SELECT * FROM DBA_TABLES

ミ絬嘿SFIS1.C_HOST_NAME_T,SFIS1.C_LINE_DESC_T,SFIS1.C_STATION_CONFIG_T

玻絬厨紀狾琩高SFIS1.C_BAOFEI_T

SELECT MODEL_NAME , COUNT(MODEL_NAME) FROM SFISM4.R_WIP_TRACKING_T
WHERE SERIAL_NUMBER IN (SELECT SERIAL_NUMBER FROM SFISM4.R_SN_DETAIL_T
WHERE IN_station_time BETWEEN TO_DATE('201204290800','yyyyMMddhhmiss') and TO_DATE('201204300800','yyyyMMddhhmiss') and group_name<>'PACKING' AND STATION_SEQ='0')
AND group_name<>'PACKING' AND STATION_SEQ='0'
GROUP BY MODEL_NAME
ぃ狡计沮 distinct
丁琿琩高N_STATION_TIME BETWEEN TO_DATE('05/07/2012 07:30:00', 'MM/DD/YYYY HH24:MI:SS') AND TO_DATE('05/07/2012 09:50:25', 'MM/DD/YYYY HH24:MI:SS')

狾陪ボ诀贺计秖UPH蝴臔SELECT * FROM SFIS1.C_MODEL_UPH_T,SFISM4.R_TEMP_LINE_CUREENT_MODEL_T


秨虫の埃虫ΤSFISM4.R_MO_BASE_T,SFISM4.R_MO_USE_LIST_T,SFISM4.R_WIP_TRACKING_T,SFISM4.R_AS_SFC_MO_LIST_T


础虫计沮粂础兵隔パ20隔パ
INSERT INTO SFIS1.C_ROUTE_CONTROL_T
SELECT 20,GROUP_NAME,GROUP_NEXT,STATE_FLAG,STEP_SEQUENCE,ROUTE_DESC FROM SFIS

1.C_ROUTE_CONTROL_T
WHERE ROUTE_CODE='7'

綪腹舦贺眀腹盞絏SFIS1.C_USER_T

兵絏絪胯玥SFIS1.C_PARAMETER_INI

蝴SFIS1.R_REPAIR_T

琩高瞷Τ虫禬筁12临孩痙玻絬狾
SELECT * FROM SFISM4.R_WIP_TRACKING_T
WHERE MO_NUMBER IN ('WkU-C50041',
'WkV-C50005',
'WkV-C50012',
'WkV-C50011') AND IN_STATION_TIME BETWEEN TO_DATE('05/01/2012 06:00:47', 'MM/DD/YYYY HH24:MI:SS') AND TO_DATE('05/25/2012 07:00:44', 'MM/DD/YYYY HH24:MI:SS')
AND GROUP_NAME IN ('0','TOP INPUT','AOI INSPECT','FCT','ICT','FVI','SI','SMT REPAIR')

玻絬兵絏砏玥SFIS1.C_PARAMETER_INI


'0','TOP INPUT','AOI INSPECT','FCT','FVI','SMT REPAIR','TEST REPAIR'

'0','AI INPUT','AI INSPECT','TOP INPUT','AOI INSPECT','MI INPUT'

GROUP_NAME IN('TOP INPUT','AOI INSPECT','FCT','FVI','SMT REPAIR','TEST REPAIR','PACKING','SHIPPING_LIST','SHIPPING','SI','FVI_DBG')


ksdb01 10.106.136.21 :1521
user:p3424
password:82736597


update r_wip_tracking_t
set serial_number=substr(1,23)||'o'||substr(25,5)
where

兵絏干ゴ琩高:SELECT * FROM BARCODE.R_LAB_PRINT_LOG_T WHERE START_BARCODE<='M$35-D085518-L$VR4305H82J05' AND END_BARCODE>='M$35-D085518-L$VR4305H82J05'



select * from SFIS1.C_PRODUCT_RESTATION_T
畐畐祘Α畐щ狦Τぃも笆

兵絏紅坝:sfis1.C_CUSTER_CODE_T

SMT 翴纗摸: 苯PKG:42 SMT_MATERIAL ; 苯翬腹: 23 SMT_MATERIAL_KP

SP FVI: 癸莱纗摸:SMT_TEST;癸莱纗筁祘:SMT_CHECK_EMP,SMT_CHECK_EC,SMT_TEST

MI絬HDCP⊿Τ縉魁MACSN

MI絬痁猔種ㄆ兜
1.SELECT * FROM SFISM4.R_ELECTRONIC_KEY_T
тKEY-DATEmaradd盢癸莱used_sn穝癸莱SN
2.........ΤICTぃ秸刚叫盢sfism4.r_wip_tracking_TいSECTION_FLAG逆穝

称癘魁:SFISM4.H_WIP_TRACKING_T 癘魁纯竒秨筁ノ筁兵絏の虫

畐纗筁祘:INSTOCK_CHECK_SCAN_ADD ㄤい.....

PRO_LIST 纗筁祘

sfis1.C_PRIVILEGE 糤FEEDERㄏノ舦

insert into sfis1.c_aaa_T
SELECT SERIAL_NUMBER,'4' FROM SFISM4.R_SN_DETAIL_T
WHERE MODEL_NAME='35-D077389' AND GROUP_NAME='AOI INSPECT' AND IN_STATION_TIME BETWEEN TO_DATE('20130426080000','yyyyMMddHH24miss') AND TO_DATE('20130429080000','yyyyMMddHH24miss')

UPDATE SFISM4.R_WIP_TRACKING_T
SET SERIAL_NUMBER=SUBSTR(SERIAL_NUMBER,1,11)||'L'||SUBSTR(SERIAL_NUMBER,13,16)
WHERE SERIAL_NUMBER='N2J540000E5JAKALB086841D7WD6'

埃HOST_NAME ID:
SELECT * FROM sfis1.c_qway_config_t WHERE HOSTID NOT IN (SELECT HOSTID FROM SFIS1.C_HOST_NAME_T)


SELECT * FROM sfis1.c_qway_config_t WHERE HOSTID IN (SELECT DISTINCT HOSTID FROM sfis1.c_qway_config_t WHERE HOSTID NOT IN (SELECT HOSTID FROM SFIS1.C_HOST_NAME_T ))

SELECT * FROM
sfis1.c_station_config_t WHERE HOSTID IN (SELECT DISTINCT HO

STID FROM sfis1.c_qway_config_t WHERE HOSTID NOT IN (SELECT HOSTID FROM SFIS1.C_HOST_NAME_T ))




SFISM4.R_ELECTRONIC_KEY_T 琩MAK

laber 琩高癘魁

SELECT * FROM SFISM4.R_SMT_PALLET_INFO_T
WHERE MODEL_NAME='465CG286A000' AND LOT_NO='HH06371-80'


select * from sfism4.r_sn_detail_t where (serial_number,in_station_time)
in (
select serial_number,min(in_station_time) from sfism4.r_sn_detail_t
where serial_number in (
select serial_number from sfism4.r_wip_tracking_t
where mo_number='WkU-D70010') and group_name ='AOI INSPECT'
group by serial_number)



材Ω筁丁
select * from sfism4.r_sn_detail_t where (serial_number,in_station_time)
in (
select serial_number,min(in_station_time) from sfism4.r_sn_detail_t
where serial_number in (
select serial_number from sfism4.r_wip_tracking_t
where mo_number='WkU-D70010') and group_name ='TOP_INPUT'
group by serial_number)



DECLARE I NUMBER(8);
BEGIN
FOR I IN 1201..1699 loop
insert INTO SFIS1.C_TID_T VALUES('TID0'||I,'');
END LOOP;
END;




UPDATE sfism4.r_tinsolder_basis_t SET BORROWER_DEP='IN'
WHERE CURRENT_EVENT='2' AND floor((sysdate-backtemp_begintime)/(1/24/60))<2880 AND BORROWER_DEP='OVER'

硂ㄢぱ穦ネ玻Costco TV玻絬璶― だ牧ずネ玻だ牧ず苯磞珹LCM籔TV絬

纗筁祘эSFIS1.ASSY_Check_Serialnumber



Best Regards ! *^_^*