View: PAFV_INVOICE_LINES

Product:	PA - Projects
Description:	Business view to show information about the lines of a draft invoice.
Implementation/DBA Data:	APPS.PAFV_INVOICE_LINES

View Text

SELECT PDIA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PDIA.DRAFT_INVOICE_NUM
, PDII.LINE_NUM
, '_LA:INVOICE_LINE_TYPE:PA_LOOKUPS:INVOICE LINE TYPE:MEANING'
, PPA.PROJECT_CURRENCY_CODE
, PDII.AMOUNT
, PDIA.INV_CURRENCY_CODE
, PDIA.INV_RATE_TYPE
, INV.USER_CONVERSION_TYPE
, PDIA.INV_RATE_DATE
, PDIA.INV_EXCHANGE_RATE
, PDII.INV_AMOUNT
, PDIA.ACCTD_CURR_CODE
, PDIA.ACCTD_RATE_TYPE
, ACCT.USER_CONVERSION_TYPE
, PDIA.ACCTD_RATE_DATE
, PDIA.ACCTD_EXCHG_RATE
, PDII.ACCT_AMOUNT
, PDII.TEXT
, PDIA.SYSTEM_REFERENCE
, '_LA:TAXABLE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PDII.EVENT_NUM
, PDII.EVENT_TASK_ID
, PDII.TASK_ID
, PA.TASK_NAME
, PA.TASK_NUMBER
, PDII.LAST_UPDATE_DATE
, PDII.LAST_UPDATED_BY
, PDII.CREATION_DATE
, PDII.CREATED_BY
, PDIA.DRAFT_INVOICE_NUM_CREDITED
FROM PA_DRAFT_INVOICE_ITEMS PDII
, PA_DRAFT_INVOICES_ALL PDIA
, PA_TASKS PA
, PA_PROJECTS_ALL PPA
, PA_CONVERSION_TYPES_V INV
, PA_CONVERSION_TYPES_V ACCT
WHERE PDII.PROJECT_ID = PDIA.PROJECT_ID
AND PDII.DRAFT_INVOICE_NUM = PDIA.DRAFT_INVOICE_NUM
AND PDII.PROJECT_ID = PPA.PROJECT_ID
AND PDII.TASK_ID = PA.TASK_ID(+)
AND PDIA.INV_RATE_TYPE = INV.CONVERSION_TYPE (+)
AND PDIA.ACCTD_RATE_TYPE = ACCT.CONVERSION_TYPE (+)
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns