Analiza uruchamianych zleceń współbierznych

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

/*Begin fnd_client_info.set_org_context(105); end;*/
SELECT c.REQUEST_ID,
c.REQUEST_DATE,
c.ARGUMENT_TEXT,
c.COMPLETION_TEXT,<span id="more-288"></span>
c.PROGRAM_SHORT_NAME,
c.PROGRAM,
c.REQUESTOR,
c.USER_CONCURRENT_PROGRAM_NAME,
r.RESPONSIBILITY_NAME
FROM apps.FND_CONC_REQ_SUMMARY_V c,
apps.FND_RESPONSIBILITY_VL r
WHERE c.RESPONSIBILITY_ID = r.RESPONSIBILITY_ID
AND c.USER_CONCURRENT_PROGRAM_NAME = 'XX: Wydruk Korekty INVOICE'
--and c.REQUESTOR in ('GTYCZYNS', 'PTARA')
--and c.REQUEST_ID = '2626171'

/*Begin fnd_client_info.set_org_context(105); end;*/ Select c.REQUEST_ID, c.REQUEST_DATE, c.ARGUMENT_TEXT, c.COMPLETION_TEXT,<span id="more-288"></span> c.PROGRAM_SHORT_NAME, c.PROGRAM, c.REQUESTOR, c.USER_CONCURRENT_PROGRAM_NAME, r.RESPONSIBILITY_NAME from apps.FND_CONC_REQ_SUMMARY_V c, apps.FND_RESPONSIBILITY_VL r Where c.RESPONSIBILITY_ID = r.RESPONSIBILITY_ID and c.USER_CONCURRENT_PROGRAM_NAME = 'XX: Wydruk Korekty INVOICE' --and c.REQUESTOR in ('GTYCZYNS', 'PTARA') --and c.REQUEST_ID = '2626171'