DBA Data[Home] [Help]

VIEW: APPS.PABV_INVOICE_LINES

Source

View Text - Preformatted

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
View Text - HTML Formatted

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