DBA Data[Home] [Help]

APPS.GMF_RA_GET_CUST_TRX_ID SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

        SELECT cust_trx_type_id
        FROM RA_CUST_TRX_TYPES_ALL
        WHERE TYPE like nvl(trxtype,'%')  AND
            creation_date  BETWEEN
            nvl(startdate,creation_date)  AND
            nvl(enddate,creation_date);