View: PAFV_CUSTOMER_INVOICES

Product:	PA - Projects
Description:	Business view to show information about the draft invoices generated by the projects.
Implementation/DBA Data:	APPS.PAFV_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
, RCT.TRX_NUMBER
, RCT.TRX_DATE
, '_DF:PA:PA_DRAFT_INVOICES_DESC_FLEX:PDI'
, PDI.AGREEMENT_ID
, PDI.APPROVED_BY_PERSON_ID
, PAP1.FULL_NAME
, PDI.RELEASED_BY_PERSON_ID
, PAP2.FULL_NAME
, PA.DESCRIPTION
, PDI.SYSTEM_REFERENCE
, PDI.DRAFT_INVOICE_NUM_CREDITED
, PDI.ORG_ID
, TL.NAME
, PDI.LAST_UPDATE_DATE
, PDI.LAST_UPDATED_BY
, PDI.CREATION_DATE
, PDI.CREATED_BY
FROM PA_DRAFT_INVOICES_ALL PDI
, PA_PROJECTS_ALL PPA
, RA_CUSTOMER_TRX_ALL RCT
, PA_AGREEMENTS_ALL PA
, PA_DRAFT_INVOICES_ALL PDIC
, PA_LOOKUPS PL
, PER_ALL_PEOPLE_F PAP1
, PER_ALL_PEOPLE_F PAP2
, HR_ALL_ORGANIZATION_UNITS HRO
, HR_ALL_ORGANIZATION_UNITS_TL TL
WHERE PDI.PROJECT_ID = PPA.PROJECT_ID
AND PDI.AGREEMENT_ID = PA.AGREEMENT_ID
AND PDI.SYSTEM_REFERENCE = RCT.CUSTOMER_TRX_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
AND PDI.APPROVED_BY_PERSON_ID=PAP1.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN PAP1.EFFECTIVE_START_DATE (+)
AND PAP1.EFFECTIVE_END_DATE (+)
AND PDI.RELEASED_BY_PERSON_ID=PAP2.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN PAP2.EFFECTIVE_START_DATE (+)
AND PAP2.EFFECTIVE_END_DATE (+)
AND PDI.ORG_ID=HRO.ORGANIZATION_ID (+)
AND PDI.ORG_ID=TL.ORGANIZATION_ID (+)
AND TL.LANGUAGE = USERENV('LANG') WITH READ ONLY

Columns