[Home] [Help]
[Dependency Information]
Object Name: | AP_INVOICE_KEY_IND_ALL# |
---|---|
Object Type: | VIEW |
Owner: | AP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_NAME | VARCHAR2 | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
NUM_INVOICES | NUMBER | |||
AMOUNT_INVOICES | NUMBER | |||
NUM_DISTRIBUTION_LINES | NUMBER | |||
NUM_BATCHES | NUMBER | |||
NUM_INVOICE_VARIANCES | NUMBER | |||
AMOUNT_INVOICE_VARIANCES | NUMBER | |||
NUM_PAYMENT_SCHEDULES | NUMBER | |||
NUM_INVOICES_HELD | NUMBER | |||
AMOUNT_INVOICES_HELD | NUMBER | |||
NUM_INVOICES_MATCHED | NUMBER | |||
AMOUNT_INVOICES_MATCHED | NUMBER | |||
NUM_INVOICES_MATCH_HOLD | NUMBER | |||
AMOUNT_INVOICES_MATCH_HOLD | NUMBER | |||
VALUE1 | NUMBER | |||
VALUE2 | NUMBER | |||
VALUE3 | NUMBER | |||
VALUE4 | NUMBER | |||
VALUE5 | NUMBER | |||
VALUE6 | NUMBER | |||
VALUE7 | NUMBER | |||
VALUE8 | NUMBER | |||
VALUE9 | NUMBER | |||
VALUE10 | NUMBER | |||
NUM_EXPENSE_REPORTS | NUMBER | |||
AMOUNT_EXPENSE_REPORTS | NUMBER | |||
NUM_PREPAYMENTS | NUMBER | |||
AMOUNT_PREPAYMENTS | NUMBER | |||
NUM_RECURRING_PAYMENTS | NUMBER | |||
AMOUNT_RECURRING_PAYMENTS | NUMBER | |||
NUM_RECURRING_PAYMENTS_DEF | NUMBER | |||
ORG_ID | NUMBER | (15) | ||
NUM_INVOICE_LINES | NUMBER | |||
NUM_DISTRIBUTIONS | NUMBER | |||
NUM_INVOICE_LINE_VARIANCES | NUMBER | |||
AMOUNT_INVOICE_LINE_VARIANCES | NUMBER | |||
NUM_INVOICE_DIST_VARIANCES | NUMBER | |||
AMOUNT_INVOICE_DIST_VARIANCES | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, NUM_INVOICES
, AMOUNT_INVOICES
, NUM_DISTRIBUTION_LINES
, NUM_BATCHES
, NUM_INVOICE_VARIANCES
, AMOUNT_INVOICE_VARIANCES
, NUM_PAYMENT_SCHEDULES
, NUM_INVOICES_HELD
, AMOUNT_INVOICES_HELD
, NUM_INVOICES_MATCHED
, AMOUNT_INVOICES_MATCHED
, NUM_INVOICES_MATCH_HOLD
, AMOUNT_INVOICES_MATCH_HOLD
, VALUE1
, VALUE2
, VALUE3
, VALUE4
, VALUE5
, VALUE6
, VALUE7
, VALUE8
, VALUE9
, VALUE10
, NUM_EXPENSE_REPORTS
, AMOUNT_EXPENSE_REPORTS
, NUM_PREPAYMENTS
, AMOUNT_PREPAYMENTS
, NUM_RECURRING_PAYMENTS
, AMOUNT_RECURRING_PAYMENTS
, NUM_RECURRING_PAYMENTS_DEF
, ORG_ID
, NUM_INVOICE_LINES
, NUM_DISTRIBUTIONS
, NUM_INVOICE_LINE_VARIANCES
, AMOUNT_INVOICE_LINE_VARIANCES
, NUM_INVOICE_DIST_VARIANCES
, AMOUNT_INVOICE_DIST_VARIANCES
FROM AP.AP_INVOICE_KEY_IND_ALL#;
|
|
|