淡

修改量消耗明细--修改量消耗明细SELECT t.name, t.comments, t.version_no, cux_rebate_pub.get_hou_name(p_organization_id => t.orig_org_id) org_name, ac.customer_name, --ql.amount "限额

INDEX OF QUERIESSource Document: Purchase Order:1: po_headers_all (sql)2: po_lines_all (sql)3: po_line_locations_all (sql)4: po_distributions_all (sql)Accounting Related Da

SELECT gjh.set_of_books_id, gjl.je_line_num, mta.organization_id, ood.organization_code, ood.organization_name, mtt.transaction_type_name, NULL trx_number, to_char(ooh.orde

SELECT hou.name, pv.vendor_name 供应商, pv.party_id, pvs.vendor_site_id, pvs.terms_id, pv.vendor_name_alt 供应商别名, hp.known_as 别名, cux_rebate_pub.get_lookup

SELECT hp.party_name "客户名称", --客户名称 hca.account_number "客户编号", --客户编号 hca.cust_account_id "客户ID", --客户cust_acc_id decode(hca.customer_type, 'I', '内部客户'

FUNCTION get_onhand_atr_qty(p_organization_id IN NUMBER, p_item_id IN NUMBER) RETURN NUMBER IS x_return_status VARCHAR2(1); x_msg_count NUMBE

SELECT * FROM pa_expenditure_items_all  项目收款SELECT l.project_id, h.project_set_id, h.name, l.project_set_id  FROM pa_project_set_lines l, pa_project_sets_vl h WHERE l.project_set_id = h.proj

set serveroutput onDECLAREl_header_rec OE_ORDER_PUB.Header_Rec_Type;l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;l_header_adj_tbl OE_ORDER_PUB.Header_A

General Ledger Useful SQL Scripts – Oracle Applications 11iContentsGL Set of Books Configuration Overview

SELECT t.name 收款方法, t.receipt_number 收款编号, t.status 状态, t.receipt_date 收款日期, t.gl_date gl日期, t.currency_code 币种, t.amo

SELECT alc1.displayed_field, --'类型', ac.org_id, --'业务实体', ac.vendor_name, --'贸易伙伴', ass.segment1, --'供应商编号', ac.vendor_site_code, --'供应商地点', ac.check_date, --'付款日期',

SELECT jh.period_name 期间, jh.default_effective_date 日期, jh.name 凭证名, jh.doc_sequence_value 单据号, jl.je_line_num 凭证行号, gccv

SELECT fa.asset_id 资产id, fa.asset_number ebs资产标签号, nvl(fa.tag_number, fa.asset_number) 资产编号, fa.serial_number 序列号, fa.description 资产名称, (SELECT fcb.concatenated_segm

--基于视图 CST_MGD_LIFO_ITEM_COSTS_V 可取所有数据SELECT pp.legal_entity 法人主体id, xep.name 法人主体名字, pic.pac_period_id 期间id, pp.period_name 期间, msi.segment1 物料编码, msi.description

SELECT company.flex_value, company.description, inv.item_code, --inv.lot_number,--批次 inv.quantity FROM (SELECT ffvt.description, ffv.flex_value, ffv.attribute1

--27663/*select count(1) from ap_invoice_distributions_all;*/SELECT h.batch_id 批id, aba.batch_name 批名, h.org_id ou, ood.organization_name 业务实体, h.invoice_type_l

--应收INVOICE主表SELECT * FROM RA_CUSTOMER_TRX_ALL A WHERE A.TRX_NUMBER = '156640' AND A.ORG_ID = 236;--应收INVOICE行表SELECT B.EXTENDED_AMOUNT --不含税原币金额 ,B.EXTENDED_ACCTD_AMOUNT --不含税本币金额