[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
C.PRECISION,
C.CURRENCY_CODE,
SOB.NAME
INTO CP_PRECISION,CP_FUNC_CURR,CP_SOB
FROM
AP_SYSTEM_PARAMETERS ASP,
GL_SETS_OF_BOOKS SOB,
FND_CURRENCIES_VL C
WHERE ASP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
AND ASP.BASE_CURRENCY_CODE = C.CURRENCY_CODE;
SELECT
MAX(REQUEST_ID)
INTO CP_REQUEST_ID
FROM
AR_BR_TRX_BATCH_RPT
WHERE BATCH_ID = P_BATCH;
SELECT
RAB.NAME SC_BATCH_NAME,
ARL_STATUS.MEANING SC_BATCH_STATUS,
SLC.DUE_DATE_LOW SC_DUE_DATE_LOW,
SLC.DUE_DATE_HIGH SC_DUE_DATE_HIGH,
SLC.TRX_DATE_LOW SC_TRX_DATE_LOW,
SLC.TRX_DATE_HIGH SC_TRX_DATE_HIGH,
SLC.TRX_NUMBER_LOW SC_TRX_NUMBER_LOW,
SLC.TRX_NUMBER_HIGH SC_TRX_NUMBER_HIGH,
ARM.NAME SC_PAYMENT_METHOD,
RAB.ISSUE_DATE SC_ISSUE_DATE,
ARL_CLASS.MEANING SC_CUSTOMER_CLASS,
ARL_CATEGORY.MEANING SC_CUSTOMER_CATEGORY,
SUBSTRB(PARTY.PARTY_NAME
,1
,50) SC_CUSTOMER_NAME,
RAC.ACCOUNT_NUMBER SC_CUSTOMER_NUMBER,
RAS.LOCATION SC_LOCATION,
APB.BANK_NAME SC_BANK_NAME,
TYP.NAME SC_TRX_TYPE,
RAB.CURRENCY_CODE SC_CURRENCY_CODE,
BSR.NAME SOURCE
INTO CP_BATCH_NAME,CP_BATCH_STATUS,CP_DUE_DATE_LOW,CP_DUE_DATE_HIGH,
CP_TRX_DATE_LOW,CP_TRX_DATE_HIGH,CP_TRX_NUMBER_LOW,CP_TRX_NUMBER_HIGH,
CP_PAYMENT_METHOD,CP_ISSUE_DATE,CP_CUSTOMER_CLASS,CP_CUSTOMER_CATEGORY,
CP_CUSTOMER_NAME,CP_CUSTOMER_NUMBER,CP_LOCATION,CP_BANK_NAME,CP_TRX_TYPE,CP_CURRENCY_CODE,CP_SOURCE
FROM
AR_SELECTION_CRITERIA SLC,
RA_BATCHES RAB,
AR_RECEIPT_METHODS ARM,
AR_LOOKUPS ARL_STATUS,
AR_LOOKUPS ARL_CLASS,
AR_LOOKUPS ARL_CATEGORY,
HZ_CUST_ACCOUNTS RAC,
HZ_PARTIES PARTY,
HZ_CUST_SITE_USES RAS,
CE_BANK_BRANCHES_V APB,
RA_CUST_TRX_TYPES TYP,
RA_BATCH_SOURCES BSR
WHERE SLC.SELECTION_CRITERIA_ID = rab.selection_criteria_id (+)
AND SLC.RECEIPT_METHOD_ID = arm.receipt_method_id (+)
AND RAB.BATCH_PROCESS_STATUS = arl_status.lookup_code (+)
AND arl_status.lookup_type (+) = 'RA_BATCH_PROCESS_STATUS'
AND SLC.CUSTOMER_CLASS_CODE = arl_class.lookup_code (+)
AND arl_class.lookup_type (+) = 'CUSTOMER CLASS'
AND SLC.CUSTOMER_CATEGORY_CODE = arl_category.lookup_code (+)
AND arl_category.lookup_type (+) = 'CUSTOMER_CATEGORY'
AND SLC.CUSTOMER_ID = rac.cust_account_id (+)
AND RAC.PARTY_ID = party.party_id (+)
AND SLC.SITE_USE_ID = ras.site_use_id (+)
AND SLC.BANK_BRANCH_ID = apb.branch_party_id (+)
AND SLC.CUST_TRX_TYPE_ID = typ.cust_trx_type_id (+)
AND RAB.BATCH_SOURCE_ID = bsr.batch_source_id (+)
AND RAB.BATCH_ID = (
SELECT
MAX(RPT.BATCH_ID)
FROM
AR_BR_TRX_BATCH_RPT RPT
WHERE RPT.REQUEST_ID = CP_REQUEST_ID );
SELECT
SUBSTR(CP.USER_CONCURRENT_PROGRAM_NAME
,1
,80)
INTO L_REPORT_NAME
FROM
FND_CONCURRENT_PROGRAMS_VL CP,
FND_APPLICATION_VL AP
WHERE CP.CONCURRENT_PROGRAM_NAME = 'ARBRATBR'
AND AP.APPLICATION_SHORT_NAME = 'AR'
AND CP.APPLICATION_ID = AP.APPLICATION_ID;