[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_SYSTEM_PARAMETERS_ALL# |
|---|---|
| Object Type: | VIEW |
| Owner: | PO |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| CREATION_DATE | DATE | |||
| CREATED_BY | NUMBER | |||
| ACCRUED_CODE_COMBINATION_ID | NUMBER | |||
| PRICE_CHANGE_ALLOWANCE | NUMBER | |||
| REQ_CAN_AUTHORIZE | VARCHAR2 | (1) | ||
| INSPECTION_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| ENFORCE_PRICE_CHANGE_ALLOWANCE | VARCHAR2 | (1) | ||
| DEFAULT_RATE_TYPE | VARCHAR2 | (25) | ||
| TAXABLE_FLAG | VARCHAR2 | (1) | ||
| USER_DEFINED_RECEIPT_NUM_CODE | VARCHAR2 | (25) | ||
| MANUAL_RECEIPT_NUM_TYPE | VARCHAR2 | (25) | ||
| USER_DEFINED_QUOTE_NUM_CODE | VARCHAR2 | (25) | ||
| MANUAL_QUOTE_NUM_TYPE | VARCHAR2 | (25) | ||
| USER_DEFINED_RFQ_NUM_CODE | VARCHAR2 | (25) | ||
| MANUAL_RFQ_NUM_TYPE | VARCHAR2 | (25) | ||
| USER_DEFINED_PO_NUM_CODE | VARCHAR2 | (25) | ||
| MANUAL_PO_NUM_TYPE | VARCHAR2 | (25) | ||
| USER_DEFINED_REQ_NUM_CODE | VARCHAR2 | (25) | ||
| MANUAL_REQ_NUM_TYPE | VARCHAR2 | (25) | ||
| DEFAULT_QUOTE_WARNING_DELAY | NUMBER | |||
| ENFORCE_BUYER_AUTHORITY_FLAG | VARCHAR2 | (1) | ||
| ENFORCE_BUYER_NAME_FLAG | VARCHAR2 | (1) | ||
| ENFORCE_VENDOR_HOLD_FLAG | VARCHAR2 | (1) | ||
| NOTIFY_IF_BLANKET_FLAG | VARCHAR2 | (1) | ||
| RFQ_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| PO_DOCUMENT_REPORT_ID | NUMBER | |||
| PO_DOCUMENT_PRINT_FLAG | VARCHAR2 | (1) | ||
| RFQ_DOCUMENT_REPORT_ID | NUMBER | |||
| RFQ_DOCUMENT_PRINT_FLAG | VARCHAR2 | (1) | ||
| LINE_TYPE_ID | NUMBER | |||
| NEXT_APPROVER_LOOKUP_CODE | VARCHAR2 | (25) | ||
| RECEIVING_FLAG | VARCHAR2 | (1) | ||
| ALLOW_ITEM_DESC_UPDATE_FLAG | VARCHAR2 | (1) | ||
| DISPOSITION_WARNING_FLAG | VARCHAR2 | (1) | ||
| ENFORCE_FULL_LOT_QUANTITIES | VARCHAR2 | (25) | ||
| SECURITY_POSITION_STRUCTURE_ID | NUMBER | |||
| MIN_RELEASE_AMOUNT | NUMBER | |||
| PRICE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | ||
| NOTIFICATION_WARNING_DELAY | NUMBER | |||
| PRICE_BREAK_LOOKUP_CODE | VARCHAR2 | (25) | ||
| INVOICE_CLOSE_CODE | VARCHAR2 | (25) | ||
| RECEIVE_CLOSE_CODE | VARCHAR2 | (25) | ||
| INVOICE_CLOSE_TOLERANCE | NUMBER | |||
| RECEIVE_CLOSE_TOLERANCE | NUMBER | |||
| CANCEL_REQS_ON_PO_CANCEL_FLAG | VARCHAR2 | (1) | ||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| REQIMPORT_GROUP_BY_CODE | VARCHAR2 | (25) | ||
| EXPENSE_ACCRUAL_CODE | VARCHAR2 | (25) | ||
| INVENTORY_ACCRUAL_CODE | VARCHAR2 | (25) | ||
| ORDER_TYPE_ID | NUMBER | |||
| ORDER_SOURCE_ID | NUMBER | |||
| SALESREP_ID | NUMBER | |||
| TERM_ID | NUMBER | |||
| ORG_ID | NUMBER | |||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
| TAX_FROM_SHIP_TO_LOC_FLAG | VARCHAR2 | (1) | ||
| TAX_FROM_ITEM_FLAG | VARCHAR2 | (1) | ||
| TAX_FROM_VENDOR_FLAG | VARCHAR2 | (1) | ||
| TAX_FROM_VENDOR_SITE_FLAG | VARCHAR2 | (1) | ||
| TAX_FROM_SYSTEM_FLAG | VARCHAR2 | (1) | ||
| TAX_HIER_SHIP_TO_LOC | NUMBER | (15) | ||
| TAX_HIER_ITEM | NUMBER | (15) | ||
| TAX_HIER_VENDOR | NUMBER | (15) | ||
| TAX_HIER_VENDOR_SITE | NUMBER | (15) | ||
| TAX_HIER_SYSTEM | NUMBER | (15) | ||
| CREATE_DEBIT_MEMO_FLAG | VARCHAR2 | (25) | ||
| ENFORCE_PRICE_CHANGE_AMOUNT | VARCHAR2 | (1) | ||
| PRICE_CHANGE_AMOUNT | NUMBER | |||
| AUTO_OFFSET_METHOD | VARCHAR2 | (25) | ||
| PO_OUTPUT_FORMAT | VARCHAR2 | (10) | ||
| BUYING_COMPANY_IDENTIFIER | VARCHAR2 | (10) | ||
| GAPLESS_INV_NUM_FLAG | VARCHAR2 | (1) | ||
| MAX_ATTACHMENT_SIZE | NUMBER | |||
| SUPPLIER_AUTHORING_ACCEPTANCE | VARCHAR2 | (30) | ||
| CAT_ADMIN_AUTHORING_ACCEPTANCE | VARCHAR2 | (30) | ||
| EMAIL_ATTACHMENT_FILENAME | VARCHAR2 | (30) | ||
| ACCEPTANCE_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| FUNDS_CHANGE_ALLOWANCE | NUMBER | |||
| FUNDS_CHANGE_AMOUNT | NUMBER | |||
| ENFORCE_FUNDS_CHANGE_ALLOWANCE | VARCHAR2 | (25) | ||
| 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
APPS
PO_SYSTEM_PARAMETERS
PO_SYSTEM_PARAMETERS_ALL
|
|
|
|