POR_REQ_BU_OPTIONS

Details

Schema: FUSION
Object owner: POR
Object type: TABLE
Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
POR_REQ_BU_OPTIONS_ALL_PK	REQ_BU_OPTIONS_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
REQ_BU_ID	NUMBER		18	Yes	Requisitioning BU Unique Identifier
APPR_REQUIRED_BUYER_MOD_FLAG	VARCHAR2	1			APPR_REQUIRED_BUYER_MOD_FLAG
ENABLE_APPROVER_OVERRIDE_FLAG	VARCHAR2	1			Requisitioning BU configuration to allow the requester to overwrite the application generated approver.
SUPPLY_AVAIL_ENABLED_FLAG	VARCHAR2	1			Enable Supply Availability Details for Internal Transfer of Requisitioning BU
PRC_BU_ID	NUMBER		18		Default Procurement BU
REQ_BU_OPTIONS_ID	NUMBER		18	Yes	Primary Key
INV_ORG_ID	NUMBER		18	Yes	Inventory Organization Unique Identifier
LINE_TYPE_ID	NUMBER		18		Line Type unique identifier used on the documents
REQIMPORT_GROUP_BY_CODE	VARCHAR2	25			Requisition Import group-by method
URL_DISPLAY_CONTENT	VARCHAR2	1000			Display Content for Purchasing News	Obsolete
URL_DISPLAY_NAME	VARCHAR2	100			Display name for URL	Obsolete
PURCHASING_NEWS_URL	VARCHAR2	250			Purchasing News	Obsolete
REAPPROVAL_REQUIRED_FLAG	VARCHAR2	1			Indicates whether Reaproval is required for changes made during an active approval process
CREATE_ORDERS_FLAG	VARCHAR2	1			Indicates whether to create orders immediately after requisition import
UOM_CONVERSION_FLAG	VARCHAR2	1			Indicates whether to allow requisition-to-agreement UOM conversion
PRICE_CHANGE_PERCENT_TOLERANCE	NUMBER				Price difference percentage allowed between requisition and purchase order
PRICE_CHANGE_AMOUNT_TOLERANCE	NUMBER				Price difference amount allowed between requisition and purchase order
SHIP_TO_LOCATION_ID	NUMBER		18		Ship-to Location Unique Identifier
ONE_TIME_LOCATION_ID	NUMBER		18		Location Id for one time address
CANCEL_BACKING_REQ_CODE	VARCHAR2	30			Indicates whether a backing requisition should be cancelled when purchase order is cancelled.
ENABLE_CATG_SUGGESTIONS_FLAG	VARCHAR2	1		Yes	Flag to indicate whether category suggestions on noncatalog requests is enabled.
SPEND_CLASS_KNOWLEDGE_BASE	VARCHAR2	90			Indicates which spend classification knowledge base to use for this requisitioning BU.
ALLOW_ONETIME_ADDR_FLAG	VARCHAR2	1			Specifies if one time addresses are allowed for the req bu
REQ_HEADER_DFF_CONTEXT_CODE	VARCHAR2	80			Requisition Header DFF Context Value
REQ_LINE_DFF_CONTEXT_CODE	VARCHAR2	80			Requisition Line DFF Context Value
REQ_DIST_DFF_CONTEXT_CODE	VARCHAR2	80			Requisition Distribution DFF Context Value
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.
MULTIPLE_LEGAL_ENTITIES	VARCHAR2	20		Yes	Indicates whether multiple legal entities on order should be allowed or not.

Foreign Keys

Table	Foreign Table	Foreign Key Column
POR_REQ_BU_OPTIONS_ALL	po_line_types_b	LINE_TYPE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
POR_REQ_BU_OPTIONS_ALL_U1	Unique	Default	REQ_BU_ID
POR_REQ_BU_OPTIONS_ALL_U2	Unique	Default	REQ_BU_OPTIONS_ID