【正文】 用戶名稱, 用戶姓名, 批準(zhǔn)日期, 說明, 狀態(tài), 類型, 傳遞標(biāo)示, 對方CO編號 FROM PO_REQUISITION_HEADERS_ALL PRH, FND_USER FU, per_people_f PP,OE_ORDER_HEADERS_ALL OEH WHERE = AND = AND = (+) AND = 112 AND = 39。) order by party_name，收貨地，銷售訂單。, 39。) and = and = 141 and = and = 39。5. 訂單OEselect * from oe_order_headers_all 銷售頭select * from oe_order_lines_all 銷售行select * from wsh_new_deliveries 發(fā)送select * from wsh_delivery_detailsselect * from wsh_delivery_assignments綜合查詢1未結(jié)銷售訂單SELECT 銷售訂單, 客戶PO, 客戶編碼, 客戶名稱, 收貨地, 收單地, 訂單日期, 合同號, 屏號, 來源編碼, 行號, 物料, 物料說明, 訂購單位, 訂購數(shù)量, 取消數(shù)量, 發(fā)運數(shù)量, 計劃發(fā)運日期, 登記標(biāo)記, 工作流狀態(tài), 取消標(biāo)記 FROM OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES_ALL L, HZ_CUST_ACCOUNTS CUST, hz_parties hp, hz_cust_site_uses_all ship_use, hz_cust_site_uses_all bill_use, mtl_system_items_b msi, oe_lookups ol WHERE 1 = 1 AND = AND = and = and = and = and not in (39?？蛻糍~戶地點地址SELECT , , , , , , , , , , FROM hz_parties hp, hz_cust_accounts hca, hz_party_sites hps, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua WHERE = AND = AND = AND = 客戶主配置文件SELECT * FROM hz_cust_profile_classes。MOBILE39。GEN39。HZ_PARTIES39。HZ_PARTIES39。PERSON39。 39。EMAIL39。PHONE39。PHONE39。HZ_PARTIES39。CONTACT39。 39。 || bank_addressFROM hz_party_sites hps, hz_locations hlWHERE = ORDER BY 。 || || 39。 || || 39。客戶開戶行地址信息SQLSELECT || 39。 AND = (+) AND (+) = 39。 AND = AND (+) = AND 39。地點地址名稱 (關(guān)聯(lián)hz_cust_acct_sites_all)SELECT , FROM HZ_LOCATIONS AA, HZ_PARTY_SITES BB WHERE = AND = 21302。4. 客戶CUSTOMERSQL 查詢客戶賬戶表 以許繼1063 電網(wǎng)客戶為例PARTY_ID = 21302SELECT * FROM hz_cust_accounts AA WHERE = 1063。 AND IS NULL。 AND (+) = 39。 AND (+) = 39。 AND (+) = 39。供應(yīng)商地址聯(lián)系人信息：phone、fax和EmailSELECT phone_area_code, phone_number, phone_extension, fax_phone_area_code, fax_phone_number, _address FROM ap_supplier_sites_all assa, hz_contact_points hcpp, hz_contact_points hcpf, hz_contact_points hcpe, hz_party_sites hps WHERE = AND (+) = AND (+) = AND (+) = AND (+) = 39。 AND (+) = 39。 AND (+) = 39。 AND (+) = 39。 AND (+) = 39。 AND (+) = 39。 || || 39。LANG39。VENDOR TYPE39。90年代39。YYYY39。199039。70年代39。YYYY39。197039。50年代39。YYYY39。女39。男39。NULL39。F39。M39。綜合查詢SELECT USER_NAME, FULL_NAME, RESPONSIBILITY_NAME, FROM FND_USER AA, FND_USER_RESP_GROUPS BB, FND_RESPONSIBILITY_VL CC, per_people_f DD WHERE = AND = AND = AND RESPONSIBILITY_NAME like 39。) FROM DUALselect * from hr_operating_units hou where =2042. 用戶、責(zé)任及HR系統(tǒng)責(zé)任定義VIEW(FROM FND_RESPONSIBILITY_TL, FND_RESPONSIBILITY)SELECT APPLICATION_ID, RESPONSIBILITY_ID, RESPONSIBILITY_KEY, END_DATE, RESPONSIBILITY_NAME, DESCRIPTION FROM FND_RESPONSIBILITY_VL。ORACLE EBS常用表查詢語句1. OU、庫存組織SELECT ou_org_id, org_id ou_name, ou名稱 org_org_id, 庫存組織id org_org_code, 庫存組織代碼 , 子庫存名稱 子庫存描述 FROM hr_organization_information hoi, 組織分類表 hr_operating_units hou, ou視圖 org_organization_definitions ood, 庫存組織定義視圖 mtl_secondary_inventories msi 子庫存信息表 WHERE = 39。ORG_ID39。人員表VIEWSELECT PERSON_ID, START_DATE, DATE_OF_BIRTH, EMPLOYEE_NUMBER, NATIONAL_IDENTIFIER, SEX, FULL_NAME FROM per_people_f。綜合查詢?nèi)藛T狀況基本信息表SELECT 系統(tǒng)ID, 姓名, 出生日期, 出生地區(qū), 身份證號, 招工來源, 員工類型, 集團合同號, 參加工作日期, 省份, DECODE(,39。,39。,39。 THEN 39。 THEN 39。 END 性別1, case 用法一 CASE WHEN TO_CHAR(, 39。 THEN 39。) 39。 WHEN TO_CHAR(, 39。 THEN 39。) 39。 WHEN TO_CHAR(, 39。 THEN 39。 case 用法二 END 出生年代FROM PER_ALL_PEOPLE_F PAF3. 供應(yīng)商VENDOR供應(yīng)商主表數(shù)據(jù)：SELECT vendor_id, party_id, vendor_code, vendor_name, vendor_short_name, vendor_type, vendor_type_meaning, tax_registered_name, payment_method, term_name, enabled_flag, end_date_active, creation_date, created_by, last_update_date, last_updated_by, last_update_login FROM ap_suppliers ass, fnd_lookup_values flv, hz_parties hp, ap_terms_tl att WHERE = (+) AND (+) = 39。) AND = AND = userenv(39。 39。PERSON39。HZ_PARTIES39。HZ_PARTIES39。GEN39。FAX39。供應(yīng)商地址主信息SELECT vendor_site_id, vendor_id, vendor_code, address_short_name, address_line1, address_line2, address_line3, address_line4, org_id, country,