[Home] [Help] [Dependency Information]
Object Name: | PA_PWP_SUPPLIER_INV_SUMMARY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VENDOR_ID | NUMBER | (15) | Vendor Id. | |
SUPPLIER_NUM | VARCHAR2 | (30) | Vendor number. | |
SUPPLIER_NAME | VARCHAR2 | (240) | Supplier name | |
SUPPLIER_SITE | CHAR | (0) | Supplier site code | |
PROJECT_ID | NUMBER | (15) | Project Id. | |
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | Project functional currency code | |
PROJ_CURRENCY_CODE | VARCHAR2 | (15) | Project currency code | |
INVOICE_CURRENCY | CHAR | (0) | Denom currency | |
PROJFUNC_INVOICE_AMOUNT | NUMBER | Invoice amount in project functional currency | ||
PROJFUNC_INV_PAID_AMOUNT | NUMBER | Paid invoice amount in project functional currency | ||
PROJFUNC_INV_UNPAID_AMOUNT | NUMBER | Unpaid invoice amount in project functional currency | ||
PROJFUNC_RETAINED_AMOUNT | NUMBER | Retained Amount in project functional currency | ||
PROJFUNC_DISCOUNT_AMOUNT | NUMBER | Discount amount in project functional currency | ||
PROJ_INVOICE_AMOUNT | NUMBER | Invoice amount in project currency | ||
PROJ_INV_PAID_AMOUNT | NUMBER | Paid invoice amount in project currency | ||
PROJ_INV_UNPAID_AMOUNT | NUMBER | Unpaid invoice amount in project currency | ||
PROJ_RETAINED_AMOUNT | NUMBER | Retained amount in project currency | ||
PROJ_DISCOUNT_AMOUNT | NUMBER | Discount amount in project currency | ||
INVOICE_AMOUNT | NUMBER | Invoice amount in denom currency | ||
AMOUNT_PAID | NUMBER | Paid invoice amount in denom currency | ||
AMOUNT_UNPAID | NUMBER | Unpaid invoice amount in denom currency | ||
RETAINED_AMOUNT | NUMBER | Retained amount in denom currency | ||
DISCOUNT_AMOUNT | NUMBER | Discount amount in denom currency | ||
PROJFUNC_INVAMT_ONHOLD | NUMBER | On hold invoice amount in the project functional currency | ||
PROJ_INVAMT_ONHOLD | NUMBER | On hold invoice amount in the project currency | ||
PROJFUNC_CURR_PER_INV | NUMBER | Invoice amount for the current period in project functional currency | ||
PROJFUNC_CURR_PER_PAY | NUMBER | Paid invoice amount for the current period in project functional currency | ||
PROJ_CURR_PER_INV | NUMBER | Invoice amount for the current period in project functional currency | ||
PROJ_CURR_PER_PAY | NUMBER | Paid invoice amount for the current period in project functional currency |
Cut, paste (and edit) the following text to query this object:
SELECT VENDOR_ID
, SUPPLIER_NUM
, SUPPLIER_NAME
, SUPPLIER_SITE
, PROJECT_ID
, PROJFUNC_CURRENCY_CODE
, PROJ_CURRENCY_CODE
, INVOICE_CURRENCY
, PROJFUNC_INVOICE_AMOUNT
, PROJFUNC_INV_PAID_AMOUNT
, PROJFUNC_INV_UNPAID_AMOUNT
, PROJFUNC_RETAINED_AMOUNT
, PROJFUNC_DISCOUNT_AMOUNT
, PROJ_INVOICE_AMOUNT
, PROJ_INV_PAID_AMOUNT
, PROJ_INV_UNPAID_AMOUNT
, PROJ_RETAINED_AMOUNT
, PROJ_DISCOUNT_AMOUNT
, INVOICE_AMOUNT
, AMOUNT_PAID
, AMOUNT_UNPAID
, RETAINED_AMOUNT
, DISCOUNT_AMOUNT
, PROJFUNC_INVAMT_ONHOLD
, PROJ_INVAMT_ONHOLD
, PROJFUNC_CURR_PER_INV
, PROJFUNC_CURR_PER_PAY
, PROJ_CURR_PER_INV
, PROJ_CURR_PER_PAY
FROM APPS.PA_PWP_SUPPLIER_INV_SUMMARY_V;
APPS.PA_PWP_SUPPLIER_INV_SUMMARY_V is not referenced by any database object
|
|
|