DBA Data[Home] [Help] [Dependency Information]

TABLE: PO.PO_SYSTEM_PARAMETERS_ALL

Object Details
Object Name: PO_SYSTEM_PARAMETERS_ALL
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_SYSTEM_PARAMETERS_ALL
Subobject Name:
Status: VALID


PO_SYSTEM_PARAMETERS_ALL stores default, control, and option
information you provide to customize Oracle Purchasing to your
company's needs. PO_SYSTEM_PARAMETERS_ALL corresponds to the
Purchasing Options window. This table has no primary key. The
table should never have more than one row.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_SYSTEM_PARAMETERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ACCRUED_CODE_COMBINATION_ID NUMBER

Unique identifier of the Receipt accrual General Ledger account
PRICE_CHANGE_ALLOWANCE NUMBER

Price difference percentage you allow between requisition and purchase order price
REQ_CAN_AUTHORIZE VARCHAR2 (1)
No longer used
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Default value that indicates whether you require inspection for items you order
ENFORCE_PRICE_CHANGE_ALLOWANCE VARCHAR2 (1)
Indicates whether you enforce the requisition price to purchase order price tolerance during purchase order approval
DEFAULT_RATE_TYPE VARCHAR2 (25)
Default currency rate type for your documents
TAXABLE_FLAG VARCHAR2 (1)
Default value that indicates whether your purchases are taxable
USER_DEFINED_RECEIPT_NUM_CODE VARCHAR2 (25)
Receipt numbering type
MANUAL_RECEIPT_NUM_TYPE VARCHAR2 (25)
Receipt number type
USER_DEFINED_QUOTE_NUM_CODE VARCHAR2 (25)
Quotation numbering type
MANUAL_QUOTE_NUM_TYPE VARCHAR2 (25)
Quotation number type
USER_DEFINED_RFQ_NUM_CODE VARCHAR2 (25)
RFQ numbering type
MANUAL_RFQ_NUM_TYPE VARCHAR2 (25)
RFQ number type
USER_DEFINED_PO_NUM_CODE VARCHAR2 (25)
Purchase order numbering type
MANUAL_PO_NUM_TYPE VARCHAR2 (25)
Purchase order number type
USER_DEFINED_REQ_NUM_CODE VARCHAR2 (25)
Requisition numbering type
MANUAL_REQ_NUM_TYPE VARCHAR2 (25)
Requisition number type
DEFAULT_QUOTE_WARNING_DELAY NUMBER

Default warning delay for quotations
ENFORCE_BUYER_AUTHORITY_FLAG VARCHAR2 (1)
No longer used
ENFORCE_BUYER_NAME_FLAG VARCHAR2 (1)
Indicates whether you allow changing the name of the buyer on a purchase order to any name
ENFORCE_VENDOR_HOLD_FLAG VARCHAR2 (1)
Indicates whether you enforce supplier holds during purchase order approval
NOTIFY_IF_BLANKET_FLAG VARCHAR2 (1)
Indicates whether you want to notify requesters when a blanket purchase order exists for items they request
RFQ_REQUIRED_FLAG VARCHAR2 (1)
Default value that indicates whether you require RFQs for requisitions
PO_DOCUMENT_REPORT_ID NUMBER

No longer used
PO_DOCUMENT_PRINT_FLAG VARCHAR2 (1)
No longer used
RFQ_DOCUMENT_REPORT_ID NUMBER

No longer used
RFQ_DOCUMENT_PRINT_FLAG VARCHAR2 (1)
No longer used
LINE_TYPE_ID NUMBER

Unique identifier of the line type you use on your documents
NEXT_APPROVER_LOOKUP_CODE VARCHAR2 (25)
Type of next approver logic
RECEIVING_FLAG VARCHAR2 (1)
Default value that indicates whether you require receipt for items you order or not
ALLOW_ITEM_DESC_UPDATE_FLAG VARCHAR2 (1)
Default value that indicates whether item descriptions can be updated on document lines
DISPOSITION_WARNING_FLAG VARCHAR2 (1)
Default value that indicates whether disposition messages are displayed for items
ENFORCE_FULL_LOT_QUANTITIES VARCHAR2 (25)
Default value that indicates whether full lot quantities are enforced
SECURITY_POSITION_STRUCTURE_ID NUMBER

