oracle视图使用引号,11.5.10 里面的一个视图, 为什么SELECT 字段都" "用双引号?

/* Formatted on 2007/02/26 13:34 (Formatter Plus v4.8.7) */

CREATE OR REPLACE VIEW ap_invoice_distributions (prepay_distribution_id,

accounting_event_id,

accounting_date,

accrual_posted_flag,

assets_addition_flag,

assets_tracking_flag,

cash_posted_flag,

distribution_line_number,

dist_code_combination_id,

invoice_id,

last_updated_by,

last_update_date,

line_type_lookup_code,

period_name,

set_of_books_id,

accts_pay_code_combination_id,

amount,

base_amount,

base_invoice_price_variance,

batch_id,

created_by,

creation_date,

description,

exchange_rate_variance,

final_match_flag,

income_tax_region,

invoice_price_variance,

last_update_login,

match_status_flag,

posted_flag,

po_distribution_id,

program_application_id,

program_id,

program_update_date,

quantity_invoiced,

rate_var_code_combination_id,

request_id,

reversal_flag,

type_1099,

unit_price,

vat_code,

amount_encumbered,

base_amount_encumbered,

encumbered_flag,

exchange_date,

exchange_rate,

exchange_rate_type,

price_adjustment_flag,

price_var_code_combination_id,

quantity_unencumbered,

stat_amount,

amount_to_post,

attribute1,

attribute10,

attribute11,

attribute12,

attribute13,

attribute14,

attribute15,

attribute2,

attribute3,

attribute4,

attribute5,

attribute6,

attribute7,

attribute8,

attribute9,

attribute_category,

base_amount_to_post,

cash_je_batch_id,

expenditure_item_date,

expenditure_organization_id,

expenditure_type,

je_batch_id,

parent_invoice_id,

pa_addition_flag,

pa_quantity,

posted_amount,

posted_base_amount,

prepay_amount_remaining,

project_accounting_context,

project_id,

task_id,

ussgl_transaction_code,

ussgl_trx_code_context,

earliest_settlement_date,

req_distribution_id,

quantity_variance,

base_quantity_variance,

packet_id,

awt_flag,

awt_group_id,

awt_tax_rate_id,

awt_gross_amount,

awt_invoice_id,

awt_origin_group_id,

reference_1,

reference_2,

org_id,

other_invoice_id,

awt_invoice_payment_id,

global_attribute_category,

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,

amount_includes_tax_flag,

tax_calculated_flag,

line_group_number,

receipt_verified_flag,

receipt_required_flag,

receipt_missing_flag,

justification,

expense_group,

start_expense_date,

end_expense_date,

receipt_currency_code,

receipt_conversion_rate,

receipt_currency_amount,

daily_amount,

web_parameter_id,

adjustment_reason,

award_id,

mrc_dist_code_combination_id,

mrc_base_amount,

mrc_base_inv_price_variance,

mrc_exchange_rate_variance,

mrc_rate_var_ccid,

mrc_exchange_date,

mrc_exchange_rate,

mrc_exchange_rate_type,

mrc_receipt_conversion_rate,

dist_match_type,

rcv_transaction_id,

invoice_distribution_id,

parent_reversal_id,

tax_recovery_rate,

tax_recovery_override_flag,

tax_recoverable_flag,

tax_code_override_flag,

tax_code_id,

pa_cc_ar_invoice_id,

pa_cc_ar_invoice_line_num,

pa_cc_processed_code,

merchant_document_number,

merchant_name,

merchant_reference,

merchant_tax_reg_number,

merchant_taxpayer_id,

country_of_supply,

matched_uom_lookup_code,

gms_burdenable_raw_cost,

credit_card_trx_id,

upgrade_posted_amt,

upgrade_base_posted_amt,

inventory_transfer_status,

company_prepaid_invoice_id,

cc_reversal_flag,

prepay_tax_parent_id,

awt_withheld_amt,

invoice_includes_prepay_flag,

price_correct_inv_id,

price_correct_qty,

pa_cmt_xface_flag,

cancellation_flag,

fully_paid_acctd_flag,

root_distribution_id,

xinv_parent_reversal_id,

amount_variance,

base_amount_variance,

recurring_payment_id

)

AS

SELECT "PREPAY_DISTRIBUTION_ID", "ACCOUNTING_EVENT_ID", "ACCOUNTING_DATE",

"ACCRUAL_POSTED_FLAG", "ASSETS_ADDITION_FLAG",

"ASSETS_TRACKING_FLAG", "CASH_POSTED_FLAG",

"DISTRIBUTION_LINE_NUMBER", "DIST_CODE_COMBINATION_ID",

"INVOICE_ID", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

"LINE_TYPE_LOOKUP_CODE", "PERIOD_NAME", "SET_OF_BOOKS_ID",

"ACCTS_PAY_CODE_COMBINATION_ID", "AMOUNT", "BASE_AMOUNT",

"BASE_INVOICE_PRICE_VARIANCE", "BATCH_ID", "CREATED_BY",

"CREATION_DATE", "DESCRIPTION", "EXCHANGE_RATE_VARIANCE",

"FINAL_MATCH_FLAG", "INCOME_TAX_REGION", "INVOICE_PRICE_VARIANCE",

"LAST_UPDATE_LOGIN", "MATCH_STATUS_FLAG", "POSTED_FLAG",

"PO_DISTRIBUTION_ID", "PROGRAM_APPLICATION_ID", "PROGRAM_ID",

"PROGRAM_UPDATE_DATE", "QUANTITY_INVOICED",

"RATE_VAR_CODE_COMBINATION_ID", "REQUEST_ID", "REVERSAL_FLAG",

"TYPE_1099", "UNIT_PRICE", "VAT_CODE", "AMOUNT_ENCUMBERED",

