oracle erp 10.7 设置,请教一个简单的问题about Oracle application10.7 Ap

我在AP application 输入invoice num去查询有数据显示。

然后，我想知道这些数据来自数据库的那个表。help----about this  record.

显示table_name ap_invoices_v

--查看view 定义

select * from dba_views

where  view_name = 'AP_INVOICES_V'

执行   select * from ap_invoices_v

为什么没有数据？？？？

/* Formatted on 2005/02/22 14:04 (Formatter Plus v4.7.0) */

SELECT ai.ROWID row_id,

ai.accts_pay_code_combination_id accts_pay_code_combination_id,

ai.amount_applicable_to_discount amount_applicable_to_discount,

ai.amount_paid amount_paid,

ai.approval_description approval_description,

ai.approved_amount approved_amount, ai.attribute1 attribute1,

ai.attribute10 attribute10, ai.attribute11 attribute11,

ai.attribute12 attribute12, ai.attribute13 attribute13,

ai.attribute14 attribute14, ai.attribute15 attribute15,

ai.attribute2 attribute2, ai.attribute3 attribute3,

ai.attribute4 attribute4, ai.attribute5 attribute5,

ai.attribute6 attribute6, ai.attribute7 attribute7,

ai.attribute8 attribute8, ai.attribute9 attribute9,

ai.attribute_category attribute_category,

ai.authorized_by authorized_by, ai.awt_flag awt_flag,

ai.awt_group_id awt_group_id, ai.base_amount base_amount,

ai.batch_id batch_id, ai.cancelled_amount cancelled_amount,

ai.cancelled_by cancelled_by, ai.cancelled_date cancelled_date,

ai.created_by created_by, ai.creation_date creation_date,

ai.description description,

ai.discount_amount_taken discount_amount_taken,

ai.doc_category_code doc_category_code,

ai.doc_sequence_id doc_sequence_id,

ai.doc_sequence_value doc_sequence_value,

ai.earliest_settlement_date earliest_settlement_date,

ai.exchange_date exchange_date, ai.exchange_rate exchange_rate,

ai.exchange_rate_type exchange_rate_type,

ai.exclusive_payment_flag exclusive_payment_flag,

ai.expenditure_item_date expenditure_item_date,

ai.expenditure_organization_id expenditure_organization_id,

ai.expenditure_type expenditure_type, ai.freight_amount freight_amount,

ai.goods_received_date goods_received_date,

ai.invoice_amount invoice_amount,

ai.invoice_currency_code invoice_currency_code,

ai.invoice_date invoice_date, ai.invoice_id invoice_id,

ai.invoice_num invoice_num,

ai.invoice_received_date invoice_received_date,

ai.invoice_type_lookup_code invoice_type_lookup_code,

ai.last_updated_by last_updated_by,

ai.last_update_date last_update_date,

ai.last_update_login last_update_login,

ai.original_prepayment_amount original_prepayment_amount,

ai.payment_amount_total payment_amount_total,

ai.payment_cross_rate payment_cross_rate,

ai.payment_currency_code payment_currency_code,

ai.payment_method_lookup_code payment_method_lookup_code,

ai.payment_status_flag payment_status_flag,

ai.pay_group_lookup_code pay_group_lookup_code,

ai.pa_default_dist_ccid pa_default_dist_ccid,

ai.pa_quantity pa_quantity, ai.po_header_id po_header_id,

ai.prepay_flag prepay_flag,

ai.project_accounting_context project_accounting_context,

ai.project_id project_id, ai.recurring_payment_id recurring_payment_id,

ai.set_of_books_id set_of_books_id, ai.SOURCE SOURCE,

ai.task_id task_id, ai.tax_amount tax_amount,

ai.temp_cancelled_amount temp_cancelled_amount,

ai.terms_date terms_date, ai.terms_id terms_id,

ai.ussgl_transaction_code ussgl_transaction_code,

ai.ussgl_trx_code_context ussgl_trx_code_context, ai.vat_code vat_code,

atc.tax_type tax_type, atc.tax_rate tax_rate,

atc.description tax_description, ai.vendor_id vendor_id,

ai.vendor_prepay_amount vendor_prepay_amount,

