[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
COMPANY_NAME
INTO N
FROM
FA_SYSTEM_CONTROLS;
SELECT
TYPE,
RATE
FROM
JAI_FA_AST_BLOCKS
WHERE BLOCK_ID = CF_4FORMULA.BLOCK_ID
AND BOOK_TYPE_CODE = BOOK_NAME;
SELECT
BLOCK_ID
FROM
JAI_FA_AST_BLOCKS
WHERE TYPE = CF_4FORMULA.TYPE
AND RATE = CF_4FORMULA.RATE
AND START_DATE < JA_JAINASST_XMLP_PKG.START_DATE
AND BOOK_TYPE_CODE = BOOK_NAME;
SELECT
NVL(SUM(FAR.PROCEEDS_OF_SALE - FAR.COST_OF_REMOVAL)
,0) SALE
FROM
JAI_FA_AST_BLOCK_DTLS JBA,
FA_ADDITIONS FA,
JAI_FA_AST_BLOCKS JABLOA,
FA_RETIREMENTS FAR
WHERE FA.OWNED_LEASED = CP_OWNED_LEASED
AND FA.ASSET_ID = JBA.ASSET_ID
AND JBA.BLOCK_ID = JABLOA.BLOCK_ID
AND FAR.BOOK_TYPE_CODE = JABLOA.BOOK_TYPE_CODE
AND JABLOA.BOOK_TYPE_CODE = BOOK_NAME
AND JABLOA.TYPE = CF_4FORMULA.TYPE
AND JABLOA.RATE = CF_4FORMULA.RATE
AND JBA.ASSET_ID = FAR.ASSET_ID
AND FAR.STATUS = CP_STATUS
AND FAR.DATE_RETIRED between JA_JAINASST_XMLP_PKG.START_DATE
AND JA_JAINASST_XMLP_PKG.END_DATE;
SELECT
DEPN_OF_ASSETS
FROM
JAI_FA_DEP_BLOCKS
WHERE UNPLANNED_DEPN = ASSET_ID
AND BLOCK_ID = BLOCK_ID1;
SELECT
'1'
FROM
JAI_FA_AST_BLOCK_DTLS JBA,
FA_BOOKS FAB,
JAI_FA_AST_BLOCKS JABOA
WHERE JBA.ASSET_ID = FAB.ASSET_ID
AND ( ( JBA.ASSET_TYPE = LV_ASSEST_CAPITALIZED
AND FAB.CAPITALIZE_FLAG = LV_FLAG )
OR JBA.ASSET_TYPE = LV_ASSET_TYPE )
AND JBA.DATE_OF_ACQUISITION BETWEEN JABOA.START_DATE
AND NVL(JABOA.YEAR_ENDED
,END_DATE)
AND FAB.DATE_INEFFECTIVE IS NULL
AND FAB.TRANSACTION_HEADER_ID_OUT IS NULL
AND FAB.PERIOD_COUNTER_FULLY_RETIRED IS NULL
AND JBA.BLOCK_ID = TO_CHAR(JABOA.BLOCK_ID)
AND JABOA.BOOK_TYPE_CODE = FAB.BOOK_TYPE_CODE
AND JABOA.BOOK_TYPE_CODE = BOOK_NAME
AND JABOA.TYPE = (
SELECT
TYPE
FROM
JAI_FA_AST_BLOCKS
WHERE BLOCK_ID = CF_6FORMULA.BLOCK_ID )
AND ( JABOA.START_DATE <= NVL(JA_JAINASST_XMLP_PKG.START_DATE
,JABOA.START_DATE)
OR JABOA.START_DATE BETWEEN NVL(JA_JAINASST_XMLP_PKG.START_DATE
,JABOA.START_DATE)
AND NVL(END_DATE
,JABOA.YEAR_ENDED) );
SELECT
OPENING_WDV
FROM
JAI_FA_AST_BLOCKS JABOA
WHERE JABOA.BOOK_TYPE_CODE = BOOK_NAME
AND JABOA.TYPE = (
SELECT
TYPE
FROM
JAI_FA_AST_BLOCKS
WHERE BLOCK_ID = CP_BLOCK_ID )
ORDER BY
START_DATE ASC;
SELECT
A.ASSET_ID,
A.COST,
A.TRANSACTION_HEADER_ID_IN,
A.DATE_EFFECTIVE
FROM
FA_BOOKS A,
JAI_FA_AST_BLOCKS B,
JAI_FA_AST_BLOCK_DTLS C,
JAI_FA_AST_PERIOD_RATES D
WHERE A.ASSET_ID = C.ASSET_ID
AND ( ( C.ASSET_TYPE = LV_ASSEST_CAPITALIZED
AND A.CAPITALIZE_FLAG = LV_FLAG )
OR C.ASSET_TYPE = LV_ASSET_TYPE )
AND B.BLOCK_ID = CF_6FORMULA.BLOCK_ID
AND TO_CHAR(B.BLOCK_ID) = C.BLOCK_ID
AND A.BOOK_TYPE_CODE = B.BOOK_TYPE_CODE
AND A.BOOK_TYPE_CODE = BOOK_NAME
AND C.DATE_OF_ACQUISITION between D.START_DATE
AND D.END_DATE
AND B.START_DATE between NVL(JA_JAINASST_XMLP_PKG.START_DATE
,B.START_DATE)
AND NVL(END_DATE
,B.YEAR_ENDED)
AND D.START_DATE >= ADD_MONTHS(JA_JAINASST_XMLP_PKG.START_DATE,6)
AND D.SLNO = 2
AND A.DATE_INEFFECTIVE is null
AND A.TRANSACTION_HEADER_ID_OUT is null;
SELECT
NVL(SUM(C.PROCEEDS_OF_SALE - C.COST_OF_REMOVAL)
,0) SALE
FROM
JAI_FA_AST_BLOCKS A,
FA_ADDITIONS B,
FA_RETIREMENTS C,
JAI_FA_AST_PERIOD_RATES D
WHERE B.CONTEXT = P_CONTEXT_VALUE
AND TO_CHAR(A.BLOCK_ID) = B.ATTRIBUTE2
AND A.BOOK_TYPE_CODE = BOOK_NAME
AND B.OWNED_LEASED = 'OWNED'
AND B.ASSET_TYPE IN ( 'CAPITALIZED' , 'EXPENSED' )
AND TO_DATE(B.ATTRIBUTE1
,'DD-MON-RRRR') between D.START_DATE
AND D.END_DATE
AND D.START_DATE < ADD_MONTHS(JA_JAINASST_XMLP_PKG.START_DATE
,6)
AND D.SLNO = 1
AND B.ASSET_ID = C.ASSET_ID
AND C.STATUS = 'PROCESSED'
AND A.TYPE = P_BLOCK_TYPE
AND A.BLOCK_ID = CF_6FORMULA.BLOCK_ID
AND C.DATE_RETIRED BETWEEN JA_JAINASST_XMLP_PKG.START_DATE
AND JA_JAINASST_XMLP_PKG.END_DATE;
SELECT
NVL(SUM(C.PROCEEDS_OF_SALE - C.COST_OF_REMOVAL)
,0) SALE
FROM
JAI_FA_AST_BLOCKS A,
FA_ADDITIONS B,
FA_RETIREMENTS C,
JAI_FA_AST_PERIOD_RATES D
WHERE B.CONTEXT = P_CONTEXT_VALUE
AND TO_CHAR(A.BLOCK_ID) = B.ATTRIBUTE2
AND A.BOOK_TYPE_CODE = BOOK_NAME
AND B.OWNED_LEASED = 'OWNED'
AND B.ASSET_TYPE IN ( 'CAPITALIZED' , 'EXPENSED' )
AND TO_DATE(B.ATTRIBUTE1
,'DD-MON-RRRR') between D.START_DATE
AND D.END_DATE
AND D.START_DATE >= ADD_MONTHS(JA_JAINASST_XMLP_PKG.START_DATE
,6)
AND D.SLNO = 2
AND B.ASSET_ID = C.ASSET_ID
AND C.STATUS = 'PROCESSED'
AND A.TYPE = P_BLOCK_TYPE
AND A.BLOCK_ID = CF_6FORMULA.BLOCK_ID
AND C.DATE_RETIRED BETWEEN JA_JAINASST_XMLP_PKG.START_DATE
AND JA_JAINASST_XMLP_PKG.END_DATE;
SELECT
NVL(SUM(COST)
,0) COST
FROM
FA_BOOKS A,
JAI_FA_AST_BLOCK_DTLS B
WHERE A.ASSET_ID NOT IN (
SELECT
ASSET_ID
FROM
FA_RETIREMENTS
WHERE BOOK_TYPE_CODE = BOOK_NAME
AND STATUS = 'PROCESSED'
AND DATE_RETIRED between START_DATE
AND END_DATE )
AND B.ASSET_ID = A.ASSET_ID
AND ( ( B.ASSET_TYPE = LV_ASSEST_CAPITALIZED
AND A.CAPITALIZE_FLAG = LV_FLAG )
OR B.ASSET_TYPE = LV_ASSET_TYPE )
AND B.BLOCK_ID = TO_CHAR(BLOCK_ID)
AND A.BOOK_TYPE_CODE = BOOK_NAME
AND B.DATE_OF_ACQUISITION between START_DATE
AND END_DATE
AND A.RETIREMENT_PENDING_FLAG = 'NO'
GROUP BY
B.BLOCK_ID;
SELECT
CONCURRENT_PROGRAM_ID,
NVL(ENABLE_TRACE
,'N')
FROM
FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID = P_REQUEST_ID;
SELECT
A.SID,
A.SERIAL#,
B.SPID
FROM
V$SESSION A,
V$PROCESS B
WHERE AUDSID = USERENV('SESSIONID')
AND A.PADDR = B.ADDR;
SELECT
NAME
FROM
V$DATABASE;
SELECT
TRANSACTION_HEADER_ID_IN,
DATE_EFFECTIVE,
FAB.COST
FROM
FA_BOOKS FAB
WHERE FAB.TRANSACTION_HEADER_ID_OUT = CP_TRANSACTION_HEADER_ID_IN
AND TRUNC(FAB.DATE_INEFFECTIVE) = TRUNC(CP_DATE_EFFECTIVE)
AND FAB.BOOK_TYPE_CODE = CP_BOOK_NAME
AND FAB.ASSET_ID = CP_ASSET_ID
AND FAB.RETIREMENT_ID IS NOT NULL;
SELECT
TRANSACTION_HEADER_ID_IN,
DATE_EFFECTIVE,
FAB.COST
FROM
FA_BOOKS FAB
WHERE FAB.TRANSACTION_HEADER_ID_OUT = CP_TRANSACTION_HEADER_ID_IN
AND TRUNC(FAB.DATE_INEFFECTIVE) = TRUNC(CP_DATE_EFFECTIVE)
AND FAB.BOOK_TYPE_CODE = CP_BOOK_NAME
AND FAB.ASSET_ID = CP_ASSET_ID
AND FAB.RETIREMENT_ID IS NOT NULL;