VIEW: APPS.PA_PROJ_RELEASED_INVOICES_VIEW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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