SELECT a.HCKBCD,
TO_CHAR(a.SRSZGK),
z.VENDOR_NAME,
e.SISNNO,
g.SYHNCD,
c.SYHNNM,
TO_CHAR(a.SRKHRK),
TO_CHAR(a.SRSVRK),
TO_CHAR(a.SRRKST),
TO_CHAR(a.SRKYMD,'YYYY/MM/DD'),
e.HCHUNO
FROM HACCHU a,
APPS_TRHKMT z,
HCHUMS b,
SYHNMT c,
(select distinct SISNNO, HCHUNO from HCSRMS) e,
SHKTKR g
WHERE z.VENDOR_SITE_CODE(+) = a.HCTHCD
AND a.HCTHCD = a.HCTHCD
AND a.HCKBCD = '6'
AND a.HCHUNO = e.HCHUNO
AND g.SISNNO = e.SISNNO
TO_CHAR(a.SRSZGK),
z.VENDOR_NAME,
e.SISNNO,
g.SYHNCD,
c.SYHNNM,
TO_CHAR(a.SRKHRK),
TO_CHAR(a.SRSVRK),
TO_CHAR(a.SRRKST),
TO_CHAR(a.SRKYMD,'YYYY/MM/DD'),
e.HCHUNO
FROM HACCHU a,
APPS_TRHKMT z,
HCHUMS b,
SYHNMT c,
(select distinct SISNNO, HCHUNO from HCSRMS) e,
SHKTKR g
WHERE z.VENDOR_SITE_CODE(+) = a.HCTHCD
AND a.HCTHCD = a.HCTHCD
AND a.HCKBCD = '6'
AND a.HCHUNO = e.HCHUNO
AND g.SISNNO = e.SISNNO
解决方案 »
- 提问:oracle 中创建表空间时指定的datafile是怎么创建的?
- oracle 10g 中用not in 关键字查询公司所有的非部门经理的员工的编号和名称
- sql 查询问题
- 请教一个导入问题
- 请教:A用户可以调用dbms_refresh.refresh刷新B用户的物化视图吗?
- oracle客户端安装.
- 有誰裝過Oracle 10g?
- 请教两个快照的问题,100分。1快照能建立成实时刷新吗?2怎么读取快照日志?
- 有谁知道ORACLE的"NLS_DATE_FORMAT"字段在哪张系统表格中?
- OPTIMIZER_MISMATCH造成的version count高的问题
- 如何在SQL*PLUS中实现用户输入?
- 使用EXECUTE IMMEDIATE语句执行动态SQL的问题:
TO_CHAR(a.SRSZGK),
z.VENDOR_NAME,
e.SISNNO,
g.SYHNCD,
c.SYHNNM,
TO_CHAR(a.SRKHRK),
TO_CHAR(a.SRSVRK),
TO_CHAR(a.SRRKST),
TO_CHAR(a.SRKYMD,'YYYY/MM/DD'),
e.HCHUNO
FROM HACCHU a,
APPS_TRHKMT z,
HCHUMS b,
SYHNMT c,
(select distinct SISNNO, HCHUNO from HCSRMS) e,
SHKTKR g
WHERE z.VENDOR_SITE_CODE(+) = a.HCTHCD
AND a.HCTHCD = a.HCTHCD
AND a.HCKBCD = '6'
AND a.HCHUNO = e.HCHUNO
AND g.SISNNO = e.SISNNO
SELECT DISTINCT -- Here !a.HCKBCD,
TO_CHAR(a.SRSZGK),
z.VENDOR_NAME,
e.SISNNO,
g.SYHNCD,
c.SYHNNM,
TO_CHAR(a.SRKHRK),
TO_CHAR(a.SRSVRK),
TO_CHAR(a.SRRKST),
TO_CHAR(a.SRKYMD,'YYYY/MM/DD'),
e.HCHUNO
FROM HACCHU a,
APPS_TRHKMT z,
HCHUMS b,
SYHNMT c,
HCSRMS e,
SHKTKR g
WHERE z.VENDOR_SITE_CODE(+) = a.HCTHCD
AND a.HCTHCD = a.HCTHCD
AND a.HCKBCD = '6'
AND a.HCHUNO = e.HCHUNO
AND g.SISNNO = e.SISNNO