[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
O.ORGANIZATION_NAME,
MP.COST_ORGANIZATION_ID,
SOB.CURRENCY_CODE,
NVL(EXTENDED_PRECISION
,PRECISION),
NVL(FC.PRECISION
,0),
NVL(MINIMUM_ACCOUNTABLE_UNIT
,POWER(10
,NVL(-PRECISION
,0))),
MCS.CATEGORY_SET_NAME,
DEFAULT_COST_TYPE_ID,
COST_TYPE,
LU2.MEANING,
USERENV('SESSIONID')
INTO P_ORGANIZATION,P_COST_ORG_ID,L_FCN_CURRENCY,P_EXT_PREC,P_PRECISION,ROUND_UNIT,P_CAT_SET_NAME,P_DEF_COST_TYPE,P_COST_TYPE,P_DETAIL_LEVEL,P_SESSIONID
FROM
ORG_ORGANIZATION_DEFINITIONS O,
MTL_PARAMETERS MP,
GL_SETS_OF_BOOKS SOB,
FND_CURRENCIES FC,
MTL_CATEGORY_SETS MCS,
CST_COST_TYPES,
MFG_LOOKUPS LU2
WHERE FC.CURRENCY_CODE = P_CURRENCY_CODE
AND O.ORGANIZATION_ID = P_ORG_ID
AND MP.ORGANIZATION_ID = P_ORG_ID
AND SOB.SET_OF_BOOKS_ID = O.SET_OF_BOOKS_ID
AND MCS.CATEGORY_SET_ID = P_CATEGORY_SET
AND COST_TYPE_ID = P_COST_TYPE_ID
AND LU2.LOOKUP_TYPE = 'CST_BICR_DETAIL_OPTION'
AND LU2.LOOKUP_CODE = P_RPT_OPTION;
SELECT
MEANING
INTO P_SORT_BY
FROM
MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'CST_ITEM_REPORT_SORT'
AND LOOKUP_CODE = P_SORT_OPTION;
SELECT
USER_CONCURRENT_PROGRAM_NAME
INTO P_REPORT_NAME
FROM
FND_CONCURRENT_PROGRAMS_VL P,
FND_CONCURRENT_REQUESTS R
WHERE R.REQUEST_ID = P_CONC_REQUEST_ID
AND P.APPLICATION_ID = R.PROGRAM_APPLICATION_ID
AND P.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID;
SELECT
USER_CONCURRENT_PROGRAM_NAME
INTO P_REPORT_NAME
FROM
FND_CONCURRENT_PROGRAMS_VL P
WHERE P.APPLICATION_ID = 702
AND P.CONCURRENT_PROGRAM_NAME = DECODE(P_SORT_OPTION
,4
,'CSTRSAVR'
,'BOM_CSTRINVR_XMLP_PKG');
SELECT
TO_CHAR(TO_DATE(P_AS_OF_DATE
,'YYYY/MM/DD HH24:MI:SS')
,'DD-MON-YYYY HH24:MI:SS')
INTO L_AS_OF_DATE
FROM
DUAL;