VIEW: PO.RCV_PARAMETERS#

Source

View Text - Preformatted

select ORGANIZATION_ID ORGANIZATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_LOGIN LAST_UPDATED_LOGIN, QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE, QTY_RCV_EXCEPTION_CODE QTY_RCV_EXCEPTION_CODE, ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE, ALLOW_EXPRESS_DELIVERY_FLAG ALLOW_EXPRESS_DELIVERY_FLAG, DAYS_EARLY_RECEIPT_ALLOWED DAYS_EARLY_RECEIPT_ALLOWED, DAYS_LATE_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED, RECEIPT_DAYS_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE, RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID, ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG, ALLOW_UNORDERED_RECEIPTS_FLAG ALLOW_UNORDERED_RECEIPTS_FLAG, BLIND_RECEIVING_FLAG BLIND_RECEIVING_FLAG, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, RECEIVING_ACCOUNT_ID RECEIVING_ACCOUNT_ID, ALLOW_CASCADE_TRANSACTIONS ALLOW_CASCADE_TRANSACTIONS, 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, RECEIPT_ASN_EXISTS_CODE RECEIPT_ASN_EXISTS_CODE, USER_DEFINED_RECEIPT_NUM_CODE USER_DEFINED_RECEIPT_NUM_CODE, MANUAL_RECEIPT_NUM_TYPE MANUAL_RECEIPT_NUM_TYPE, NEXT_RECEIPT_NUM NEXT_RECEIPT_NUM, CLEARING_ACCOUNT_ID CLEARING_ACCOUNT_ID, RETROPRICE_ADJ_ACCOUNT_ID RETROPRICE_ADJ_ACCOUNT_ID, ENFORCE_RMA_SERIAL_NUM ENFORCE_RMA_SERIAL_NUM, RMA_RECEIPT_ROUTING_ID RMA_RECEIPT_ROUTING_ID, ENFORCE_RMA_LOT_NUM ENFORCE_RMA_LOT_NUM, ADVANCED_PRICING ADVANCED_PRICING, TRANSPORTATION_EXECUTION TRANSPORTATION_EXECUTION, PRE_RECEIVE PRE_RECEIVE, LCM_ACCOUNT_ID LCM_ACCOUNT_ID, INV_VARIANCE_ACCOUNT_ID INV_VARIANCE_ACCOUNT_ID, EXCHANGE_VARIANCE_ACCOUNT_ID EXCHANGE_VARIANCE_ACCOUNT_ID, TAX_VARIANCE_ACCOUNT_ID TAX_VARIANCE_ACCOUNT_ID, DEF_CHARGES_ACCOUNT_ID DEF_CHARGES_ACCOUNT_ID from "PO"."RCV_PARAMETERS"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_LOGIN LAST_UPDATED_LOGIN
, QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE
, QTY_RCV_EXCEPTION_CODE QTY_RCV_EXCEPTION_CODE
, ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE
, ALLOW_EXPRESS_DELIVERY_FLAG ALLOW_EXPRESS_DELIVERY_FLAG
, DAYS_EARLY_RECEIPT_ALLOWED DAYS_EARLY_RECEIPT_ALLOWED
, DAYS_LATE_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED
, RECEIPT_DAYS_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE
, RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID
, ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, ALLOW_UNORDERED_RECEIPTS_FLAG ALLOW_UNORDERED_RECEIPTS_FLAG
, BLIND_RECEIVING_FLAG BLIND_RECEIVING_FLAG
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, RECEIVING_ACCOUNT_ID RECEIVING_ACCOUNT_ID
, ALLOW_CASCADE_TRANSACTIONS ALLOW_CASCADE_TRANSACTIONS
, 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
, RECEIPT_ASN_EXISTS_CODE RECEIPT_ASN_EXISTS_CODE
, USER_DEFINED_RECEIPT_NUM_CODE USER_DEFINED_RECEIPT_NUM_CODE
, MANUAL_RECEIPT_NUM_TYPE MANUAL_RECEIPT_NUM_TYPE
, NEXT_RECEIPT_NUM NEXT_RECEIPT_NUM
, CLEARING_ACCOUNT_ID CLEARING_ACCOUNT_ID
, RETROPRICE_ADJ_ACCOUNT_ID RETROPRICE_ADJ_ACCOUNT_ID
, ENFORCE_RMA_SERIAL_NUM ENFORCE_RMA_SERIAL_NUM
, RMA_RECEIPT_ROUTING_ID RMA_RECEIPT_ROUTING_ID
, ENFORCE_RMA_LOT_NUM ENFORCE_RMA_LOT_NUM
, ADVANCED_PRICING ADVANCED_PRICING
, TRANSPORTATION_EXECUTION TRANSPORTATION_EXECUTION
, PRE_RECEIVE PRE_RECEIVE
, LCM_ACCOUNT_ID LCM_ACCOUNT_ID
, INV_VARIANCE_ACCOUNT_ID INV_VARIANCE_ACCOUNT_ID
, EXCHANGE_VARIANCE_ACCOUNT_ID EXCHANGE_VARIANCE_ACCOUNT_ID
, TAX_VARIANCE_ACCOUNT_ID TAX_VARIANCE_ACCOUNT_ID
, DEF_CHARGES_ACCOUNT_ID DEF_CHARGES_ACCOUNT_ID
FROM "PO"."RCV_PARAMETERS"