[Home] [Help]
[Dependency Information]
VIEW: APPS.PA_PWP_LINK_STATUS_V
Object Details
Object Name: | PA_PWP_LINK_STATUS_V |
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
PROJECT_ID |
NUMBER |
(15) |
|
Project Id |
DRAFT_INVOICE_NUM |
NUMBER |
(15) |
|
Draft invoice number |
INVOICE_COUNT |
NUMBER |
|
|
Number of supplier invoices linked to the draft invoice |
PFC_AMOUNT |
NUMBER |
|
|
Total amount on linked supplier invoices in project functional currency |
PC_AMOUNT |
NUMBER |
|
|
Total amount on linked supplier invoices in project currency |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, DRAFT_INVOICE_NUM
, INVOICE_COUNT
, PFC_AMOUNT
, PC_AMOUNT
FROM APPS.PA_PWP_LINK_STATUS_V;
Dependencies
[top of page]
APPS.PA_PWP_LINK_STATUS_V references the following:
-
APPS
-
AP_INVOICES
-
AP_INVOICE_DISTRIBUTIONS
-
PAAP_PWP_PKG
- show dependent code
-
PA_CUST_REV_DIST_LINES
-
PA_DRAFT_INVOICES
-
PA_DRAFT_INVOICE_ITEMS
-
PA_EXPENDITURE_ITEMS
-
PA_PWP_LINKED_INVOICES
APPS.PA_PWP_LINK_STATUS_V is referenced by following:
-
APPS
-
PA_PWP_CUSTOMER_INVOICE_V