Query to find vacation rules in Oracle R12
Delegate rules audit query in Oracle APPS EBS
Workflow approval delegations in sql query
Vacation rules setup query in oracle apps
Vacation rule audit query in Oracle
vacation rule in oracle apps r12
--Query to find delegate rules for APEXP workflow. change the workflow type in the query to find related delegate rules.(Unimportant columns are commented in the select statement)
SELECT routingruleseo.role employee,
routingruleseo.action_argument delegate,
-- routingruleseo.rule_id,
routingruleseo.MESSAGE_TYPE,
-- routingruleseo.message_name,
routingruleseo.begin_date,
routingruleseo.end_date,
routingruleseo.action,
-- itemtypeseo.display_name type_display,
--messageseo.display_name msg_display,
-- messageseo.subject,
lookupseo.meaning AS action_display,
itemtypeseo.name --,
-- messageseo.type,
-- messageseo.name AS name1,
-- lookupseo.lookup_type,
-- lookupseo.lookup_code
FROM apps.wf_routing_rules routingruleseo,
apps.wf_item_types_vl itemtypeseo,
apps.wf_messages_vl messageseo,
apps.wf_lookups lookupseo
WHERE 1 = 1 -- routingruleseo.role = :1
AND routingruleseo.MESSAGE_TYPE = itemtypeseo.name(+)
AND routingruleseo.MESSAGE_TYPE = messageseo.TYPE(+)
AND routingruleseo.message_name = messageseo.name(+)
AND routingruleseo.action = lookupseo.lookup_code
AND lookupseo.lookup_type = 'WFSTD_ROUTING_ACTIONS'
AND MESSAGE_TYPE = 'APEXP'
AND routingruleseo.end_date > SYSDATE
--ORDER BY
-- type_display,
-- msg_display,
-- begin_date
;
Related posts:
- Register a test concurrent program from backend in Oracle EBS
- Supervisor Hierarchy and Approval Limits in Oracle EBS R12
- Query to find all Expense report entry delegations
- Query to find vacation rules in Oracle R12
- View java class source in oracle database
- Load Java source code in oracle database
- Query to find all APIs of Oracle Apps modules
- OAF customizations queries
- Oracle apps list of concurrent programs in a Request Set
- Oracle EBS query to get AP Invoice SLA Details
- Query to get Organization Hierarchy in Oracle apps
- Oracle apps query to find incompatible programs blocking a concurrent request
- Form function attached to which responsibility and user
- AP Invoice Vertex debug xml query in Oracle EBS
- Query to find AP invoice workflow item key in oracle apps
- Query to find the responsibility attached to user in oracle apps
- How to enable debug log in Oracle apps EBS
- How to add AME role and responsibility to user
- Oracle form attached to which responsibility
- Query to get workflow details
- SQL query to get MIME type for file extension
- Query to get concurrent program and executable details
- Query to get responsibility level profile option values
- Query to validate migration of XML/BI Publisher Template and Data Definition
- Query to get details of XML/BI Publisher Template and Data Definition
- Query to get Site level and Organization level Profile Option Value
- Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
- PL-SQL code to reset application user password
- PL-SQL Procedure to send email with attachment
- PL-SQL to delete Concurrent Program and Executable
- Query to get the details of the lock in the database
- PL-SQL code to delete XML/BI Publisher template and Data Definition
- Query to find Purchase Order and Invoice Details
- Query to find AP Invoices matched with receipts
- Query to find Form Personalization
- Query to find Supplier Bank Details
- Query to find Credit Memos on an AP invoice
- Query to find the AP invoices that are applied to multiple Purchase Orders
- Query to find profile option values
- Query to get details of concurrent program parameters
- PL-SQL Code to find Menu Hierarchy of a responsibility
- Query to find details of Flex value sets
- Query to find concurrent program Responsibility and Request Group
- Concurrent program SQL statement currently running in background
- Query to find scheduled concurrent programs
- Query to kill database session for a concurrent request
- Query to get DFF (Descriptive Flex Field) Details