[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
COUNT(*)
INTO FIFO_ORG_COUNT
FROM
MTL_PARAMETERS
WHERE ORGANIZATION_ID = P_ORG_ID
AND PRIMARY_COST_METHOD IN ( 5 , 6 );
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,
NVL(EXTENDED_PRECISION
,PRECISION)
INTO PV_ORGANIZATION_NAME,L_FCN_CURRENCY,PV_ROUND_UNIT,PV_CATEGORY_SET_NAME,PV_SORT_OPTION,PV_COST_GROUP_OPTION,PV_ZERO_COST_LAYER,PV_REPORT_OPTION,PV_ZERO_QTY_LAYER,P_EXT_PREC
FROM
ORG_ORGANIZATION_DEFINITIONS OOD,
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 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_LAYERS
AND LOOKUP4.LOOKUP_TYPE = 'CST_BICR_DETAIL_OPTION'
AND LOOKUP4.LOOKUP_CODE = P_RPT_OPTION
AND LOOKUP5.LOOKUP_TYPE = 'SYS_YES_NO'
AND LOOKUP5.LOOKUP_CODE = P_ZERO_QTY_LAYERS;
SELECT
COST_GROUP
INTO PV_SPECIFIC_COST_GROUP
FROM
CST_COST_GROUPS
WHERE COST_GROUP_ID = P_COST_GROUP_ID;