View: PABV_CUSTOMER_INVOICES

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PABV_CUSTOMER_INVOICES

View Text

SELECT PPA.PROJECT_ID
, PDI.DRAFT_INVOICE_NUM
, PDI.APPROVED_DATE
, PDI.RELEASED_DATE
, PDI.INVOICE_DATE
, PDI.UNEARNED_REVENUE_CR
, PDI.UNBILLED_RECEIVABLE_DR
, '_LA:PDI.TRANSFER_STATUS_CODE:PA_LOOKUPS:TRANSFER STATUS:MEANING'
, '_LA:PDI.GENERATION_ERROR_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PDI.BILL_THROUGH_DATE
, PDI.INVOICE_COMMENT
, PDI.RA_INVOICE_NUMBER
, PDI.TRANSFERRED_DATE
, PDI.TRANSFER_REJECTION_REASON
, PDI.GL_DATE
, PL.MEANING
, '_DF:PA:PA_DRAFT_INVOICES_DESC_FLEX:PDI'
, PDI.AGREEMENT_ID
, PDI.APPROVED_BY_PERSON_ID
, PDI.RELEASED_BY_PERSON_ID
, PDI.SYSTEM_REFERENCE
, PDI.DRAFT_INVOICE_NUM_CREDITED
, PDI.ORG_ID
, PDI.LAST_UPDATE_DATE
, PDI.LAST_UPDATED_BY
, PDI.CREATION_DATE
, PDI.CREATED_BY
FROM PA_DRAFT_INVOICES_ALL PDI
, PA_PROJECTS_ALL PPA
, PA_DRAFT_INVOICES_ALL PDIC
, PA_LOOKUPS PL
WHERE PDI.PROJECT_ID = PPA.PROJECT_ID
AND PDIC.PROJECT_ID(+) = PDI.PROJECT_ID
AND PDIC.DRAFT_INVOICE_NUM (+) = PDI.DRAFT_INVOICE_NUM_CREDITED
AND PL.LOOKUP_TYPE = 'INVOICE_CLASS'
AND PL.LOOKUP_CODE = DECODE(PDIC.CANCELED_FLAG
, 'Y'
, 'CANCEL'
, DECODE(PDI.WRITE_OFF_FLAG
, 'Y'
, 'WRITE_OFF'
, DECODE(NVL(PDI.DRAFT_INVOICE_NUM_CREDITED
, 0)
, 0
, 'INVOICE'
, 'CREDIT_MEMO')))
AND '_SEC:PDI.ORG_ID' IS NOT NULL WITH READ ONLY

Columns