[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_SYSTEM_PARAMETERS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| FND Design Data: |  PO.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.
.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 5 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PO_SYSTEM_PARAMETERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ORG_ID
|
| 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) | Indicates whether a supplier acceptance is needed | |
| FUNDS_CHANGE_ALLOWANCE | NUMBER | Tolerance for Funds. | ||
| FUNDS_CHANGE_AMOUNT | NUMBER | Tolerance for Funds Amount . | ||
| ENFORCE_FUNDS_CHANGE_ALLOWANCE | VARCHAR2 | (25) | Enforce Funds Tolerance. | |
| CONTR_OFFICE_AGENCY_ID | NUMBER | |||
| DEFAULT_DISTRIBUTIONS | VARCHAR2 | (1) | ||
| DOC_AMT_THRESHOLD | NUMBER | |||
| EDA_BATCH_SIZE | NUMBER | |||
| EDA_FILES_LOCATION | VARCHAR2 | (500) | ||
| ENABLE_ACRN | VARCHAR2 | (1) | ||
| ENABLE_CDRL | VARCHAR2 | (1) | ||
| ENABLE_EDA | VARCHAR2 | (1) | ||
| ENABLE_EPLS | VARCHAR2 | (1) | ||
| ENABLE_EXHIBITS_LINES | VARCHAR2 | (1) | ||
| ENABLE_FPDS_REPORTING | VARCHAR2 | (1) | ||
| ENABLE_MIPR | VARCHAR2 | (1) | ||
| ENABLE_MIPR_ACCEPTANCE | VARCHAR2 | (1) | ||
| ENABLE_PAYMENT_INSTR | VARCHAR2 | (1) | ||
| ENABLE_SMALL_BUS_COORD | VARCHAR2 | (1) | ||
| ENABLE_UNDEF_CONT_ACT | VARCHAR2 | (1) | ||
| ENABLE_WDOL | VARCHAR2 | (1) | ||
| EPLS_TIMEFRAME | NUMBER | |||
| FPDSNG_AWD_MOD_XML_SOURCE | VARCHAR2 | (80) | ||
| FPDSNG_AWD_XML_SOURCE | VARCHAR2 | (80) | ||
| FPDSNG_IDV_MOD_XML_SOURCE | VARCHAR2 | (80) | ||
| FPDSNG_IDV_XML_SOURCE | VARCHAR2 | (80) | ||
| FPDS_AGENCY_ID | NUMBER | |||
| FPDS_APPROV_NOTIF_TYPE | VARCHAR2 | (30) | ||
| KO_SIGNATURE_REQD | VARCHAR2 | (1) | ||
| WDOL_URL | VARCHAR2 | (500) | ||
| GROUP_SHIPMENTS_FLAG | VARCHAR2 | (1) |
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
, FUNDS_CHANGE_ALLOWANCE
, FUNDS_CHANGE_AMOUNT
, ENFORCE_FUNDS_CHANGE_ALLOWANCE
, CONTR_OFFICE_AGENCY_ID
, DEFAULT_DISTRIBUTIONS
, DOC_AMT_THRESHOLD
, EDA_BATCH_SIZE
, EDA_FILES_LOCATION
, ENABLE_ACRN
, ENABLE_CDRL
, ENABLE_EDA
, ENABLE_EPLS
, ENABLE_EXHIBITS_LINES
, ENABLE_FPDS_REPORTING
, ENABLE_MIPR
, ENABLE_MIPR_ACCEPTANCE
, ENABLE_PAYMENT_INSTR
, ENABLE_SMALL_BUS_COORD
, ENABLE_UNDEF_CONT_ACT
, ENABLE_WDOL
, EPLS_TIMEFRAME
, FPDSNG_AWD_MOD_XML_SOURCE
, FPDSNG_AWD_XML_SOURCE
, FPDSNG_IDV_MOD_XML_SOURCE
, FPDSNG_IDV_XML_SOURCE
, FPDS_AGENCY_ID
, FPDS_APPROV_NOTIF_TYPE
, KO_SIGNATURE_REQD
, WDOL_URL
, GROUP_SHIPMENTS_FLAG
FROM PO.PO_SYSTEM_PARAMETERS_ALL;
PO.PO_SYSTEM_PARAMETERS_ALL does not reference any database object
PO.PO_SYSTEM_PARAMETERS_ALL is referenced by following:
PO
PO_SYSTEM_PARAMETERS_ALL#
|
|
|
|