Oracle Apps R12 OPM, SCM, INV, Procurement, OM Modules Functional and Technical Solution by Razaul Karim Reza
Translate
Thursday, July 6, 2017
Find the Request Groups and Concurrent Programs
SELECT g.request_group_name, c.user_concurrent_program_name,
a.application_name, g.application_id, g.request_group_id,
u.unit_application_id, u.request_unit_id
FROM fnd_request_groups g,
fnd_request_group_units u,
fnd_application_tl a,
fnd_concurrent_programs_tl c
WHERE g.request_group_id = u.request_group_id
AND u.unit_application_id = a.application_id
AND u.request_unit_id = c.concurrent_program_id
and c.USER_CONCURRENT_PROGRAM_NAME like '%Purchase Order%'
ORDER BY C.user_concurrent_program_name, A.application_name, g.request_group_id;
Subscribe to:
Post Comments (Atom)
Item Rate Update for Stock In Trade - Returnable Receive/Return (Loan)
Stock In Trade - Returnable Receive/Return (Loan)
-
Oracle Apps R12 Subledger Accounting Tables and joins XLA Table joins GL_JE_BATCHES (je_batch_id) => GL_JE_HEADERS...
-
Oracle Forms: How to select multiple records in a block using a Record Group I decided to create this demo because the question of how to s...
-
1. Oracle Receivables -> Setup -> System ->System Options a. Receivable GL related setup b. Transaction and Customer rela...
No comments:
Post a Comment
Text Message