[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
SUBSTR(USER
,1
,10)
INTO
CP_PARA
FROM
DUAL;
SELECT
ITEM_NAME,
SUBSTR(TEXT
,1
,100) LANG_NAME
FROM
XTR_SYS_LANGUAGES_VL
WHERE MODULE_NAME = 'XTRLTDAP';
UPDATE
XTR_SETTLEMENT_SCRIPTS_V
SET
LAST_RUN_ON = TO_DATE(PERIOD_FROM_DATE
,'DD/MM/YYYY')
,RUN_REQUESTED_ON = NULL
,ONLY_NEW_TRANSACTIONS = NULL
-- ,LAST_FILE_CREATED = DESNAME
WHERE SCRIPT_NAME in ( 'EFT' , 'SN' , 'SS' , 'SS2' )
AND SCRIPT_TYPE = 'REPORT';
UPDATE
XTR_DEAL_DATE_AMOUNTS_V a
SET
A.SETTLEMENT_ACTIONED = 'Y'
-- ,A.SETTLEMENT_ACTIONED_FILE = DESNAME
WHERE A.ACTUAL_SETTLEMENT_DATE = TO_DATE(PERIOD_FROM_DATE
,'DD/MM/YYYY')
AND A.CASHFLOW_AMOUNT <> 0
AND A.ACCOUNT_NO like NVL(UPPER(ACCOUNT_NUMBER)
,'%')
AND A.COMPANY_CODE like NVL(UPPER(COMP_CODE)
,'%')
AND A.TRANS_MTS = 'Y'
AND A.SETTLE = 'Y'
AND A.CHQ_REQD is NULL
AND A.DIRECT_DEBIT is NULL
AND ( ( UPPER(PREV_ACTIONED) = 'Y' )
OR ( UPPER(PREV_ACTIONED) = 'N'
AND A.SETTLEMENT_ACTIONED is NULL ) )
AND A.ACCOUNT_NO IN (
SELECT
B.ACCOUNT_NUMBER
FROM
XTR_BANK_ACCOUNTS_V B,
XTR_SETTLEMENT_SCRIPTS_V S
WHERE B.ACCOUNT_NUMBER = A.ACCOUNT_NO
AND B.ACCOUNT_NUMBER like NVL(UPPER(ACCOUNT_NUMBER)
,'%')
AND B.PARTY_CODE like NVL(UPPER(COMP_CODE)
,'%')
AND B.EFT_SCRIPT_NAME in ( 'EFT' , 'SN' , 'SS' , 'SS2' )
AND S.SCRIPT_NAME = B.EFT_SCRIPT_NAME
AND NVL(S.CURRENCY_CODE
,B.CURRENCY) = B.CURRENCY
AND S.SCRIPT_TYPE = 'REPORT' );
SELECT
USER_CONCURRENT_PROGRAM_NAME
FROM
FND_CONCURRENT_PROGRAMS_VL
WHERE CONCURRENT_PROGRAM_NAME = 'XTRLTDAP'
AND APPLICATION_ID = 185;