eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PA_PWP_SUPPLIER_INVOICE_V

Object Details

Object Name:	PA_PWP_SUPPLIER_INVOICE_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
INVOICE_ID	NUMBER	(15)	Invoice Id.
INVOICE_NUM	VARCHAR2	(50)	Supplier invoice number.
VENDOR_ID	NUMBER	(15)	Vendor Id.
SUPPLIER_NAME	VARCHAR2	(240)	Supplier name.
INVOICE_DATE	DATE		Invoice date
SUPPLIER_SITE	VARCHAR2	(15)	Supplier site code
PAYMENT_STATUS	VARCHAR2	(14)	Invoice payment status
PO_NUMBER	VARCHAR2	(2000)	Concatinated PO numbers are the PO numbers matched to the invoice
HOLD_REASON	VARCHAR2	(4000)	Concatinated hold reason
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	(15)	Denom currency.
PWP_HOLD_FLAG	VARCHAR2	(1)	Pay when paid hold flag
DLV_HOLD_FLAG	VARCHAR2	(1)	Deliverable hold flag
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_CURR_PER_INV	NUMBER		Invoice amount for the current period in project functional currency

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVOICE_ID
,      INVOICE_NUM
,      VENDOR_ID
,      SUPPLIER_NAME
,      INVOICE_DATE
,      SUPPLIER_SITE
,      PAYMENT_STATUS
,      PO_NUMBER
,      HOLD_REASON
,      PROJECT_ID
,      PROJFUNC_CURRENCY_CODE
,      PROJ_CURRENCY_CODE
,      INVOICE_CURRENCY
,      PWP_HOLD_FLAG
,      DLV_HOLD_FLAG
,      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_CURR_PER_INV
FROM APPS.PA_PWP_SUPPLIER_INVOICE_V;

Dependencies

[top of page]

APPS.PA_PWP_SUPPLIER_INVOICE_V references the following:

APPS: GL_PERIOD_STATUSES; PA_IMPLEMENTATIONS_ALL; PA_PROJECTS_ALL; PA_PWP_AP_INV_DTL; PA_PWP_AP_INV_HDR

APPS.PA_PWP_SUPPLIER_INVOICE_V is not referenced by any database object