Security hierarchy for document types with hierarchy security level
MIN_RELEASE_AMOUNT NUMBER

Default minimum release amount for blanket and planned purchase orders in functional currency
PRICE_TYPE_LOOKUP_CODE VARCHAR2 (25)
Default price type for purchase orders
NOTIFICATION_WARNING_DELAY NUMBER

Not currently used
PRICE_BREAK_LOOKUP_CODE VARCHAR2 (25)
Default price break type for catalog quotations and blanket agreements
INVOICE_CLOSE_CODE VARCHAR2 (25)
Not currently used
RECEIVE_CLOSE_CODE VARCHAR2 (25)
Default receiving close point
INVOICE_CLOSE_TOLERANCE NUMBER

Default invoice close tolerance percent
RECEIVE_CLOSE_TOLERANCE NUMBER

Default receiving close tolerance percent
CANCEL_REQS_ON_PO_CANCEL_FLAG VARCHAR2 (1)
Default value that indicates if a requisition is cancelled when the purchase order is cancelled
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
REQIMPORT_GROUP_BY_CODE VARCHAR2 (25)
Default Requisition Import group-by method
EXPENSE_ACCRUAL_CODE VARCHAR2 (25)
Accrual option for expense items
INVENTORY_ACCRUAL_CODE VARCHAR2 (25)
Accrual option for inventory items
ORDER_TYPE_ID NUMBER

Order type for internal requisitions
ORDER_SOURCE_ID NUMBER

Order source for internal requisitions
SALESREP_ID NUMBER

Not currently used
TERM_ID NUMBER

Not currently used
ORG_ID NUMBER

Organization identifier
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Reserved for country-specific functionality
TAX_FROM_SHIP_TO_LOC_FLAG VARCHAR2 (1)
Default tax code from ship-to location
TAX_FROM_ITEM_FLAG VARCHAR2 (1)
Default tax code from the inventory item
TAX_FROM_VENDOR_FLAG VARCHAR2 (1)
Default tax code from the supplier
TAX_FROM_VENDOR_SITE_FLAG VARCHAR2 (1)
Default tax code from supplier site
TAX_FROM_SYSTEM_FLAG VARCHAR2 (1)
Default tax code from Financial Options window
TAX_HIER_SHIP_TO_LOC NUMBER (15)
Ship-to location position in tax code defaulting hierarchy
TAX_HIER_ITEM NUMBER (15)
Item position in the tax code defaulting hierarchy
TAX_HIER_VENDOR NUMBER (15)
Supplier position in the tax code defaulting hierarchy
TAX_HIER_VENDOR_SITE NUMBER (15)
Supplier Site position in the tax code defaulting hierarchy
TAX_HIER_SYSTEM NUMBER (15)
Financial Options in the tax code defaulting hierarchy
CREATE_DEBIT_MEMO_FLAG VARCHAR2 (25)
Indicator of whether a debit memo should be created
ENFORCE_PRICE_CHANGE_AMOUNT VARCHAR2 (1)
Indicates whether you enforce the requisition price to purchase order price tolerance during purchase order approval
PRICE_CHANGE_AMOUNT NUMBER

Price difference amount you allow between requisition and purchase order price
AUTO_OFFSET_METHOD VARCHAR2 (25)
Automatic offset method; determines how to combine the base account (ex. receiving inspection account) and overlay account (ex. PO distribution charge account) to generate the offset account: GL_ACCOUNT, GL_BALANCING, or null.
PO_OUTPUT_FORMAT VARCHAR2 (10)
The output format for the PO Communication
BUYING_COMPANY_IDENTIFIER VARCHAR2 (10)
Buying company identifier used in generating invoice numbers when gapless invoice numbering is enabled
GAPLESS_INV_NUM_FLAG VARCHAR2 (1)
Indicates whether gapless invoice numbering is used
MAX_ATTACHMENT_SIZE NUMBER

