POZ_SPEND_AUTH_REQUESTS

This table stores information about the Spend Authorization Requests. Each row includes the request number, the source from where the spend authorization request was raised, the information about when and by whom the request was submitted and rejected (if applicable), etc.

Details

• Schema: FUSION

• Object owner: POZ

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
POZ_SPEND_AUTH_REQUESTS_PK	AUTHORIZATION_REQUEST_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
AUTHORIZATION_REQUEST_ID	NUMBER		18	Yes	Unique identifier of this supplier spend authorization request.
VENDOR_ID	NUMBER		18	Yes	Indicate the supplier which owns this request.
REQUEST_STATUS	VARCHAR2	30			Approval status of the spend authorization request. Acceptable values are: PENDING, APPROVED, REJECTED, CANCELED.
CURRENT_FLAG	VARCHAR2	1		Yes	Indicates whether this request is the current request or there is another request which was submitted after this one.
REQUEST_NUMBER	NUMBER		18	Yes	The request number generated for every Spend Authorization request
REQUEST_SOURCE	VARCHAR2	30			The source from which the spend authorization request was raised.
REQUESTER_PERSON_ID	NUMBER		18		Identifies the person by whom spend authorization request was requested.
REQUESTED_DATE	DATE				Indicates the date when the spend authorization request was submitted.
REJECTED_BY_PERSON_ID	NUMBER		18		Identifies the person by whom spend authorization request was rejected.
REJECTED_DATE	DATE				Indicates the date when the spend authorization request was rejected.
REJECT_REASON	VARCHAR2	2000			Indicates the reason why the spend authorization request was rejected.
APPROVED_BY_PERSON_ID	NUMBER		18		Identifies the last approver by whom spend authorization request was approved.
APPROVED_DATE	DATE				Indicates the date when the spend authorization request was approved.
PRC_BU_ID	NUMBER		18		Procurement business unit identifier
AUCTION_HEADER_ID	NUMBER		18		Indicates which auction this supplier is awarded if applicable.
APPROVAL_INSTANCE_ID	NUMBER		18		Used for tracking bpel instance id for supplier spend authorization request process.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
SPEND_AUTH_JUSTIFICATION	VARCHAR2	2000			User may provide additional details to justify supplier promotion request.
CANCELED_BY_PERSON_ID	NUMBER		18		Identifier of the person who took the cancel action.
CANCELED_DATE	TIMESTAMP				Stores the date and time when the request was canceled by user.
CANCELED_REASON	VARCHAR2	2000			User provided reason for canceling the request.

Foreign Keys

Table	Foreign Table	Foreign Key Column
POZ_SPEND_AUTH_REQUESTS	poz_suppliers	VENDOR_ID

Indexes

Index	Uniqueness	Tablespace	Columns
POZ_SPEND_AUTH_REQUESTS_N1	Non Unique	Default	REQUESTED_DATE
POZ_SPEND_AUTH_REQUESTS_N2	Non Unique	Default	REJECTED_DATE
POZ_SPEND_AUTH_REQUESTS_N3	Non Unique	Default	VENDOR_ID
POZ_SPEND_AUTH_REQUESTS_N4	Non Unique	Default	REQUEST_STATUS
POZ_SPEND_AUTH_REQUESTS_U1	Unique	Default	AUTHORIZATION_REQUEST_ID