[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select SRT.SALESREP_ID, SRT.TERRITORY_ID,
SRT.START_DATE_ACTIVE, SRT.END_DATE_ACTIVE,
SRT.STATUS, TER.NAME,
TER.SEGMENT1, TER.SEGMENT2,
TER.SEGMENT3, TER.SEGMENT4,
TER.SEGMENT5, TER.SEGMENT6,
TER.SEGMENT7, TER.SEGMENT8,
TER.SEGMENT9, TER.SEGMENT10,
TER.SEGMENT11, TER.SEGMENT12,
TER.SEGMENT13, TER.SEGMENT14,
TER.SEGMENT15, TER.SEGMENT16,
TER.SEGMENT17, TER.SEGMENT18,
TER.SEGMENT19, TER.SEGMENT20,
SRT.ATTRIBUTE_CATEGORY, SRT.ATTRIBUTE1,
SRT.ATTRIBUTE2, SRT.ATTRIBUTE3,
SRT.ATTRIBUTE4, SRT.ATTRIBUTE5,
SRT.ATTRIBUTE6, SRT.ATTRIBUTE7,
SRT.ATTRIBUTE8, SRT.ATTRIBUTE9,
SRT.ATTRIBUTE10, SRT.ATTRIBUTE11,
SRT.ATTRIBUTE12, SRT.ATTRIBUTE13,
SRT.ATTRIBUTE14, SRT.ATTRIBUTE15,
SRT.CREATED_BY, SRT.CREATION_DATE,
SRT.LAST_UPDATE_DATE, SRT.LAST_UPDATED_BY
from RA_SALESREP_TERRITORIES SRT,
RA_TERRITORIES TER
where SRT.salesrep_id = nvl(salesrepid, SRT.salesrep_id)
and SRT.territory_id = nvl(territoryid, SRT.territory_id)
and TER.territory_id = SRT.territory_id
and SRT.last_update_date between
nvl(start_date, SRT.last_update_date)
and nvl(end_date, SRT.last_update_date);
last_update_date out NOCOPY date,
last_updated_by out NOCOPY varchar2,
row_to_fetch in out NOCOPY number,
error_status out NOCOPY number) is
createdby number;
createdby, creation_date, last_update_date,
modifiedby;
last_updated_by := gmf_fnd_get_users.fnd_get_users(modifiedby);