Indicates maximum allowed size of ZIP attachment file
SUPPLIER_AUTHORING_ACCEPTANCE VARCHAR2 (30)
Supplier acceptance level for agreement change
CAT_ADMIN_AUTHORING_ACCEPTANCE VARCHAR2 (30)
Catalog Administrator acceptance level for agreement change
EMAIL_ATTACHMENT_FILENAME VARCHAR2 (30)
Email Attachment File name
ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)
Acceptance Required Flag
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ACCRUED_CODE_COMBINATION_ID
,      PRICE_CHANGE_ALLOWANCE
,      REQ_CAN_AUTHORIZE
,      INSPECTION_REQUIRED_FLAG
,      ENFORCE_PRICE_CHANGE_ALLOWANCE
,      DEFAULT_RATE_TYPE
,      TAXABLE_FLAG
,      USER_DEFINED_RECEIPT_NUM_CODE
,      MANUAL_RECEIPT_NUM_TYPE
,      USER_DEFINED_QUOTE_NUM_CODE
,      MANUAL_QUOTE_NUM_TYPE
,      USER_DEFINED_RFQ_NUM_CODE
,      MANUAL_RFQ_NUM_TYPE
,      USER_DEFINED_PO_NUM_CODE
,      MANUAL_PO_NUM_TYPE
,      USER_DEFINED_REQ_NUM_CODE
,      MANUAL_REQ_NUM_TYPE
,      DEFAULT_QUOTE_WARNING_DELAY
,      ENFORCE_BUYER_AUTHORITY_FLAG
,      ENFORCE_BUYER_NAME_FLAG
,      ENFORCE_VENDOR_HOLD_FLAG
,      NOTIFY_IF_BLANKET_FLAG
,      RFQ_REQUIRED_FLAG
,      PO_DOCUMENT_REPORT_ID
,      PO_DOCUMENT_PRINT_FLAG
,      RFQ_DOCUMENT_REPORT_ID
,      RFQ_DOCUMENT_PRINT_FLAG
,      LINE_TYPE_ID
,      NEXT_APPROVER_LOOKUP_CODE
,      RECEIVING_FLAG
,      ALLOW_ITEM_DESC_UPDATE_FLAG
,      DISPOSITION_WARNING_FLAG
,      ENFORCE_FULL_LOT_QUANTITIES
,      SECURITY_POSITION_STRUCTURE_ID
,      MIN_RELEASE_AMOUNT
,      PRICE_TYPE_LOOKUP_CODE
,      NOTIFICATION_WARNING_DELAY
,      PRICE_BREAK_LOOKUP_CODE
,      INVOICE_CLOSE_CODE
,      RECEIVE_CLOSE_CODE
,      INVOICE_CLOSE_TOLERANCE
,      RECEIVE_CLOSE_TOLERANCE
,      CANCEL_REQS_ON_PO_CANCEL_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQIMPORT_GROUP_BY_CODE
,      EXPENSE_ACCRUAL_CODE
,      INVENTORY_ACCRUAL_CODE
,      ORDER_TYPE_ID
,      ORDER_SOURCE_ID
,      SALESREP_ID
,      TERM_ID
,      ORG_ID
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      TAX_FROM_SHIP_TO_LOC_FLAG
,      TAX_FROM_ITEM_FLAG
,      TAX_FROM_VENDOR_FLAG
,      TAX_FROM_VENDOR_SITE_FLAG
,      TAX_FROM_SYSTEM_FLAG
,      TAX_HIER_SHIP_TO_LOC
,      TAX_HIER_ITEM
,      TAX_HIER_VENDOR
,      TAX_HIER_VENDOR_SITE
,      TAX_HIER_SYSTEM
,      CREATE_DEBIT_MEMO_FLAG
,      ENFORCE_PRICE_CHANGE_AMOUNT
,      PRICE_CHANGE_AMOUNT
,      AUTO_OFFSET_METHOD
,      PO_OUTPUT_FORMAT
,      BUYING_COMPANY_IDENTIFIER
,      GAPLESS_INV_NUM_FLAG
,      MAX_ATTACHMENT_SIZE
,      SUPPLIER_AUTHORING_ACCEPTANCE
,      CAT_ADMIN_AUTHORING_ACCEPTANCE
,      EMAIL_ATTACHMENT_FILENAME
,      ACCEPTANCE_REQUIRED_FLAG
FROM PO.PO_SYSTEM_PARAMETERS_ALL;

Dependencies

[top of page]

PO.PO_SYSTEM_PARAMETERS_ALL does not reference any database object

PO.PO_SYSTEM_PARAMETERS_ALL is referenced by following:

SchemaAPPS
SynonymPO_SYSTEM_PARAMETERS
SynonymPO_SYSTEM_PARAMETERS_ALL