[Home] [Help]
View: PA_DRAFT_INV_DTLS_ALL_MRC_V
| Product: | PA - Projects |
|---|
| Description: | Single-org, single currency view |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT MC.DRAFT_INVOICE_DETAIL_ID
, PA.EXPENDITURE_ITEM_ID
, PA.LINE_NUM
, MC.PROJECT_ID
, PA.DENOM_CURRENCY_CODE
, PA.DENOM_BILL_AMOUNT
, MC.ACCT_CURRENCY_CODE
, MC.BILL_AMOUNT
, MC.REQUEST_ID
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATE_LOGIN
, MC.ACCT_RATE_TYPE
, MC.ACCT_RATE_DATE
, MC.ACCT_EXCHANGE_RATE
, PA.CC_PROJECT_ID
, PA.CC_TAX_TASK_ID
, PA.ORG_ID
, PA.REV_CODE_COMBINATION_ID
, PA.DRAFT_INVOICE_NUM
, PA.DRAFT_INVOICE_LINE_NUM
, PA.OUTPUT_VAT_TAX_ID
, PA.OUTPUT_TAX_CLASSIFICATION_CODE
, PA.OUTPUT_TAX_EXEMPT_FLAG
, PA.OUTPUT_TAX_EXEMPT_REASON_CODE
, PA.OUTPUT_TAX_EXEMPT_NUMBER
, PA.LINE_NUM_REVERSED
, PA.DETAIL_ID_REVERSED
, PA.REVERSED_FLAG
, PA.PROJACCT_CURRENCY_CODE
, PA.PROJACCT_COST_AMOUNT
, PA.PROJACCT_BILL_AMOUNT
, PA.MARKUP_CALC_BASE_CODE
, PA.IND_COMPILED_SET_ID
, PA.RULE_PERCENTAGE
, PA.BILL_RATE
, PA.BILL_MARKUP_PERCENTAGE
, PA.BASE_AMOUNT
, PA.SCHEDULE_LINE_PERCENTAGE
, PA.ORIG_DRAFT_INVOICE_NUM
, PA.ORIG_DRAFT_INVOICE_LINE_NUM
, MC.INVOICED_FLAG
, MC.PROGRAM_APPLICATION_ID
, MC.PROGRAM_ID
, MC.PROGRAM_UPDATE_DATE
, /*CROSS PROJ*/ PA.PROJECT_TP_RATE_DATE
, PA.PROJECT_TP_RATE_TYPE
, PA.PROJECT_TP_EXCHANGE_RATE
, PA.TP_AMT_TYPE_CODE
, PA.PROJECT_TRANSFER_PRICE
, PA.PROJFUNC_TRANSFER_PRICE
, PA.PROJFUNC_TP_RATE_DATE
, PA.PROJFUNC_TP_RATE_TYPE
, PA.PROJFUNC_TP_EXCHANGE_RATE
, PA.PROJECT_TP_CURRENCY_CODE
, PA.PROJFUNC_TP_CURRENCY_CODE
FROM PA_DRAFT_INVOICE_DETAILS_ALL PA
, PA_MC_DRAFT_INV_DETAILS_ALL MC
WHERE MC.DRAFT_INVOICE_DETAIL_ID = PA.DRAFT_INVOICE_DETAIL_ID
AND MC.SET_OF_BOOKS_ID = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10) )
, -99)
Columns
| DRAFT_INVOICE_DETAIL_ID |
| EXPENDITURE_ITEM_ID |
| LINE_NUM |
| PROJECT_ID |
| DENOM_CURRENCY_CODE |
| DENOM_BILL_AMOUNT |
| ACCT_CURRENCY_CODE |
| BILL_AMOUNT |
| REQUEST_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_LOGIN |
| ACCT_RATE_TYPE |
| ACCT_RATE_DATE |
| ACCT_EXCHANGE_RATE |
| CC_PROJECT_ID |
| CC_TAX_TASK_ID |
| ORG_ID |
| REV_CODE_COMBINATION_ID |
| DRAFT_INVOICE_NUM |
| DRAFT_INVOICE_LINE_NUM |
| OUTPUT_VAT_TAX_ID |
| OUTPUT_TAX_CLASSIFICATION_CODE |
| OUTPUT_TAX_EXEMPT_FLAG |
| OUTPUT_TAX_EXEMPT_REASON_CODE |
| OUTPUT_TAX_EXEMPT_NUMBER |
| LINE_NUM_REVERSED |
| DETAIL_ID_REVERSED |
| REVERSED_FLAG |
| PROJACCT_CURRENCY_CODE |
| PROJACCT_COST_AMOUNT |
| PROJACCT_BILL_AMOUNT |
| MARKUP_CALC_BASE_CODE |
| IND_COMPILED_SET_ID |
| RULE_PERCENTAGE |
| BILL_RATE |
| BILL_MARKUP_PERCENTAGE |
| BASE_AMOUNT |
| SCHEDULE_LINE_PERCENTAGE |
| ORIG_DRAFT_INVOICE_NUM |
| ORIG_DRAFT_INVOICE_LINE_NUM |
| INVOICED_FLAG |
| PROGRAM_APPLICATION_ID |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |
| PROJECT_TP_RATE_DATE |
| PROJECT_TP_RATE_TYPE |
| PROJECT_TP_EXCHANGE_RATE |
| TP_AMT_TYPE_CODE |
| PROJECT_TRANSFER_PRICE |
| PROJFUNC_TRANSFER_PRICE |
| PROJFUNC_TP_RATE_DATE |
| PROJFUNC_TP_RATE_TYPE |
| PROJFUNC_TP_EXCHANGE_RATE |
| PROJECT_TP_CURRENCY_CODE |
| PROJFUNC_TP_CURRENCY_CODE |
| Name |