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

Product:	PA - Projects
Description:	Single currency view
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT MC.PROJECT_ID
, MC.DRAFT_INVOICE_NUM
, PADII.AMOUNT
, MC.UNBILLED_RECEIVABLE_DR
, MC.UNEARNED_REVENUE_CR
, PADII.LINE_NUM
, PADII.LAST_UPDATE_DATE
, PADII.LAST_UPDATED_BY
, PADII.CREATION_DATE
, PADII.CREATED_BY
, PADII.TEXT
, PADII.INVOICE_LINE_TYPE
, PADII.REQUEST_ID
, PADII.PROGRAM_APPLICATION_ID
, PADII.PROGRAM_ID
, PADII.PROGRAM_UPDATE_DATE
, PADII.TASK_ID
, PADII.EVENT_TASK_ID
, PADII.EVENT_NUM
, PADII.SHIP_TO_ADDRESS_ID
, PADII.TAXABLE_FLAG
, PADII.DRAFT_INV_LINE_NUM_CREDITED
, PADII.LAST_UPDATE_LOGIN
, PADII.INV_AMOUNT
, PADII.OUTPUT_VAT_TAX_ID
, PADII.OUTPUT_TAX_CLASSIFICATION_CODE
, PADII.OUTPUT_TAX_EXEMPT_FLAG
, PADII.OUTPUT_TAX_EXEMPT_REASON_CODE
, PADII.OUTPUT_TAX_EXEMPT_NUMBER
, PADII.ACCT_AMOUNT
, PADII.ROUNDING_AMOUNT
, PADII.UNBILLED_ROUNDING_AMOUNT_DR
, PADII.UNEARNED_ROUNDING_AMOUNT_CR
, PADII.TRANSLATED_TEXT
, PADII.CC_REV_CODE_COMBINATION_ID
, PADII.CC_PROJECT_ID
, PADII.CC_TAX_TASK_ID
, PADII.PROJECT_CURRENCY_CODE
, PADII.PROJECT_BILL_AMOUNT
, GLSOB.CURRENCY_CODE
, MC.AMOUNT
, PADII.FUNDING_CURRENCY_CODE
, PADII.FUNDING_BILL_AMOUNT
, PADII.INVPROC_CURRENCY_CODE
, PADII.FUNDING_RATE_TYPE
, PADII.FUNDING_RATE_DATE
, PADII.FUNDING_EXCHANGE_RATE
, PADII.BILL_TRANS_CURRENCY_CODE
, PADII.BILL_TRANS_BILL_AMOUNT
, PADII.RETN_BILLING_METHOD
, PADII.RETN_PERCENT_COMPLETE
, PADII.RETN_TOTAL_RETENTION
, PADII.RETN_BILLING_CYCLE_ID
, PADII.RETN_CLIENT_EXTENSION_FLAG
, PADII.RETN_BILLING_PERCENTAGE
, PADII.RETN_BILLING_AMOUNT
, PADII.RETENTION_RULE_ID
, PADII.RETAINED_AMOUNT
, PADII.RETN_DRAFT_INVOICE_NUM
, PADII.RETN_DRAFT_INVOICE_LINE_NUM
, PADII.CREDIT_AMOUNT
, PADII.CREDIT_PROCESS_FLAG
FROM PA_DRAFT_INVOICE_ITEMS PADII
, PA_MC_DRAFT_INV_ITEMS MC
, GL_SETS_OF_BOOKS GLSOB
WHERE PADII.PROJECT_ID = MC.PROJECT_ID
AND PADII.DRAFT_INVOICE_NUM = MC.DRAFT_INVOICE_NUM
AND MC.PRC_ASSIGNMENT_ID = -99
AND PADII.LINE_NUM = MC.LINE_NUM
AND MC.SET_OF_BOOKS_ID = GLSOB.SET_OF_BOOKS_ID
AND MC.SET_OF_BOOKS_ID = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10) )
, -99)

Columns

Name
PROJECT_ID
DRAFT_INVOICE_NUM
AMOUNT
UNBILLED_RECEIVABLE_DR
UNEARNED_REVENUE_CR
LINE_NUM
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
TEXT
INVOICE_LINE_TYPE
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
TASK_ID
EVENT_TASK_ID
EVENT_NUM
SHIP_TO_ADDRESS_ID
TAXABLE_FLAG
DRAFT_INV_LINE_NUM_CREDITED
LAST_UPDATE_LOGIN
INV_AMOUNT
OUTPUT_VAT_TAX_ID
OUTPUT_TAX_CLASSIFICATION_CODE
OUTPUT_TAX_EXEMPT_FLAG
OUTPUT_TAX_EXEMPT_REASON_CODE
OUTPUT_TAX_EXEMPT_NUMBER
ACCT_AMOUNT
ROUNDING_AMOUNT
UNBILLED_ROUNDING_AMOUNT_DR
UNEARNED_ROUNDING_AMOUNT_CR
TRANSLATED_TEXT
CC_REV_CODE_COMBINATION_ID
CC_PROJECT_ID
CC_TAX_TASK_ID
PROJECT_CURRENCY_CODE
PROJECT_BILL_AMOUNT
PROJFUNC_CURRENCY_CODE
PROJFUNC_BILL_AMOUNT
FUNDING_CURRENCY_CODE
FUNDING_BILL_AMOUNT
INVPROC_CURRENCY_CODE
FUNDING_RATE_TYPE
FUNDING_RATE_DATE
FUNDING_EXCHANGE_RATE
BILL_TRANS_CURRENCY_CODE
BILL_TRANS_BILL_AMOUNT
RETN_BILLING_METHOD
RETN_PERCENT_COMPLETE
RETN_TOTAL_RETENTION
RETN_BILLING_CYCLE_ID
RETN_CLIENT_EXTENSION_FLAG
RETN_BILLING_PERCENTAGE
RETN_BILLING_AMOUNT
RETENTION_RULE_ID
RETAINED_AMOUNT
RETN_DRAFT_INVOICE_NUM
RETN_DRAFT_INVOICE_LINE_NUM
CREDIT_AMOUNT
CREDIT_PROCESS_FLAG