[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
count(*)
INTO WMS_ORG_COUNT
FROM
MTL_PARAMETERS
WHERE WMS_ENABLED_FLAG = 'Y'
AND ORGANIZATION_ID = P_ORG_ID;
SELECT
count(*)
INTO PJM_ORG_COUNT
FROM
MTL_PARAMETERS
WHERE COST_GROUP_ACCOUNTING = 1
AND PROJECT_REFERENCE_ENABLED = 1
AND ORGANIZATION_ID = P_ORG_ID;
SELECT
FC.CURRENCY_CODE,
NVL(FC.EXTENDED_PRECISION
,FC.PRECISION),
NVL(FC.MINIMUM_ACCOUNTABLE_UNIT
,POWER(10
,NVL(-PRECISION
,0))),
SOB.CHART_OF_ACCOUNTS_ID,
CAT.CATEGORY_SET_NAME,
CAT.CATEGORY_SET_ID,
CAT.STRUCTURE_ID,
O.ORGANIZATION_NAME ORGANIZATION,
LU1.MEANING,
LU2.MEANING,
CCT.COST_TYPE
INTO P_CURRENCY_CODE,EXT_PREC,ROUND_UNIT,P_GL_NUM,P_CAT_SET_NAME,P_CATEGORY_SET,P_CAT_NUM,P_ORGANIZATION,P_SORT_BY,P_ITEM_RANGE,P_COST_TYPE
FROM
FND_CURRENCIES FC,
GL_SETS_OF_BOOKS SOB,
ORG_ORGANIZATION_DEFINITIONS O,
MTL_CATEGORY_SETS CAT,
MTL_DEFAULT_CATEGORY_SETS DCAT,
CST_COST_TYPES CCT,
MFG_LOOKUPS LU1,
MFG_LOOKUPS LU2
WHERE O.ORGANIZATION_ID = P_ORG_ID
AND O.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
AND SOB.CURRENCY_CODE = FC.CURRENCY_CODE
AND FC.ENABLED_FLAG = 'Y'
AND DCAT.FUNCTIONAL_AREA_ID = 5
AND CAT.CATEGORY_SET_ID = DECODE(P_RANGE_OPTION
,5
,P_CATEGORY_SET
,DECODE(P_SORT_OPTION
,2
,P_CATEGORY_SET
,DCAT.CATEGORY_SET_ID))
AND LU1.LOOKUP_TYPE = 'CST_ITEM_REPORT_SORT'
AND LU1.LOOKUP_CODE = P_SORT_OPTION
AND LU2.LOOKUP_TYPE = 'CST_ITEM_RANGE'
AND LU2.LOOKUP_CODE = P_RANGE_OPTION
AND CCT.COST_TYPE_ID = P_COST_TYPE_ID;
SELECT
FC.CURRENCY_CODE,
NVL(FC.EXTENDED_PRECISION
,FC.PRECISION),
NVL(FC.MINIMUM_ACCOUNTABLE_UNIT
,POWER(10
,NVL(-PRECISION
,0))),
SOB.CHART_OF_ACCOUNTS_ID,
CAT.CATEGORY_SET_NAME,
CAT.CATEGORY_SET_ID,
CAT.STRUCTURE_ID,
O.ORGANIZATION_NAME,
C.RANGE_OPTION,
LU1.MEANING,
LU2.MEANING,
C.ITEM_RANGE_LOW,
C.ITEM_RANGE_HIGH,
C.SINGLE_ITEM,
C.CATEGORY_ID,
C.INV_ADJUSTMENT_ACCOUNT,
C.UPDATE_DATE,
C.DESCRIPTION,
CCT.COST_TYPE
INTO P_CURRENCY_CODE,EXT_PREC,ROUND_UNIT,P_GL_NUM,P_CAT_SET_NAME,P_CATEGORY_SET,P_CAT_NUM,P_ORGANIZATION,P_RANGE_OPTION,P_SORT_BY,P_ITEM_RANGE,P_ITEM_FROM,P_ITEM_TO,P_ITEM,P_CAT,P_ADJ_ACCOUNT,P_UPDATE_DATE,P_UPDATE_DESC,P_COST_TYPE
FROM
FND_CURRENCIES FC,
GL_SETS_OF_BOOKS SOB,
ORG_ORGANIZATION_DEFINITIONS O,
MTL_CATEGORY_SETS CAT,
MTL_DEFAULT_CATEGORY_SETS DCAT,
MFG_LOOKUPS LU1,
MFG_LOOKUPS LU2,
CST_COST_TYPES CCT,
CST_COST_UPDATES C
WHERE C.COST_UPDATE_ID = P_UPDATE_ID
AND O.ORGANIZATION_ID = C.ORGANIZATION_ID
AND O.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
AND SOB.CURRENCY_CODE = FC.CURRENCY_CODE
AND FC.ENABLED_FLAG = 'Y'
AND DCAT.FUNCTIONAL_AREA_ID = 5
AND CAT.CATEGORY_SET_ID = NVL(C.CATEGORY_SET_ID
,DCAT.CATEGORY_SET_ID)
AND LU1.LOOKUP_TYPE = 'CST_ITEM_REPORT_SORT'
AND LU1.LOOKUP_CODE = P_SORT_OPTION
AND LU2.LOOKUP_TYPE = 'CST_ITEM_RANGE'
AND LU2.LOOKUP_CODE = C.RANGE_OPTION
AND CCT.COST_TYPE_ID = C.COST_TYPE_ID;
DELETE FROM CST_STD_COST_ADJ_VALUES
WHERE COST_UPDATE_ID = P_UPDATE_ID
AND TRANSACTION_TYPE = 1;