EBS
文章平均质量分 58
六月雨滴
相互学习,一起进步
展开
-
ANSI 标准详解
ANSI 标准详解原创 2023-12-21 17:42:33 · 989 阅读 · 0 评论 -
builder forms oracle 函数如何使用_Forms Builder常用函数
1. abort_query; 停止查询的执行2. add_group_column(record group id 或 name,group column 添加一个列到一个记录组,Record group id、name,column type,column width);3. add_group_row(record group id 或 name,row number); 添加一个行到一个记录组,record group id是Oracle赋予这个组的唯一的名称,row numbe...转载 2021-08-06 17:33:34 · 363 阅读 · 0 评论 -
Oracle EBS客户表结构
R12 客户表结构客户表/联系人/PARTY关联 HZ_PARTIES客户账户表 HZ_CUST_ACCOUNTS例子: SELECT hp.party_number --客户注册标识 , hp.party_name --组织名/客户 , hp.known_as --别名 , hp.organi...转载 2022-02-18 17:53:35 · 2094 阅读 · 0 评论 -
Oracle EBS注册请求
Oracle EBS请求原创 2022-06-13 17:12:21 · 632 阅读 · 0 评论 -
Oracle Form 之 Compute Data
操作数据无非删除、更新、插入的动作,在Oracle Form依靠下面触发器完成这些操作。Form TriggerKey-commit保存按钮触发/Ctrl+S 键盘触发/代码触发Block TriggerPre-deletePre-updatePre-insertOn-deleteOn-updateOn-insertOn-lockOracle保存数据的机制:第一步依次从数据库中删除在Block上删除...原创 2022-05-19 15:19:54 · 306 阅读 · 0 评论 -
Oracle Form Builder中Form的布局方法、 赋初始值及Item对象的相关属性
一个Form Module可能包含了多个window,多个Data Block,多个canvas,在对象众多的情况下,布局方法遵循一定的规则可让你事半功倍。Form Module的基本结构,如图一般来说布局,应按照windows-canvases-data block-items的顺序,先简单说明下各对象与布局相关的属性。WindowPropertyNoteX PositionForm启动时X轴坐标Y PositionForm启动时Y轴坐...原创 2022-05-18 16:37:16 · 1691 阅读 · 0 评论 -
Oracle Form Builder
新建Form修改Template.fmb模板是新建Form最快方法,对于在EBS系统中使用的Form,,利用Template可以省去许多繁杂的工作。开发之前记得把服务器上appstand.fmb,pll,fmb文件($AU_TOP/RESOURCE/US路径下)下载到本地指定路径,以防打开或编译fmb文件时找不到引用对象。在Form builder中打开Template.fmb文件后,修改module name后另存为。下一步是修改3个地方1、pre-form trigger(form leve原创 2022-05-18 10:06:18 · 1439 阅读 · 0 评论 -
EBS:FINANCIALS_SYSTEM_PARAMS_ALL
描述:Oracle Financials系统参数和默认值Primary Key: FINANCIALS_SYSTEM_PARAMS_PKSET_OF_BOOKS_ID ORG_IDForeign Keys from this table:Foreign Key Column Foreign Table FINANCIALS_SYSTEM_PARAMS_ALL.SET_OF_BOOKS_ID % FINANCIALS_SYSTEM_PARAMS_ALL.INVOICE_CU原创 2022-05-17 11:48:20 · 488 阅读 · 0 评论 -
EBS:AP_TAX_CODES_ALL
描述:税法信息Primary Key: AP_TAX_CODES_PKTAX_IDForeign Keys from this table:Foreign Key Column Foreign Table AP_TAX_CODES_ALL.SET_OF_BOOKS_ID % AP_TAX_CODES_ALL.TAX_CODE_COMBINATION_ID GL_CODE_COMBINATIONS AP_TAX_CODES_ALL.AWT_VENDOR_ID原创 2022-05-17 11:40:08 · 236 阅读 · 0 评论 -
EBS:AP_SELECTED_INVOICES_ALL
描述:在一批付款中选择用于付款的发票的临时存放Primary Key: AP_SELECTED_INVOICES_PKCHECKRUN_NAME INVOICE_ID PAYMENT_NUMForeign Keys from this table:Foreign Key Column Foreign Table AP_SELECTED_INVOICES_ALL.CHECKRUN_NAME AP_INV_SELECTION_CRITERIA_ALL AP_SELECTED原创 2022-05-17 11:10:46 · 265 阅读 · 0 评论 -
EBS:AP_REPORTING_ENTITY_LINES_ALL
描述:平衡与税务报告实体相关联的部门信息Primary Key: AP_REPORTING_ENTITY_LINES_PKBALANCING_SEGMENT_VALUEForeign Keys from this table:Foreign Key Column Foreign Table AP_REPORTING_ENTITY_LINES_ALL.TAX_ENTITY_ID AP_REPORTING_ENTITIES_ALL Comments:AP_REPORTING原创 2022-05-17 10:25:38 · 107 阅读 · 0 评论 -
EBS:AP_REPORTING_ENTITIES_ALL
描述:税务报告实体的税务识别信息Primary Key: AP_REPORTING_ENTITIES_PKTAX_ENTITY_IDPrimary Key: AP_REPORTING_ENTITIES_UK1TAX_IDENTIFICATION_NUMPrimary Key: AP_REPORTING_ENTITIES_UK2ENTITY_NAMEForeign Keys from this table:Foreign Key Column Foreign Table A原创 2022-05-17 10:19:47 · 119 阅读 · 0 评论 -
EBS:AP_POL_EXRATE_OPTIONS_ALL
描述:该表存储用于策略遵从性验证的汇率容差。Primary Key: AP_POL_EXRATE_OPTIONS_PKEXCHANGE_RATE_IDForeign Keys from this table:Foreign Key Column Foreign Table AP_POL_EXRATE_OPTIONS_ALL.EXCHANGE_RATE_TYPE GL_DAILY_CONVERSION_TYPES Foreign Keys to this table:Fo原创 2022-05-16 16:57:54 · 123 阅读 · 0 评论 -
EBS:AP_PAYMENT_HISTORY_ALL
描述:付款期限和对账历史Primary Key: AP_PAYMENT_HISTORY_PKPAYMENT_HISTORY_IDForeign Keys from this table:Foreign Key Column Foreign Table AP_PAYMENT_HISTORY_ALL.CHECK_ID AP_CHECKS_ALL AP_PAYMENT_HISTORY_ALL.ACCOUNTING_EVENT_ID AP_ACCOUNTING_EVENTS_原创 2022-05-16 16:52:30 · 305 阅读 · 0 评论 -
EBS:AP_INV_SELECTION_CRITERIA_ALL
描述:付款批量发票的选择标准Primary Key: AP_INVOICE_SELECTION_CRITER_PKCHECKRUN_IDForeign Keys from this table:Foreign Key Column Foreign Table AP_INV_SELECTION_CRITERIA_ALL.CHECK_STOCK_ID AP_CHECK_STOCKS_ALL AP_INV_SELECTION_CRITERIA_ALL.CURRENCY_CODE原创 2022-05-16 16:46:56 · 208 阅读 · 0 评论 -
EBS:AP_INV_APRVL_HIST_ALL
描述:AP_INV_APRVL_HIST_ALL包含通过发票审批工作流流程的每个发票的批准和拒绝历史记录。该流程为分配审核发票的每个审批人插入一条记录。Foreign Keys from this table:Foreign Key Column Foreign Table AP_INV_APRVL_HIST_ALL.INVOICE_ID AP_INVOICES_ALL Comments:AP_INV_APRVL_HIST_ALL包含通过发票审批工作流流程的每个发票的批准和拒原创 2022-05-16 16:42:32 · 125 阅读 · 0 评论 -
写出高性能SQL语句方法(下)
1、用 >= 替代 > ; <= 替代 <(高效)SELECT * FROM EMP E WHERE E.DEPT_NO >= 6;(低效)SELECT * FROM EMP E WHERE E.DEPT_NO >6;两者的区别在于,前者DBMS将直接跳到第一个DEPT_NO等于6的记录而后者将首先定位到DEPT_NO=6的记录并且向前扫描到第一个DEPT_NO大于6的记录。2、用UNION替换OR(适用于索引列)通常情况下,用UNION替换WHERE原创 2022-05-15 20:00:24 · 405 阅读 · 0 评论 -
写出高性能SQL语句方法(上)
1、整合简单,无关联的资料库访问:WHERE子句中,如果索引列是函数的一部分,优化器将不使用索引而使用全资料表扫描。例如:(高效)SELECT * FROM DEPT D WHERE D.SAL > 300000 / 12;(低效)SELECT * FROM DEPT D WHERE D.SAL * 12 > 300000;如果你有几个简单的资料库查询语句,你可以把它们整合到一个查询中(即使它们之间没有关系)2、删除重复记录: 最高效的删除重复记录方法(因为使用了ROW原创 2022-05-15 17:48:55 · 268 阅读 · 0 评论 -
EBS:AP_HOLDS_ALL
描述:发票保持信息Foreign Keys from this table:Foreign Key Column Foreign Table AP_HOLDS_ALL.INVOICE_ID AP_INVOICES_ALL AP_HOLDS_ALL.HOLD_LOOKUP_CODE AP_HOLD_CODES AP_HOLDS_ALL.RELEASE_LOOKUP_CODE AP_HOLD_CODES AP_HOLDS_ALL.LINE_LOCATION_ID原创 2022-05-13 18:01:06 · 146 阅读 · 0 评论 -
EBS: AP_HOLDS_ALL
描述:发票保持信息Foreign Keys from this table:Foreign Key Column Foreign Table AP_HOLDS_ALL.INVOICE_ID AP_INVOICES_ALL AP_HOLDS_ALL.HOLD_LOOKUP_CODE AP_HOLD_CODES AP_HOLDS_ALL.RELEASE_LOOKUP_CODE AP_HOLD_CODES AP_HOLDS_ALL.LINE_LOCATION_ID原创 2022-05-12 16:00:53 · 136 阅读 · 0 评论 -
EBS:AP_HISTORY_INV_PAYMENTS_ALL
描述:清除发票和发票付款之间的关系Foreign Keys from this table:Foreign Key Column Foreign Table AP_HISTORY_INV_PAYMENTS_ALL.INVOICE_ID AP_HISTORY_INVOICES_ALL AP_HISTORY_INV_PAYMENTS_ALL.CHECK_ID AP_HISTORY_CHECKS_ALL Comments:AP_HISTORY_INVOICE_PAYMEN原创 2022-05-12 15:23:20 · 94 阅读 · 0 评论 -
EBS:AP_HISTORY_INVOICES_ALL
描述:清除发票的概要信息Primary Key: AP_HISTORY_INVOICES_PKINVOICE_IDForeign Keys from this table:Foreign Key Column Foreign Table AP_HISTORY_INVOICES_ALL.PURGE_NAME FINANCIALS_PURGES AP_HISTORY_INVOICES_ALL.DOC_SEQUENCE_ID FND_DOCUMENT_SEQUENCES原创 2022-05-12 15:18:08 · 121 阅读 · 0 评论 -
EBS:AP_HISTORY_CHECKS_ALL
描述:关于净化发票付款的汇总信息Primary Key: AP_HISTORY_CHECKS_PKCHECK_IDForeign Keys from this table:Foreign Key Column Foreign Table AP_HISTORY_CHECKS_ALL.CE_BANK_ACCT_USE_ID CE_BANK_ACCT_USES_ALL AP_HISTORY_CHECKS_ALL.BANK_ACCOUNT_ID AP_BANK_ACCOUNT原创 2022-05-12 14:33:09 · 114 阅读 · 0 评论 -
EBS: AP_EXPENSE_FEED_LINES_ALL
描述:从信用卡发行者导入的信用卡交易的详细信息Primary Key: AP_EXPENSE_FEED_LINES_PKFEED_LINE_IDForeign Keys from this table:Foreign Key Column Foreign Table AP_EXPENSE_FEED_LINES_ALL.CARD_ID AP_CARDS_ALL AP_EXPENSE_FEED_LINES_ALL.ORIGINAL_CURRENCY_CODE FND_CU原创 2022-05-12 14:19:30 · 69 阅读 · 0 评论 -
EBS:AP_EXPENSE_FEED_DISTS_ALL
描述:信用卡交易的会计信息Primary Key: AP_EXPENSE_FEED_DISTS_PKFEED_DISTRIBUTION_IDForeign Keys from this table:Foreign Key Column Foreign Table AP_EXPENSE_FEED_DISTS_ALL.FEED_LINE_ID AP_EXPENSE_FEED_LINES_ALL AP_EXPENSE_FEED_DISTS_ALL.INVOICE_ID AP原创 2022-05-12 11:50:14 · 97 阅读 · 0 评论 -
EBS: AP_ENCUMBRANCE_LINES_ALL
描述:累赘行表Primary Key: AP_ENCUMBRANCE_LINES_PKENCUMBRANCE_LINE_IDForeign Keys from this table:Foreign Key Column Foreign Table AP_ENCUMBRANCE_LINES_ALL.CODE_COMBINATION_ID GL_CODE_COMBINATIONS AP_ENCUMBRANCE_LINES_ALL.ENCUMBRANCE_TYPE_ID G原创 2022-05-12 11:40:37 · 124 阅读 · 0 评论 -
EBS:AP_DUPLICATE_VENDORS_ALL
描述:供应商合并使用的供应商信息Primary Key: AP_DUPLICATE_VENDORS_PKENTRY_IDForeign Keys from this table:Foreign Key Column Foreign Table AP_DUPLICATE_VENDORS_ALL.VENDOR_SITE_ID PO_VENDOR_SITES_ALL AP_DUPLICATE_VENDORS_ALL.DUPLICATE_VENDOR_SITE_ID PO_V原创 2022-05-12 11:06:49 · 156 阅读 · 0 评论 -
EBS:AP_DISTRIBUTION_SET_LINES_ALL
描述:单个分布集线定义Primary Key: AP_DISTRIBUTION_SET_LINES_PKDISTRIBUTION_SET_ID DISTRIBUTION_SET_LINE_NUMBERForeign Keys from this table:Foreign Key Column Foreign Table AP_DISTRIBUTION_SET_LINES_ALL.DISTRIBUTION_SET_ID AP_DISTRIBUTION_SETS_ALL A原创 2022-05-12 10:39:16 · 142 阅读 · 0 评论 -
EBS:AP_DISTRIBUTION_SETS_ALL
描述:发票分发集定义Primary Key: AP_DISTRIBUTION_SETS_PKDISTRIBUTION_SET_IDPrimary Key: AP_DISTRIBUTION_SETS_UK1DISTRIBUTION_SET_NAMEForeign Keys to this table:Foreign Key Column Foreign Table AP_DISTRIBUTION_SET_LINES_ALL.DISTRIBUTION_SET_ID AP_DI原创 2022-05-12 10:32:41 · 156 阅读 · 0 评论 -
EBS:AP_CREDIT_CARD_TRXNS_ALL
描述:雇员信用卡交易的详细信息Primary Key: AP_CREDIT_CARD_TRXNS_PKTRX_IDForeign Keys from this table:Foreign Key Column Foreign Table AP_CREDIT_CARD_TRXNS_ALL.REPORT_HEADER_ID AP_EXPENSE_REPORT_HEADERS_ALL AP_CREDIT_CARD_TRXNS_ALL.REQUEST_ID FND_CONCU原创 2022-05-11 11:21:10 · 146 阅读 · 0 评论 -
EBS:AP_CHECKRUN_CONFIRMATIONS_ALL
描述:批付款确认临时表Primary Key: AP_CHECKRUN_CONFIRMATIONS_PKCHECKRUN_NAME START_CHECK_NUMBERForeign Keys from this table:Foreign Key Column Foreign Table AP_CHECKRUN_CONFIRMATIONS_ALL.CHECKRUN_NAME AP_INV_SELECTION_CRITERIA_ALL Comments:AP_CHEC原创 2022-05-11 11:12:05 · 121 阅读 · 0 评论 -
EBS:AP_CHECKRUN_CONC_PROCESSES_ALL
描述:跟踪支付批量并发程序的临时表Primary Key: AP_CHECKRUN_CONC_PROCESSES_PKREQUEST_IDForeign Keys from this table:Foreign Key Column Foreign Table AP_CHECKRUN_CONC_PROCESSES_ALL.CHECKRUN_NAME AP_INV_SELECTION_CRITERIA_ALL AP_CHECKRUN_CONC_PROCESSES_ALL.RE原创 2022-05-10 11:45:55 · 139 阅读 · 0 评论 -
EBS:AP_CARD_CODE_SETS_ALL
描述:关于分配给信用卡程序并由其使用的信用卡代码集的描述性信息Primary Key: AP_CARD_CODE_SETS_PKCODE_SET_IDForeign Keys to this table:Foreign Key Column Foreign Table AP_CARD_CODES_ALL.CODE_SET_ID AP_CARD_CODE_SETS_ALL AP_CARD_PROGRAMS_ALL.CARD_CODE_SET_ID AP_CARD_COD原创 2022-05-09 10:48:35 · 121 阅读 · 0 评论 -
EBS:AP_CARD_CODES_ALL
描述:定义的信用卡代码的信息Primary Key: AP_CARD_CODES_PKCODE_IDForeign Keys from this table:Foreign Key Column Foreign Table AP_CARD_CODES_ALL.CODE_SET_ID AP_CARD_CODE_SETS_ALL Foreign Keys to this table:Foreign Key Column Foreign Table AP_CARD_原创 2022-05-09 10:45:38 · 247 阅读 · 0 评论 -
EBS:AP_CARDS_ALL
描述:发放给员工的信用卡信息Primary Key: AP_CARDS_PKCARD_IDForeign Keys from this table:Foreign Key Column Foreign Table AP_CARDS_ALL.PROFILE_ID AP_CARD_PROFILES_ALL AP_CARDS_ALL.CARD_PROGRAM_ID AP_CARD_PROGRAMS_ALL AP_CARDS_ALL.REQUEST_ID FND_C原创 2022-05-09 10:40:43 · 199 阅读 · 0 评论 -
EBS: AP_BATCHES_ALL
描述:发票批次信息汇总Primary Key: AP_BATCHES_PKBATCH_IDPrimary Key: AP_BATCHES_UK1BATCH_NAME BATCH_DATEForeign Keys from this table:Foreign Key Column Foreign Table AP_BATCHES_ALL.INVOICE_CURRENCY_CODE FND_CURRENCIES AP_BATCHES_ALL.PAYMENT_CURRE原创 2022-05-09 09:52:48 · 232 阅读 · 0 评论 -
EBS:AP_BANK_ACCOUNTS_ALL
描述:银行账户表Primary Key: AP_BANK_ACCOUNTS_PKBANK_ACCOUNT_IDPrimary Key: AP_BANK_ACCOUNTS_UK1BANK_ACCOUNT_NAMEForeign Keys from this table:Foreign Key Column Foreign Table AP_BANK_ACCOUNTS_ALL.CURRENCY_CODE FND_CURRENCIES AP_BANK_ACCOUNTS_AL原创 2022-05-07 16:24:51 · 739 阅读 · 0 评论 -
EBS:AP_AWT_TEMP_DISTRIBUTIONS_ALL
描述:预扣税临时分配Foreign Keys from this table:Foreign Key Column Foreign Table AP_AWT_TEMP_DISTRIBUTIONS_ALL.INVOICE_ID AP_INVOICES_ALL AP_AWT_TEMP_DISTRIBUTIONS_ALL.TAX_RATE_ID AP_AWT_TAX_RATES_ALL AP_AWT_TEMP_DISTRIBUTIONS_ALL.GROUP_ID AP_原创 2022-05-07 16:07:26 · 251 阅读 · 0 评论 -
EBS:PO_REQ_DISTRIBUTIONS_ALL
描述:征用分布Primary Key: PO_REQ_DISTRIBUTIONS_PKDISTRIBUTION_IDForeign Keys from this table:Foreign Key Column Foreign Table PO_REQ_DISTRIBUTIONS_ALL.REQUISITION_LINE_ID PO_REQUISITION_LINES_ALL PO_REQ_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID GL_SE原创 2022-05-06 17:28:38 · 292 阅读 · 0 评论 -
EBS:AP_INVOICE_PAYMENTS_ALL
描述:发票的付款记录Primary Key: AP_INVOICE_PAYMENTS_PKINVOICE_PAYMENT_IDForeign Keys from this table:Foreign Key Column Foreign Table AP_INVOICE_PAYMENTS_ALL.INVOICE_ID AP_INVOICES_ALL AP_INVOICE_PAYMENTS_ALL.INVOICING_VENDOR_SITE_ID % AP_INVO原创 2022-05-06 17:08:02 · 867 阅读 · 0 评论