-
编辑 删除
API to Create AP Supplier
API - pos_vendor_pub_pkg.create_vendor Example -- -- API to Create Supplier DECLARE l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type; l_return_status VARCHAR2(10); l_ms...
-
编辑 删除
API to Create Item Specific UOM Conversion (INV_CONVERT.CREATE_UOM_CONVERSION)
TEST INSTANCE: This API is available from the release R12.1.3 Oracle ApplicationsPACKAGE: INV_CONVERTPROCEDURE : CREATE_UOM_CONVERSIONNOTES: Creates the Item Specific conversion between two uom's using uom_ra...
-
编辑 删除
Oracle Application Server上不同类型的文件所在的目录
-
编辑 删除
Generate XML Output from a PL/SQL Concurrent Program
Use the utility DBMS_XMLGEN to generate XML output, as in the following procedure. An example of a query string used to display multiple nested levels of data (using the CURSOR function) is shown below the procedure.----------------------------------------------------------------------------- ...
-
编辑 删除
客户端字符集设置（应用于plsql developer and workflow)
select (select value from nls_database_parameters where parameter = 'NLS_LANGUAGE') || '_' || (select value from nls_database_parameters ...
-
编辑 删除
Workflow Tables
Important Oracle Work Flow Related tables:Workflow Tables:–Workflow Users/RolesSELECT * FROM WF_USERS where name = ‘XXUSER’;SELECT * FROM WF_ROLES where name = ‘XXUSER’;SELECT * FROM WF_USER_ROLES where user_name = ‘XXUSER’;SELECT * FROM WF_USER_ROLE_ASSIGNMENTS where user_name ...
