DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PA_PWP_SUPPLIER_INV_SUMMARY_V

Object Details
Object Name: PA_PWP_SUPPLIER_INV_SUMMARY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_PWP_SUPPLIER_INV_SUMMARY_V
Subobject Name:
Status: VALID

[View Source]

Columns
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 VARCHAR2 (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 VARCHAR2 (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
PROJFUNC_RECOVERABLE_TAX NUMBER

Recoverable tax amount in project functional currency
PROJ_RECOVERABLE_TAX NUMBER

Recoverable tax amount in project currency
ACCT_RECOVERABLE_TAX NUMBER

Recoverable tax amount in functional currency
RECOVERABLE_TAX NUMBER

Recoverable tax amount in invoice currency
Query Text

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
,      PROJFUNC_RECOVERABLE_TAX
,      PROJ_RECOVERABLE_TAX
,      ACCT_RECOVERABLE_TAX
,      RECOVERABLE_TAX
FROM APPS.PA_PWP_SUPPLIER_INV_SUMMARY_V;

Dependencies

[top of page]

APPS.PA_PWP_SUPPLIER_INV_SUMMARY_V references the following:

SchemaAPPS
SynonymGL_PERIOD_STATUSES
SynonymPA_IMPLEMENTATIONS_ALL
SynonymPA_PROJECTS_ALL
SynonymPA_PWP_AP_INV_DTL
SynonymPA_PWP_AP_INV_HDR

APPS.PA_PWP_SUPPLIER_INV_SUMMARY_V is not referenced by any database object