[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT substrb(SAR.NAME,1,40), SAR.SALESREP_ID,
SAR.SALES_CREDIT_TYPE_ID, nvl(SAR.STATUS,'A'),
SAR.START_DATE_ACTIVE, SAR.END_DATE_ACTIVE,
SAR.GL_ID_REV, SAR.GL_ID_FREIGHT,
SAR.GL_ID_REC, SAR.SET_OF_BOOKS_ID,
SAR.SALESREP_NUMBER, SAR.ATTRIBUTE_CATEGORY,
SAR.ATTRIBUTE1, SAR.ATTRIBUTE2,
SAR.ATTRIBUTE3, SAR.ATTRIBUTE4,
SAR.ATTRIBUTE5, SAR.ATTRIBUTE6,
SAR.ATTRIBUTE7, SAR.ATTRIBUTE8,
SAR.ATTRIBUTE9, SAR.ATTRIBUTE10,
SAR.ATTRIBUTE11, SAR.ATTRIBUTE12,
SAR.ATTRIBUTE13, SAR.ATTRIBUTE14,
SAR.ATTRIBUTE15, SAR.CREATED_BY,
SAR.CREATION_DATE, SAR.LAST_UPDATE_DATE,
SAR.LAST_UPDATED_BY, SAR.ORG_ID
FROM RA_SALESREPS SAR
WHERE LOWER(SAR.NAME) LIKE LOWER(NVL(SALESREP_NAME, SAR.NAME))
AND SAR.SALESREP_ID = NVL(SALESREPID, SAR.SALESREP_ID)
AND SAR.SALESREP_ID > 0
AND SAR.SALESREP_NUMBER is not NULL
AND SAR.NAME is not NULL
AND SAR.LAST_UPDATE_DATE BETWEEN
NVL(START_DATE, SAR.LAST_UPDATE_DATE)
AND NVL(END_DATE, SAR.LAST_UPDATE_DATE)
AND NVL(SAR.ORG_ID,0) = NVL(PORG_ID, NVL(SAR.ORG_ID,0));
LAST_UPDATE_DATE OUT NOCOPY DATE,
LAST_UPDATED_BY OUT NOCOPY NUMBER,
ROW_TO_FETCH IN OUT NOCOPY NUMBER,
ERROR_STATUS OUT NOCOPY NUMBER,
PORG_ID IN OUT NOCOPY NUMBER) IS
/* CREATEDBY NUMBER; */
CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE,
LAST_UPDATED_BY, PORG_ID;
/* LAST_UPDATED_BY := PKG_FND_GET_USERS.FND_GET_USERS(MODIFIEDBY); */