ai.vendor_site_id vendor_site_id, ai.voucher_num voucher_num,

ab.batch_name batch_name, alc1.displayed_field invoice_type,

alc2.displayed_field payment_status,

alc3.displayed_field payment_method,

DECODE (ai.invoice_type_lookup_code,

'PREPAYMENT', DECODE (ai.earliest_settlement_date,

'', 'PERMANENT',

'TEMPORARY'

)

) prepayment_type_lookup_code,

gdct.user_conversion_type user_rate_type,

arp.recurring_pay_num recurring_pay_num,

arp.rec_pay_period_type recurring_period_type,

aopt.description recurring_payment_type,

DECODE (ai.invoice_type_lookup_code,

'PREPAYMENT', '',

AT.NAME

) terms_name,

DECODE (ai.invoice_type_lookup_code,

'PREPAYMENT', ai.original_prepayment_amount,

ai.invoice_amount

) actual_invoice_amount,

fds.NAME doc_sequence_name, fdsc.NAME doc_category_name,

gsob.NAME set_of_books_name, hou.NAME expenditure_organization_name,

pv.vendor_name vendor_name, pv.segment1 vendor_number,

pv.num_1099 num_1099, pvs.vendor_site_code vendor_site_code,

pvs.hold_future_payments_flag hold_future_payments_flag,

pvs.invoice_amount_limit invoice_amount_limit,

pvs.terms_date_basis terms_date_basis,

pvs.payment_priority payment_priority,

pvs.pay_date_basis_lookup_code pay_date_basis_lookup_code,

pvs.always_take_disc_flag always_take_disc_flag,

pvs.exclude_freight_from_discount exclude_freight_from_discount,

pvs.allow_awt_flag site_allow_awt_flag,

DECODE (pv.type_1099,

'', '',

DECODE (asp.combined_filing_flag,

'N', '',

DECODE (asp.income_tax_region_flag,

'Y', pvs.state,

asp.income_tax_region

)

)

) income_tax_region,

NVL (ap_invoices_pkg.get_distribution_total (ai.invoice_id),

0

) distribution_total,

ap_invoices_pkg.get_posting_status (ai.invoice_id) posting_flag,

ap_invoices_pkg.get_approval_status (ai.invoice_id,

ai.invoice_amount,

ai.payment_status_flag,

ai.invoice_type_lookup_code

) approval_status_lookup_code,

ap_invoices_pkg.get_po_number (ai.invoice_id) po_number,

ap_invoices_pkg.get_amount_withheld (ai.invoice_id) amount_withheld,

ap_invoices_pkg.get_notes_count (ai.invoice_id) notes_count,

ap_invoices_pkg.get_holds_count (ai.invoice_id) holds_count,

ap_invoices_pkg.get_amount_hold_flag (ai.invoice_id) amount_hold_flag,

ap_invoices_pkg.get_vendor_hold_flag (ai.invoice_id) vendor_hold_flag,

ap_invoices_pkg.get_total_prepays (ai.vendor_id) total_prepays,

ap_invoices_pkg.get_available_prepays (ai.vendor_id) available_prepays,

ap_invoices_pkg.get_encumbered_flag (ai.invoice_id) encumbered_flag,

ap_invoices_pkg.get_gl_date (ai.invoice_date,

ai.goods_received_date

) gl_date,

ap_invoices_pkg.get_period_name (ai.invoice_date,

ai.goods_received_date

) period_name,

ap_invoices_pkg.get_max_dist_line_num (ai.invoice_id

) highest_dist_line_num,

ap_invoices_pkg.selected_for_payment_flag (ai.invoice_id

) selected_for_payment_flag,

ap_invoices_pkg.get_unposted_void_payment (ai.invoice_id

) unposted_void_payment_flag,

ap_invoices_pkg.get_discount_pay_dists_flag (ai.invoice_id

) discount_pay_dists_flag,

ap_invoices_pkg.get_prepayments_applied_flag (ai.invoice_id

)

prepayments_applied_flag,

ap_invoices_pkg.get_payments_exist_flag (ai.invoice_id

) payments_exist_flag,

