Oracle Apps Tutorials
Wednesday, December 27, 2017
Query of Business Structure
›
select * from per_business_groups where business_group_id= 101 select * from hr_operating_units where organization_id = 112 -- (ORG_ID...
1 comment:
Wednesday, November 1, 2017
How to get Oracle Workflow Approvers Comments Code
›
PROCEDURE get_approver_comments_doc ( document_id IN VARCHAR2, display_type IN VARCHAR2, document ...
GET ORACLE WORKFLOW ACTION HISTORY DETAILS
›
CREATE OR REPLACE FUNCTION APPS.XXXX_get_hist ( p_nid IN PLS_INTEGER, p_disp_type IN VARCHAR2 DEFAULT wf_notification...
Monday, August 28, 2017
Move order header different status and their meaning
›
select lookup_code, substr(meaning, 1, 60) "Meaning" from mfg_lookups where lookup_type = 'MTL_TXN_REQUEST_STATUS'...
Thursday, April 20, 2017
Disable/Enable Oracle Application Login User API
›
How to Disable(end date) large number of Users in Oracle Apps How to end date large number of Users - fnd_users in Oracle Apps To Disab...
Delete Responsibility From Backend in Oracle Apps
›
/* Formatted on 2017/04/20 12:15 (Formatter Plus v4.8.8) */ DECLARE v_user_name VARCHAR2 (100) := 'SAJAL'; v_...
Delete Request Set from Backend in Oracle Apps
›
BEGIN FND_SET.DELETE_SET(request_set => 'XX_RG', application => 'XXAPPL'); COMMIT; end; In the code above, XX_...
1 comment:
›
Home
View web version