oracle ebs 查询物料现有量sql,Oracle EBS EBS常用SQL

--1查找系统用户基本信息author:dezai

Select USER_ID,

USERNAME,

DESCRIPTION,

EMPLOYEDD_ID,

PERSON_PARTY_ID

FROM Fnd_User;

--2查找供应商基本信息(供应商,供应商地点,联系人) author:dezai

Select pv.vendor_id vendor_id,

PVSA.VENDOR_SITE_ID vendor_site_id,

pv.vendor_name vendor_name,

PVSA.VENDOR_SITE_CODE vendor_site_code,

http://www.doczj.com/doc/b3f85e7bf242336c1eb95edd.html_ID org_id,

pv.segment1 vendor_code,

pvc.area_code || pvc.phone vendor_phone,

PVC.FAX_AREA_CODE || pvc.fax vendor_fax,

PVSA.TERMS_ID terms_id,

PVSA.VAT_CODE vat_code,

http://www.doczj.com/doc/b3f85e7bf242336c1eb95edd.htmlST_NAME || PVC.MIDDLE_NAME || PVC.FIRST_NAME contact_man FROM po_vendors pv, po_vendor_sites_all pvsa, po_vendor_contacts pvc

Where pv.vendor_id = pvsa.vendor_id

AND pvsa.vendor_site_id = pvc.vendor_site_id

orDER BY org_Id DESC;

--3查找所有的interface表author:dezai

Select *

FROM dba_objects db

Where db.object_type = 'TABLE' AND db.object_name LIKE '%INTERFACE%';

--4查找对应模块的interface表author:dezai

Select *

FROM dba_objects db

Where db.object_type = 'TABLE'

AND db.object_name LIKE '%INTERFACE%'

AND owner LIKE 'PO';

--5查找用户当前的状态author:dezai

Select SUBSTR (V$http://www.doczj.com/doc/b3f85e7bf242336c1eb95edd.htmlERNAME, 1, 8) USERNAME,

V$SESSION.OSUSER OSUSER,

-- DECODE(V$SESSION.SERVER,'DEDICATED','D','SHARED','S','O') SERVER,

V$SQLAREA.DISK_READS DISK_READS,

V$SQLAREA.BUFFER_GETS BUFFER_GETS,

SUBSTR (V$SESSION.LOCKWAIT, 1, 10) LOCKWAIT,

V$SESSION.PROCESS PID,