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.

[Home] [Help]

View: PA_PROJ_RELEASED_INVOICES_VIEW

Product:	PA - Projects
Description:	Released invoices for projects
Implementation/DBA Data:	APPS.PA_PROJ_RELEASED_INVOICES_VIEW

View Text

SELECT INV.PROJECT_ID
, INV.DRAFT_INVOICE_NUM
, INV.RA_INVOICE_NUMBER
, INV.BILL_THROUGH_DATE
, INV.INVOICE_DATE
, INV.APPROVED_DATE
, INV.RELEASED_DATE
, INV.CREATION_DATE
, INV.GL_DATE
, INV.GL_PERIOD
, INV.INVOICE_COMMENT
, INV.TRANSFER_REJECTION_REASON
, INV.CUSTOMER_BILL_SPLIT
, INV.CUSTOMER_ID
, INV.CUSTOMER_NUMBER
, INV.CUSTOMER_NAME
, INV.AGREEMENT_ID
, INV.AGREEMENT_NUM
, INV.AGREEMENT_TYPE
, INV.TOTAL_INVOICE_AMOUNT
, INV.RETENTION_AMOUNT
, INV.INVOICE_AMOUNT
, INV.DRAFT_INVOICE_NUM_CREDITED
, INV.TRANSFER_STATUS_CODE
, INV.INVOICE_STATUS
, INV.PAYMENT_TERMS
, INV.CREDIT_INVOICE_TYPE
, INV.DAYS_AWAITING_APPROVAL
FROM PA_PROJ_INVOICES_VIEW INV
WHERE INV.RELEASED_DATE IS NOT NULL

Columns

Name
PROJECT_ID
DRAFT_INVOICE_NUM
RA_INVOICE_NUMBER
BILL_THROUGH_DATE
INVOICE_DATE
APPROVED_DATE
RELEASED_DATE
CREATION_DATE
GL_DATE
GL_PERIOD
INVOICE_COMMENT
TRANSFER_REJECTION_REASON
CUSTOMER_BILL_SPLIT
CUSTOMER_ID
CUSTOMER_NUMBER
CUSTOMER_NAME
AGREEMENT_ID
AGREEMENT_NUM
AGREEMENT_TYPE
TOTAL_INVOICE_AMOUNT
RETENTION_AMOUNT
INVOICE_AMOUNT
DRAFT_INVOICE_NUM_CREDITED
TRANSFER_STATUS_CODE
INVOICE_STATUS
PAYMENT_TERMS
CREDIT_INVOICE_TYPE
DAYS_AWAITING_APPROVAL