2012年11月7日
AR 收款 借贷
摘要： SELECT (SELECT NAME FROM hr_operating_units WHERE organization_id = rc.org_id) OU_NAME, rc.trx_number invoice_number, cr.receipt_number, cr.receipt_da 阅读全文
posted @ 2012-11-07 19:08 全威儒 阅读(1329) 评论(0) 推荐(0)
AR应收发票相关脚本
摘要： --应收发票主表 <!--CRLF--> select * <!--CRLF--> from ra_customer_trx_all a <!--CRLF--> where a.trx_number = '156640' <!--CRLF--> and a.org_id = 236; <!--CRL 阅读全文
posted @ 2012-11-07 18:57 全威儒 阅读(2839) 评论(0) 推荐(0)
Toad for Oracle –> Debug by APPS
摘要： oracle DB Service tier.[oracle@ebs12 ~] # sqlplus / as sysdba> grant debug connect session to apps; 阅读全文
posted @ 2012-11-07 18:22 全威儒 阅读(563) 评论(0) 推荐(0)