VIEW: PO.PO_SYSTEM_PARAMETERS_ALL#

Source

View Text - Preformatted

select LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ACCRUED_CODE_COMBINATION_ID ACCRUED_CODE_COMBINATION_ID, PRICE_CHANGE_ALLOWANCE PRICE_CHANGE_ALLOWANCE, REQ_CAN_AUTHORIZE REQ_CAN_AUTHORIZE, INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG, ENFORCE_PRICE_CHANGE_ALLOWANCE ENFORCE_PRICE_CHANGE_ALLOWANCE, DEFAULT_RATE_TYPE DEFAULT_RATE_TYPE, TAXABLE_FLAG TAXABLE_FLAG, USER_DEFINED_RECEIPT_NUM_CODE USER_DEFINED_RECEIPT_NUM_CODE, MANUAL_RECEIPT_NUM_TYPE MANUAL_RECEIPT_NUM_TYPE, USER_DEFINED_QUOTE_NUM_CODE USER_DEFINED_QUOTE_NUM_CODE, MANUAL_QUOTE_NUM_TYPE MANUAL_QUOTE_NUM_TYPE, USER_DEFINED_RFQ_NUM_CODE USER_DEFINED_RFQ_NUM_CODE, MANUAL_RFQ_NUM_TYPE MANUAL_RFQ_NUM_TYPE, USER_DEFINED_PO_NUM_CODE USER_DEFINED_PO_NUM_CODE, MANUAL_PO_NUM_TYPE MANUAL_PO_NUM_TYPE, USER_DEFINED_REQ_NUM_CODE USER_DEFINED_REQ_NUM_CODE, MANUAL_REQ_NUM_TYPE MANUAL_REQ_NUM_TYPE, DEFAULT_QUOTE_WARNING_DELAY DEFAULT_QUOTE_WARNING_DELAY, ENFORCE_BUYER_AUTHORITY_FLAG ENFORCE_BUYER_AUTHORITY_FLAG, ENFORCE_BUYER_NAME_FLAG ENFORCE_BUYER_NAME_FLAG, ENFORCE_VENDOR_HOLD_FLAG ENFORCE_VENDOR_HOLD_FLAG, NOTIFY_IF_BLANKET_FLAG NOTIFY_IF_BLANKET_FLAG, RFQ_REQUIRED_FLAG RFQ_REQUIRED_FLAG, PO_DOCUMENT_REPORT_ID PO_DOCUMENT_REPORT_ID, PO_DOCUMENT_PRINT_FLAG PO_DOCUMENT_PRINT_FLAG, RFQ_DOCUMENT_REPORT_ID RFQ_DOCUMENT_REPORT_ID, RFQ_DOCUMENT_PRINT_FLAG RFQ_DOCUMENT_PRINT_FLAG, LINE_TYPE_ID LINE_TYPE_ID, NEXT_APPROVER_LOOKUP_CODE NEXT_APPROVER_LOOKUP_CODE, RECEIVING_FLAG RECEIVING_FLAG, ALLOW_ITEM_DESC_UPDATE_FLAG ALLOW_ITEM_DESC_UPDATE_FLAG, DISPOSITION_WARNING_FLAG DISPOSITION_WARNING_FLAG, ENFORCE_FULL_LOT_QUANTITIES ENFORCE_FULL_LOT_QUANTITIES, SECURITY_POSITION_STRUCTURE_ID SECURITY_POSITION_STRUCTURE_ID, MIN_RELEASE_AMOUNT MIN_RELEASE_AMOUNT, PRICE_TYPE_LOOKUP_CODE PRICE_TYPE_LOOKUP_CODE, NOTIFICATION_WARNING_DELAY NOTIFICATION_WARNING_DELAY, PRICE_BREAK_LOOKUP_CODE PRICE_BREAK_LOOKUP_CODE, INVOICE_CLOSE_CODE INVOICE_CLOSE_CODE, RECEIVE_CLOSE_CODE RECEIVE_CLOSE_CODE, INVOICE_CLOSE_TOLERANCE INVOICE_CLOSE_TOLERANCE, RECEIVE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE, CANCEL_REQS_ON_PO_CANCEL_FLAG CANCEL_REQS_ON_PO_CANCEL_FLAG, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQIMPORT_GROUP_BY_CODE REQIMPORT_GROUP_BY_CODE, EXPENSE_ACCRUAL_CODE EXPENSE_ACCRUAL_CODE, INVENTORY_ACCRUAL_CODE INVENTORY_ACCRUAL_CODE, ORDER_TYPE_ID ORDER_TYPE_ID, ORDER_SOURCE_ID ORDER_SOURCE_ID, SALESREP_ID SALESREP_ID, TERM_ID TERM_ID, ORG_ID ORG_ID, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, TAX_FROM_SHIP_TO_LOC_FLAG TAX_FROM_SHIP_TO_LOC_FLAG, TAX_FROM_ITEM_FLAG TAX_FROM_ITEM_FLAG, TAX_FROM_VENDOR_FLAG TAX_FROM_VENDOR_FLAG, TAX_FROM_VENDOR_SITE_FLAG TAX_FROM_VENDOR_SITE_FLAG, TAX_FROM_SYSTEM_FLAG TAX_FROM_SYSTEM_FLAG, TAX_HIER_SHIP_TO_LOC TAX_HIER_SHIP_TO_LOC, TAX_HIER_ITEM TAX_HIER_ITEM, TAX_HIER_VENDOR TAX_HIER_VENDOR, TAX_HIER_VENDOR_SITE TAX_HIER_VENDOR_SITE, TAX_HIER_SYSTEM TAX_HIER_SYSTEM, CREATE_DEBIT_MEMO_FLAG CREATE_DEBIT_MEMO_FLAG, ENFORCE_PRICE_CHANGE_AMOUNT ENFORCE_PRICE_CHANGE_AMOUNT, PRICE_CHANGE_AMOUNT PRICE_CHANGE_AMOUNT, AUTO_OFFSET_METHOD AUTO_OFFSET_METHOD, PO_OUTPUT_FORMAT PO_OUTPUT_FORMAT, BUYING_COMPANY_IDENTIFIER BUYING_COMPANY_IDENTIFIER, GAPLESS_INV_NUM_FLAG GAPLESS_INV_NUM_FLAG, MAX_ATTACHMENT_SIZE MAX_ATTACHMENT_SIZE, SUPPLIER_AUTHORING_ACCEPTANCE SUPPLIER_AUTHORING_ACCEPTANCE, CAT_ADMIN_AUTHORING_ACCEPTANCE CAT_ADMIN_AUTHORING_ACCEPTANCE, EMAIL_ATTACHMENT_FILENAME EMAIL_ATTACHMENT_FILENAME, ACCEPTANCE_REQUIRED_FLAG ACCEPTANCE_REQUIRED_FLAG, FUNDS_CHANGE_ALLOWANCE FUNDS_CHANGE_ALLOWANCE, FUNDS_CHANGE_AMOUNT FUNDS_CHANGE_AMOUNT, ENFORCE_FUNDS_CHANGE_ALLOWANCE ENFORCE_FUNDS_CHANGE_ALLOWANCE, CONTR_OFFICE_AGENCY_ID CONTR_OFFICE_AGENCY_ID, DEFAULT_DISTRIBUTIONS DEFAULT_DISTRIBUTIONS, DOC_AMT_THRESHOLD DOC_AMT_THRESHOLD, EDA_BATCH_SIZE EDA_BATCH_SIZE, EDA_FILES_LOCATION EDA_FILES_LOCATION, ENABLE_ACRN ENABLE_ACRN, ENABLE_CDRL ENABLE_CDRL, ENABLE_EDA ENABLE_EDA, ENABLE_EPLS ENABLE_EPLS, ENABLE_EXHIBITS_LINES ENABLE_EXHIBITS_LINES, ENABLE_FPDS_REPORTING ENABLE_FPDS_REPORTING, ENABLE_MIPR ENABLE_MIPR, ENABLE_MIPR_ACCEPTANCE ENABLE_MIPR_ACCEPTANCE, ENABLE_PAYMENT_INSTR ENABLE_PAYMENT_INSTR, ENABLE_SMALL_BUS_COORD ENABLE_SMALL_BUS_COORD, ENABLE_UNDEF_CONT_ACT ENABLE_UNDEF_CONT_ACT, ENABLE_WDOL ENABLE_WDOL, EPLS_TIMEFRAME EPLS_TIMEFRAME, FPDSNG_AWD_MOD_XML_SOURCE FPDSNG_AWD_MOD_XML_SOURCE, FPDSNG_AWD_XML_SOURCE FPDSNG_AWD_XML_SOURCE, FPDSNG_IDV_MOD_XML_SOURCE FPDSNG_IDV_MOD_XML_SOURCE, FPDSNG_IDV_XML_SOURCE FPDSNG_IDV_XML_SOURCE, FPDS_AGENCY_ID FPDS_AGENCY_ID, FPDS_APPROV_NOTIF_TYPE FPDS_APPROV_NOTIF_TYPE, KO_SIGNATURE_REQD KO_SIGNATURE_REQD, WDOL_URL WDOL_URL, GROUP_SHIPMENTS_FLAG GROUP_SHIPMENTS_FLAG from "PO"."PO_SYSTEM_PARAMETERS_ALL"

