[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#;
|
|
|