How to Find Responsibility of a Concurrent Program
SQL Query to get Responsibility Name,Concurrent Program Name and Request Group Names..........................
1) SQL Query to get Responsibility Name when CP(Concurrent Program) Name as input
SELECT DISTINCT
FCPL.USER_CONCURRENT_PROGRAM_NAME
, FCP.CONCURRENT_PROGRAM_NAME
, FAPP.APPLICATION_NAME
, FRG.REQUEST_GROUP_NAME
, FNRTL.RESPONSIBILITY_NAME
FROM
APPS.FND_REQUEST_GROUPS FRG
, APPS.FND_APPLICATION_TL FAPP
, APPS.FND_REQUEST_GROUP_UNITS FRGU
, APPS.FND_CONCURRENT_PROGRAMS FCP
, APPS.FND_CONCURRENT_PROGRAMS_TL FCPL
, APPS.FND_RESPONSIBILITY FNR
, APPS.FND_RESPONSIBILITY_TL FNRTL
WHERE
FRG.APPLICATION_ID=fapp.APPLICATION_ID
AND FRG.APPLICATION_ID = FRGU.APPLICATION_ID
AND FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
AND FRG.REQUEST_GROUP_ID = FNR.REQUEST_GROUP_ID
AND FRG.APPLICATION_ID = FNR.APPLICATION_ID
AND FNR.RESPONSIBILITY_ID = FNRTL.RESPONSIBILITY_ID
AND FRGU.REQUEST_UNIT_ID = FCP.CONCURRENT_PROGRAM_ID
AND FRGU.UNIT_APPLICATION_ID = FCP.APPLICATION_ID
AND FCP.CONCURRENT_PROGRAM_ID = FCPL.CONCURRENT_PROGRAM_ID
AND FCPL.USER_CONCURRENT_PROGRAM_NAME LIKE<Your Concurrent Program Name>
AND FNRTL.LANGUAGE = 'US'
AND FAPP.LANGUAGE = 'US'
-----------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------
SELECT fcpl.user_concurrent_program_name ,
fcp.concurrent_program_name ,
par.end_user_column_name ,
par.form_left_prompt prompt ,
par.enabled_flag ,
par.required_flag ,
par.display_flag
FROM fnd_concurrent_programs fcp ,
fnd_concurrent_programs_tl fcpl ,
fnd_descr_flex_col_usage_vl par
WHERE fcp.concurrent_program_id = fcpl.concurrent_program_id
AND fcpl.user_concurrent_program_name = &conc_prg_name
AND fcpl.LANGUAGE = 'US'
AND par.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name
3) Sql Query to get the responsibility name,request group name when request set name as input.
select frt.responsibility_name,
frg.request_group_name,
frgu.request_unit_type,
frgu.request_unit_id,
fcpt.user_request_set_name
From apps.fnd_Responsibility fr,
apps.fnd_responsibility_tl frt,
apps.fnd_request_groups frg,
apps.fnd_request_group_units frgu,
apps.fnd_request_Sets_tl fcpt
where frt.responsibility_id = fr.responsibility_id
and frg.request_group_id = fr.request_group_id
and frgu.request_group_id = frg.request_group_id
and fcpt.request_set_id = frgu.request_unit_id
and frt.language = USERENV('LANG')
and fcpt.language = USERENV('LANG')
and fcpt.user_request_set_name = '&request_set_name'
order by 1,2,3,4
Popular posts from this blog
Complete Order to Cash(O2C) Techno-Functional flow in R12
Order to Cash Cycle in Brief: The Order to Cash Process flow starts with entering the order with a standard item into system. When you enter an order, the item are validated in oracle inventory, the price is calculated for the items using the pricing engine; the availability of the items are checked and may be reserved. Once all the required fields are entered on both the header and the lines, you can book the order. When you click on the Book Order button, the API OEXUBOKB.pls, checks if the order is eligible for booking. If eligible the order is booked and the order header status would change to booked. The next step is the pick release with which you move the items from the warehouse to the staging area. The next step is to ship confirm, to indicate that the items are loaded on to the carrier from the staging area. When you run Ship Confirm, the system decrements inventory and updates sales order line status. This information is then transferred through the Auto Invoice
Account Payables(AP) Module R12 New Features
AP Module R12 New Features AP Module 12 Release New Features This section is design to give all the information about the changes in the AP Module from 11i to Release 12. Introduction Introduction :- ---------------- In Release 12, the Oracle E-Business Suite introduces Subledger Accounting, E-Business Tax, Ledgers, Banks and other common data model components that are used by Oracle Payables. The following are new in Release 12: • Suppliers are defined as Parties within Oracle Trading Community Architecture. • Invoice Lines are introduced as an entity between the invoice header and invoice distributions in order to better match the structure of invoice documents and improve the flow of information like manufacturer, model, and serial number from Purchasing through to Assets. • Banks, bank branches and internal bank accounts are defined centrally and managed in Oracle Cash Management. • Document sequencing of payments has moved to the Cash Manag
Sub Ledger Accounting SLA (Complete Functional Information)
SubLegder Accounting in R12 SLA Part -1 In these article, we will explore the very basics of SLA and why it exists. Firstly, what exactly does SLA do? SLA is a module which now sits between the SubLedgers like AP/AR etc and the General Ledger. Have a look at this diagram below. As you will notice, SLA can act as a mediator between the subledgers and Oracle General Ledger. Before we progress, some terminologies of R12 must be revisited. In 11i we had set of books, and in R12 we call them Ledgers. Likewise in R12 we also have secondary ledgers and reporting ledgers. Hence from 11i perspective think of Ledger as Set of Books. As for Subledger, a Subledger is nothing but a module like AP/AR/PO/Inventory etc. In the diagram below, the second scenario is explained whereby let's say that payables module generates a charge account segment combination for an invoice distribution line as A.B.C.D. In such case, if SLA module is not customized, then the very same A.B.C.D
How to Find Responsibility of a Concurrent Program
Source: http://kishorecboracleapps.blogspot.com/2012/11/sql-query-to-get-responsibility-name-by.html
0 Response to "How to Find Responsibility of a Concurrent Program"
Post a Comment