View Text - HTML Formatted

SELECT LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ACCRUED_CODE_COMBINATION_ID ACCRUED_CODE_COMBINATION_ID
, PRICE_CHANGE_ALLOWANCE PRICE_CHANGE_ALLOWANCE
, REQ_CAN_AUTHORIZE REQ_CAN_AUTHORIZE
, INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG
, ENFORCE_PRICE_CHANGE_ALLOWANCE ENFORCE_PRICE_CHANGE_ALLOWANCE
, DEFAULT_RATE_TYPE DEFAULT_RATE_TYPE
, TAXABLE_FLAG TAXABLE_FLAG
, USER_DEFINED_RECEIPT_NUM_CODE USER_DEFINED_RECEIPT_NUM_CODE
, MANUAL_RECEIPT_NUM_TYPE MANUAL_RECEIPT_NUM_TYPE
, USER_DEFINED_QUOTE_NUM_CODE USER_DEFINED_QUOTE_NUM_CODE
, MANUAL_QUOTE_NUM_TYPE MANUAL_QUOTE_NUM_TYPE
, USER_DEFINED_RFQ_NUM_CODE USER_DEFINED_RFQ_NUM_CODE
, MANUAL_RFQ_NUM_TYPE MANUAL_RFQ_NUM_TYPE
, USER_DEFINED_PO_NUM_CODE USER_DEFINED_PO_NUM_CODE
, MANUAL_PO_NUM_TYPE MANUAL_PO_NUM_TYPE
, USER_DEFINED_REQ_NUM_CODE USER_DEFINED_REQ_NUM_CODE
, MANUAL_REQ_NUM_TYPE MANUAL_REQ_NUM_TYPE
, DEFAULT_QUOTE_WARNING_DELAY DEFAULT_QUOTE_WARNING_DELAY
, ENFORCE_BUYER_AUTHORITY_FLAG ENFORCE_BUYER_AUTHORITY_FLAG
, ENFORCE_BUYER_NAME_FLAG ENFORCE_BUYER_NAME_FLAG
, ENFORCE_VENDOR_HOLD_FLAG ENFORCE_VENDOR_HOLD_FLAG
, NOTIFY_IF_BLANKET_FLAG NOTIFY_IF_BLANKET_FLAG
, RFQ_REQUIRED_FLAG RFQ_REQUIRED_FLAG
, PO_DOCUMENT_REPORT_ID PO_DOCUMENT_REPORT_ID
, PO_DOCUMENT_PRINT_FLAG PO_DOCUMENT_PRINT_FLAG
, RFQ_DOCUMENT_REPORT_ID RFQ_DOCUMENT_REPORT_ID
, RFQ_DOCUMENT_PRINT_FLAG RFQ_DOCUMENT_PRINT_FLAG
, LINE_TYPE_ID LINE_TYPE_ID
, NEXT_APPROVER_LOOKUP_CODE NEXT_APPROVER_LOOKUP_CODE
, RECEIVING_FLAG RECEIVING_FLAG
, ALLOW_ITEM_DESC_UPDATE_FLAG ALLOW_ITEM_DESC_UPDATE_FLAG
, DISPOSITION_WARNING_FLAG DISPOSITION_WARNING_FLAG
, ENFORCE_FULL_LOT_QUANTITIES ENFORCE_FULL_LOT_QUANTITIES
, SECURITY_POSITION_STRUCTURE_ID SECURITY_POSITION_STRUCTURE_ID
, MIN_RELEASE_AMOUNT MIN_RELEASE_AMOUNT
, PRICE_TYPE_LOOKUP_CODE PRICE_TYPE_LOOKUP_CODE
, NOTIFICATION_WARNING_DELAY NOTIFICATION_WARNING_DELAY
, PRICE_BREAK_LOOKUP_CODE PRICE_BREAK_LOOKUP_CODE
, INVOICE_CLOSE_CODE INVOICE_CLOSE_CODE
, RECEIVE_CLOSE_CODE RECEIVE_CLOSE_CODE
, INVOICE_CLOSE_TOLERANCE INVOICE_CLOSE_TOLERANCE
, RECEIVE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE
, CANCEL_REQS_ON_PO_CANCEL_FLAG CANCEL_REQS_ON_PO_CANCEL_FLAG
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQIMPORT_GROUP_BY_CODE REQIMPORT_GROUP_BY_CODE
, EXPENSE_ACCRUAL_CODE EXPENSE_ACCRUAL_CODE
, INVENTORY_ACCRUAL_CODE INVENTORY_ACCRUAL_CODE
, ORDER_TYPE_ID ORDER_TYPE_ID
, ORDER_SOURCE_ID ORDER_SOURCE_ID
, SALESREP_ID SALESREP_ID
, TERM_ID TERM_ID
, ORG_ID ORG_ID
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, TAX_FROM_SHIP_TO_LOC_FLAG TAX_FROM_SHIP_TO_LOC_FLAG
, TAX_FROM_ITEM_FLAG TAX_FROM_ITEM_FLAG
, TAX_FROM_VENDOR_FLAG TAX_FROM_VENDOR_FLAG
, TAX_FROM_VENDOR_SITE_FLAG TAX_FROM_VENDOR_SITE_FLAG
, TAX_FROM_SYSTEM_FLAG TAX_FROM_SYSTEM_FLAG
, TAX_HIER_SHIP_TO_LOC TAX_HIER_SHIP_TO_LOC
, TAX_HIER_ITEM TAX_HIER_ITEM
, TAX_HIER_VENDOR TAX_HIER_VENDOR
, TAX_HIER_VENDOR_SITE TAX_HIER_VENDOR_SITE
, TAX_HIER_SYSTEM TAX_HIER_SYSTEM
, CREATE_DEBIT_MEMO_FLAG CREATE_DEBIT_MEMO_FLAG
, ENFORCE_PRICE_CHANGE_AMOUNT ENFORCE_PRICE_CHANGE_AMOUNT
, PRICE_CHANGE_AMOUNT PRICE_CHANGE_AMOUNT
, AUTO_OFFSET_METHOD AUTO_OFFSET_METHOD
, PO_OUTPUT_FORMAT PO_OUTPUT_FORMAT
, BUYING_COMPANY_IDENTIFIER BUYING_COMPANY_IDENTIFIER
, GAPLESS_INV_NUM_FLAG GAPLESS_INV_NUM_FLAG
, MAX_ATTACHMENT_SIZE MAX_ATTACHMENT_SIZE
, SUPPLIER_AUTHORING_ACCEPTANCE SUPPLIER_AUTHORING_ACCEPTANCE
, CAT_ADMIN_AUTHORING_ACCEPTANCE CAT_ADMIN_AUTHORING_ACCEPTANCE
, EMAIL_ATTACHMENT_FILENAME EMAIL_ATTACHMENT_FILENAME
, ACCEPTANCE_REQUIRED_FLAG ACCEPTANCE_REQUIRED_FLAG
, FUNDS_CHANGE_ALLOWANCE FUNDS_CHANGE_ALLOWANCE
, FUNDS_CHANGE_AMOUNT FUNDS_CHANGE_AMOUNT
, ENFORCE_FUNDS_CHANGE_ALLOWANCE ENFORCE_FUNDS_CHANGE_ALLOWANCE
, CONTR_OFFICE_AGENCY_ID CONTR_OFFICE_AGENCY_ID
, DEFAULT_DISTRIBUTIONS DEFAULT_DISTRIBUTIONS
, DOC_AMT_THRESHOLD DOC_AMT_THRESHOLD
, EDA_BATCH_SIZE EDA_BATCH_SIZE
, EDA_FILES_LOCATION EDA_FILES_LOCATION
, ENABLE_ACRN ENABLE_ACRN
, ENABLE_CDRL ENABLE_CDRL
, ENABLE_EDA ENABLE_EDA
, ENABLE_EPLS ENABLE_EPLS
, ENABLE_EXHIBITS_LINES ENABLE_EXHIBITS_LINES
, ENABLE_FPDS_REPORTING ENABLE_FPDS_REPORTING
, ENABLE_MIPR ENABLE_MIPR
, ENABLE_MIPR_ACCEPTANCE ENABLE_MIPR_ACCEPTANCE
, ENABLE_PAYMENT_INSTR ENABLE_PAYMENT_INSTR
, ENABLE_SMALL_BUS_COORD ENABLE_SMALL_BUS_COORD
, ENABLE_UNDEF_CONT_ACT ENABLE_UNDEF_CONT_ACT
, ENABLE_WDOL ENABLE_WDOL
, EPLS_TIMEFRAME EPLS_TIMEFRAME
, FPDSNG_AWD_MOD_XML_SOURCE FPDSNG_AWD_MOD_XML_SOURCE
, FPDSNG_AWD_XML_SOURCE FPDSNG_AWD_XML_SOURCE
, FPDSNG_IDV_MOD_XML_SOURCE FPDSNG_IDV_MOD_XML_SOURCE
, FPDSNG_IDV_XML_SOURCE FPDSNG_IDV_XML_SOURCE
, FPDS_AGENCY_ID FPDS_AGENCY_ID
, FPDS_APPROV_NOTIF_TYPE FPDS_APPROV_NOTIF_TYPE
, KO_SIGNATURE_REQD KO_SIGNATURE_REQD
, WDOL_URL WDOL_URL
, GROUP_SHIPMENTS_FLAG GROUP_SHIPMENTS_FLAG
FROM "PO"."PO_SYSTEM_PARAMETERS_ALL"