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: PABV_INVOICE_LINES

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

View Text

SELECT PDIA.PROJECT_ID
, 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.TASK_ID
, PDII.LAST_UPDATE_DATE
, PDII.LAST_UPDATED_BY
, PDII.CREATION_DATE
, PDII.CREATED_BY
FROM PA_DRAFT_INVOICE_ITEMS PDII
, PA_DRAFT_INVOICES_ALL PDIA
, 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 PPA.PROJECT_ID = PDIA.PROJECT_ID
AND PDIA.INV_RATE_TYPE = INV.CONVERSION_TYPE (+)
AND PDIA.ACCTD_RATE_TYPE = ACCT.CONVERSION_TYPE (+)
AND '_SEC:PDIA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
PROJECT_ID
DRAFT_INVOICE_NUMBER
LINE_NUMBER
"_LA:INVOICE_LINE_TYPE"
PROJECT_CURRENCY_CODE
AMOUNT
INV_CURRENCY_CODE
INV_RATE_TYPE
INV_RATE_USER_TYPE
INV_RATE_DATE
INV_EXCHANGE_RATE
INV_AMOUNT
ACCTD_CURRENCY_CODE
ACCTD_RATE_TYPE
ACCTD_RATE_USER_TYPE
ACCTD_RATE_DATE
ACCTD_EXCHG_RATE
ACCTD_AMOUNT
INVOICE_LINE_TEXT
SYSTEM_REFERENCE
"_LA:TAXABLE_FLAG"
EVENT_NUMBER
TASK_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY