PL/SQL stands for Procedural Language extension of SQL.PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90’s to enhance the capabilities of SQL.PL/SQL EnvironmentPL/SQL is not an Oracle product in its own right; it is a technology used by the Oracle […]
For Registering the Executable from backend. PROMPT Creating Concurrent Executable XXM_XYZ_EMPLOYEE ……PROMPT BEGINFND_PROGRAM.executable(‘XXM_XYZ_EMPLOYEE’ — executable, ‘ABC’ — application, ‘ABC_XYZ_EMPLOYEE’ — short_name, ‘Executable for Migrating Employee’ — description, ‘PL/SQL Stored Procedure’ — execution_method, ‘abc_xyz_employee_pkg.create_employee’ — execution_file_name, ” — subroutine_name, ” — icon_name, ‘US’ — language_code, ”); END;/ For Registering the Concurrent program for the Executable file […]
You know the concurrent program name, but you do not know to what all responsibilities it is attached to. In that case, you can use the following select statement to know the responsibilities names to which your concurrent program is attached. select responsibility_namefrom fnd_responsibility_tl rsp_tl, fnd_responsibility fr, –fnd_request_groups frg,fnd_request_group_units frgu, fnd_concurrent_programs_tl fcptwhere rsp_tl.responsibility_id = fr.responsibility_id–and […]
Note:- Inventory Organization will be represented with the Organization_id column.We many give some code and name to the Inventory. With the following Query we can know the Code and Name details of all the Inventories in the Organization. SELECT distinct SUBSTR(loc.location_code, 1, 4) “Inventory Code”,DECODE(SUBSTR(loc.tax_name, 1, 3) ,’Bay’, ‘H’ ,’Zel’, ‘Z’ ,’KMT’, ‘Z’) || lpad(substr(loc.location_code, 1, 4), 4, […]
The Following Query will give the Department Number, Category Number, Cost of the Item based on the Inventory item ID. select mcb.segment3 “Deptartment” ,mcb.segment4 “Category”, cs.item_cost “Item price”from mtl_categories_b mcb, cst_item_costs cswhere mcb.category_id IN (select CATEGORY_ID from mtl_item_categories where inventory_item_id = ‘Your Inventory Item ID’and organization_id = ‘Your Inventory Organization ID’ and category_set_id = 1 and […]
Recent Comments