ap_invoices_pkg.get_packet_id (ai.invoice_id) query_packet_id,

DECODE (ai.invoice_type_lookup_code,

'PREPAYMENT', ap_invoices_pkg.get_prepay_amount_applied (ai.invoice_id

),

0

) prepay_amount_applied,

fnd_user_ap_pkg.get_user_name (ai.cancelled_by) cancelled_by_display,

ai.approval_status approval_status,

ai.invoice_distribution_total invoice_distribution_total,

ai.posting_status posting_status, ai.reference_1 reference_1,

ai.reference_2 reference_2, ai.org_id org_id, awt.NAME awt_group_name,

pap.segment1 project, pat.task_number task,

fc.minimum_accountable_unit minimum_accountable_unit,

fc.PRECISION PRECISION, NVL (pvs.ap_tax_rounding_rule, 'N'),

ai.auto_tax_calc_flag, NVL (pvs.auto_tax_calc_override, 'N'),

NVL (pvs.amount_includes_tax_flag, 'N'),

ai.global_attribute_category global_attribute_category,

ai.global_attribute1 global_attribute1,

ai.global_attribute2 global_attribute2,

ai.global_attribute3 global_attribute3,

ai.global_attribute4 global_attribute4,

ai.global_attribute5 global_attribute5,

ai.global_attribute6 global_attribute6,

ai.global_attribute7 global_attribute7,

ai.global_attribute8 global_attribute8,

ai.global_attribute9 global_attribute9,

ai.global_attribute10 global_attribute10,

ai.global_attribute11 global_attribute11,

ai.global_attribute12 global_attribute12,

ai.global_attribute13 global_attribute13,

ai.global_attribute14 global_attribute14,

ai.global_attribute15 global_attribute15,

ai.global_attribute16 global_attribute16,

ai.global_attribute17 global_attribute17,

ai.global_attribute18 global_attribute18,

ai.global_attribute19 global_attribute19,

ai.global_attribute20 global_attribute20, pv.type_1099

FROM ap_invoices ai,

ap_batches ab,

ap_lookup_codes alc1,

ap_lookup_codes alc2,

ap_lookup_codes alc3,

ap_other_period_types aopt,

ap_recurring_payments arp,

ap_tax_codes atc,

ap_terms AT,

ap_system_parameters asp,

fnd_currencies fc,

fnd_document_sequences fds,

fnd_doc_sequence_categories fdsc,

gl_sets_of_books gsob,

gl_daily_conversion_types gdct,

hr_organization_units hou,

po_vendors pv,

po_vendor_sites pvs,

ap_awt_groups awt,

pa_projects_all pap,

pa_tasks pat

WHERE ai.batch_id = ab.batch_id(+)

AND ai.recurring_payment_id = arp.recurring_payment_id(+)

AND arp.rec_pay_period_type = aopt.period_type(+)

AND aopt.module(+) = 'RECURRING PAYMENT'

AND ai.terms_id = AT.term_id(+)

AND alc1.lookup_type(+) = 'INVOICE TYPE'

AND alc1.lookup_code(+) = ai.invoice_type_lookup_code

AND alc2.lookup_type(+) = 'INVOICE PAYMENT STATUS'

AND alc2.lookup_code(+) = ai.payment_status_flag

AND alc3.lookup_type(+) = 'PAYMENT METHOD'

AND alc3.lookup_code(+) = ai.payment_method_lookup_code

AND ai.exchange_rate_type = gdct.conversion_type(+)

AND ai.doc_sequence_id = fds.doc_sequence_id(+)

AND fdsc.code(+) = ai.doc_category_code

AND fdsc.application_id(+) = 200

AND ai.set_of_books_id = gsob.set_of_books_id

AND ai.expenditure_organization_id = hou.organization_id(+)

AND ai.vendor_id = pv.vendor_id

AND ai.vendor_site_id = pvs.vendor_site_id

AND ai.project_id = pap.project_id(+)

AND ai.task_id = pat.task_id(+)

AND ai.awt_group_id = awt.GROUP_ID(+)

AND ai.vat_code = atc.NAME(+)

AND ai.invoice_currency_code = fc.currency_code(+)