Delivery# from SO#

Get Delivery Number from Sales order number


SELECT wda.delivery_id,wdd.*  FROM
ONT.OE_ORDER_HEADERS_ALL ooha,
ONT.OE_ORDER_LINES_ALL oola,
WSH.WSH_DELIVERY_ASSIGNMENTS wda,
WSH.WSH_DELIVERY_DETAILS wdd
WHERE
wdd.SOURCE_HEADER_ID= ooha.HEADER_ID
AND wdd.DELIVERY_DETAIL_ID =  wda.DELIVERY_DETAIL_ID
AND ooha.HEADER_ID=oola.HEADER_ID
AND wdd.SOURCE_LINE_ID=oola.LINE_ID
AND ooha.order_number= && /* Give the Sales Order Number */
AND ooha.org_id = &&; /*Give the Org Id */ 

User Responsibility

User Responsibility Query :


SELECT FU.USER_ID,
  FU.USER_NAME,
  FU.DESCRIPTION,
  FU.START_DATE "USER_START_DATE",
  FURG.START_DATE "RESP_ASSIGN_DATE",
  FRV.START_DATE "RESP_START_DATE",
  FRV.RESPONSIBILITY_ID,
  FRV.RESPONSIBILITY_NAME,
  FA.APPLICATION_ID,
  FA.APPLICATION_NAME FU.LAST_UPDATE_DATE,
  FU.LAST_UPDATED_BY,
  FU.LAST_LOGON_DATE,
FROM apps.FND_USER FU,
  apps.FND_USER_RESP_GROUPS_DIRECT FURG,
  apps.FND_RESPONSIBILITY_VL FRV,
  apps.FND_APPLICATION_VL FA
WHERE FU.USER_ID                       = FURG.USER_ID
AND FURG.RESPONSIBILITY_ID             = FRV.RESPONSIBILITY_ID
AND FURG.RESPONSIBILITY_APPLICATION_ID = FA.APPLICATION_ID
--AND FU.USER_NAME  = '&&'
AND FRV.RESPONSIBILITY_NAME LIKE '%&&%'
AND (FU.END_DATE   IS NULL
OR FU.END_DATE     >=SYSDATE)
AND (FURG.END_DATE IS NULL
OR FURG.END_DATE   >=SYSDATE)
AND (FRV.END_DATE  IS NULL
OR FRV.END_DATE    >=SYSDATE) ;

Query for Concurrent program run details

Query for Concurrent program run details


SELECT DISTINCT R.REQUEST_DATE,
  R.REQUEST_ID REQUEST,
  R.STATUS_CODE,
  R.PHASE_CODE,
  F.USER_NAME USERNAME,
  (R.ACTUAL_COMPLETION_DATE - R.ACTUAL_START_DATE) * 1440 ELAPSED,
  R.ARGUMENT_TEXT PROGRAM_PARAMETERS,
  C.USER_CONCURRENT_PROGRAM_NAME,
  RR.RESPONSIBILITY_NAME,
  R.CONTROLLING_MANAGER
FROM apps.FND_CONCURRENT_REQUESTS R,
  apps. FND_USER F,
  apps.FND_CONCURRENT_PROGRAMS_TL C,
  apps.FND_RESPONSIBILITY_TL RR
WHERE --R.REQUEST_ID = '&&' AND /* Enter request id */
  C.USER_CONCURRENT_PROGRAM_NAME = '&&' AND /* Enter Request Name */
  R.STATUS_CODE IN ('F', 'I') AND
  R.PHASE_CODE = 'P' AND
  C.CONCURRENT_PROGRAM_ID           = R.CONCURRENT_PROGRAM_ID
AND R.REQUESTED_BY                  = F.USER_ID
AND R.RESPONSIBILITY_ID             = RR.RESPONSIBILITY_ID
AND TRUNC(R.REQUEST_DATE)           = TRUNC(SYSDATE)
AND R.RESPONSIBILITY_APPLICATION_ID = RR.APPLICATION_ID
ORDER BY R.REQUEST_ID DESC;