[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
PRIMARY_COST_METHOD
INTO P_COST_METHOD
FROM
MTL_PARAMETERS
WHERE ORGANIZATION_ID = P_ORG_ID;
SELECT
OOD.ORGANIZATION_NAME,
SOB.CURRENCY_CODE,
NVL(FC.MINIMUM_ACCOUNTABLE_UNIT
,POWER(10
,NVL(-FC.PRECISION
,0))),
MCS.CATEGORY_SET_NAME,
LOOKUP1.MEANING,
LOOKUP2.MEANING,
LOOKUP3.MEANING,
LOOKUP4.MEANING,
LOOKUP5.MEANING,
CCT.COST_TYPE
INTO PV_ORGANIZATION_NAME,L_FCN_CURRENCY,PV_ROUND_UNIT,PV_CATEGORY_SET_NAME,PV_SORT_OPTION,PV_COST_GROUP_OPTION,PV_ZERO_COST,PV_EXP_ITEM,PV_EXP_SUBINV,P_COST_TYPE
FROM
ORG_ORGANIZATION_DEFINITIONS OOD,
CST_COST_TYPES CCT,
GL_SETS_OF_BOOKS SOB,
FND_CURRENCIES FC,
MTL_CATEGORY_SETS MCS,
MFG_LOOKUPS LOOKUP1,
MFG_LOOKUPS LOOKUP2,
MFG_LOOKUPS LOOKUP3,
MFG_LOOKUPS LOOKUP4,
MFG_LOOKUPS LOOKUP5
WHERE OOD.ORGANIZATION_ID = P_ORG_ID
AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
AND FC.CURRENCY_CODE = P_CURRENCY_CODE
AND MCS.CATEGORY_SET_ID = P_CATEGORY_SET
AND CCT.COST_TYPE_ID = P_COST_TYPE_ID
AND LOOKUP1.LOOKUP_TYPE = 'CST_ITEM_REPORT_SORT'
AND LOOKUP1.LOOKUP_CODE = P_SORT_OPTION
AND LOOKUP2.LOOKUP_TYPE = 'CST_SRS_COST_GROUP_OPTION'
AND LOOKUP2.LOOKUP_CODE = P_COST_GROUP_OPTION_ID
AND LOOKUP3.LOOKUP_TYPE = 'SYS_YES_NO'
AND LOOKUP3.LOOKUP_CODE = P_ZERO_COST
AND LOOKUP4.LOOKUP_TYPE = 'SYS_YES_NO'
AND LOOKUP4.LOOKUP_CODE = P_EXP_ITEM
AND LOOKUP5.LOOKUP_TYPE = 'SYS_YES_NO'
AND LOOKUP5.LOOKUP_CODE = P_EXP_SUBINV;
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;