"BASE_AMOUNT_ENCUMBERED", "ENCUMBERED_FLAG", "EXCHANGE_DATE",

"EXCHANGE_RATE", "EXCHANGE_RATE_TYPE", "PRICE_ADJUSTMENT_FLAG",

"PRICE_VAR_CODE_COMBINATION_ID", "QUANTITY_UNENCUMBERED",

"STAT_AMOUNT", "AMOUNT_TO_POST", "ATTRIBUTE1", "ATTRIBUTE10",

"ATTRIBUTE11", "ATTRIBUTE12", "ATTRIBUTE13", "ATTRIBUTE14",

"ATTRIBUTE15", "ATTRIBUTE2", "ATTRIBUTE3", "ATTRIBUTE4",

"ATTRIBUTE5", "ATTRIBUTE6", "ATTRIBUTE7", "ATTRIBUTE8",

"ATTRIBUTE9", "ATTRIBUTE_CATEGORY", "BASE_AMOUNT_TO_POST",

"CASH_JE_BATCH_ID", "EXPENDITURE_ITEM_DATE",

"EXPENDITURE_ORGANIZATION_ID", "EXPENDITURE_TYPE", "JE_BATCH_ID",

"PARENT_INVOICE_ID", "PA_ADDITION_FLAG", "PA_QUANTITY",

"POSTED_AMOUNT", "POSTED_BASE_AMOUNT", "PREPAY_AMOUNT_REMAINING",

"PROJECT_ACCOUNTING_CONTEXT", "PROJECT_ID", "TASK_ID",

"USSGL_TRANSACTION_CODE", "USSGL_TRX_CODE_CONTEXT",

"EARLIEST_SETTLEMENT_DATE", "REQ_DISTRIBUTION_ID",

"QUANTITY_VARIANCE", "BASE_QUANTITY_VARIANCE", "PACKET_ID",

"AWT_FLAG", "AWT_GROUP_ID", "AWT_TAX_RATE_ID", "AWT_GROSS_AMOUNT",

"AWT_INVOICE_ID", "AWT_ORIGIN_GROUP_ID", "REFERENCE_1",

"REFERENCE_2", "ORG_ID", "OTHER_INVOICE_ID",

"AWT_INVOICE_PAYMENT_ID", "GLOBAL_ATTRIBUTE_CATEGORY",

"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",

"AMOUNT_INCLUDES_TAX_FLAG", "TAX_CALCULATED_FLAG",

"LINE_GROUP_NUMBER", "RECEIPT_VERIFIED_FLAG",

"RECEIPT_REQUIRED_FLAG", "RECEIPT_MISSING_FLAG", "JUSTIFICATION",

"EXPENSE_GROUP", "START_EXPENSE_DATE", "END_EXPENSE_DATE",

"RECEIPT_CURRENCY_CODE", "RECEIPT_CONVERSION_RATE",

"RECEIPT_CURRENCY_AMOUNT", "DAILY_AMOUNT", "WEB_PARAMETER_ID",

"ADJUSTMENT_REASON", "AWARD_ID", "MRC_DIST_CODE_COMBINATION_ID",

"MRC_BASE_AMOUNT", "MRC_BASE_INV_PRICE_VARIANCE",

"MRC_EXCHANGE_RATE_VARIANCE", "MRC_RATE_VAR_CCID",

"MRC_EXCHANGE_DATE", "MRC_EXCHANGE_RATE", "MRC_EXCHANGE_RATE_TYPE",

"MRC_RECEIPT_CONVERSION_RATE", "DIST_MATCH_TYPE",

"RCV_TRANSACTION_ID", "INVOICE_DISTRIBUTION_ID",

"PARENT_REVERSAL_ID", "TAX_RECOVERY_RATE",

"TAX_RECOVERY_OVERRIDE_FLAG", "TAX_RECOVERABLE_FLAG",

"TAX_CODE_OVERRIDE_FLAG", "TAX_CODE_ID", "PA_CC_AR_INVOICE_ID",

"PA_CC_AR_INVOICE_LINE_NUM", "PA_CC_PROCESSED_CODE",

"MERCHANT_DOCUMENT_NUMBER", "MERCHANT_NAME", "MERCHANT_REFERENCE",

"MERCHANT_TAX_REG_NUMBER", "MERCHANT_TAXPAYER_ID",

"COUNTRY_OF_SUPPLY", "MATCHED_UOM_LOOKUP_CODE",

"GMS_BURDENABLE_RAW_COST", "CREDIT_CARD_TRX_ID",

"UPGRADE_POSTED_AMT", "UPGRADE_BASE_POSTED_AMT",

"INVENTORY_TRANSFER_STATUS", "COMPANY_PREPAID_INVOICE_ID",

"CC_REVERSAL_FLAG", "PREPAY_TAX_PARENT_ID", "AWT_WITHHELD_AMT",

"INVOICE_INCLUDES_PREPAY_FLAG", "PRICE_CORRECT_INV_ID",

"PRICE_CORRECT_QTY", "PA_CMT_XFACE_FLAG", "CANCELLATION_FLAG",

"FULLY_PAID_ACCTD_FLAG", "ROOT_DISTRIBUTION_ID",

"XINV_PARENT_REVERSAL_ID", "AMOUNT_VARIANCE",

"BASE_AMOUNT_VARIANCE", "RECURRING_PAYMENT_ID"

FROM ap_invoice_distributions_all

WHERE NVL (org_id,

NVL (TO_NUMBER (DECODE (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 1),

' ', NULL,

SUBSTRB (USERENV ('CLIENT_INFO'), 1,

10)

)

),

-99

)

) =

NVL (TO_NUMBER (DECODE (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 1),

' ', NULL,

SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10)

)

),

-99

)

/