Here is a block diagram of Drop Ship Order Flow
Drop Ship Order Flow
...
Thursday, June 12, 2014
Back to Back Order Flow
Please refer below diagram for Back to Back Order flow in Oracle apps
Back to Back Order flow...
Tuesday, June 10, 2014
Monday, June 9, 2014
Query to find responsibilities to which a Concurrent program is assigned
SELECT DISTINCT *
FROM apps.fnd_responsibility_tl
WHERE responsibility_id IN
(SELECT responsibility_id
FROM apps.fnd_responsibility_vl
WHERE request_group_id IN
(SELECT...
Query to find out Responsibilities assigned to a user
SELECT UNIQUE u.user_id, SUBSTR (u.user_name, 1, 30) user_name, u.DESCRIPTION,
SUBSTR (r.responsibility_name, 1, 60) responsiblity,
SUBSTR (a.application_name, 1, 50) application
FROM fnd_user u,
fnd_user_resp_groups...
Script To List The Values Of A Profile Option At All Levels
--Script To List The Values Of A Profile Option At All Levels (Doc ID 803587.1)
SELECT fpo.profile_option_id, fpot.profile_option_name profile_short_name
, substr(fpot.user_profile_option_name,1,60)...
SQL Query To find out File Version
select sub.filename, sub.version
from (
select adf.filename filename,
afv.version version,
rank()over(partition by adf.filename
order by afv.version_segment1...
Subscribe to:
Posts (Atom)