[Home] [Help] [Dependency Information]
Object Name: | PA_EVENTS_MRC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_EVENTS_MRC_V |
Subobject Name: | |
Status: | VALID |
A multiple reporting currency view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
EVENT_ID | NUMBER | Yes | ||
PROJECT_ID | NUMBER | (15) | Yes | |
TASK_ID | NUMBER | (15) | ||
EVENT_NUM | NUMBER | (15) | Yes | |
REVENUE_AMOUNT | NUMBER | (22) | Yes | |
BILL_AMOUNT | NUMBER | (22) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
EVENT_TYPE | VARCHAR2 | (30) | Yes | |
DESCRIPTION | VARCHAR2 | (240) | ||
REVENUE_DISTRIBUTED_FLAG | VARCHAR2 | (1) | Yes | |
BILL_HOLD_FLAG | VARCHAR2 | (1) | ||
COMPLETION_DATE | DATE | |||
REV_DIST_REJECTION_CODE | VARCHAR2 | (30) | ||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ORGANIZATION_ID | NUMBER | (15) | Yes | |
BILLING_ASSIGNMENT_ID | NUMBER | (15) | ||
EVENT_NUM_REVERSED | NUMBER | (15) | ||
CALLING_PLACE | VARCHAR2 | (30) | ||
CALLING_PROCESS | VARCHAR2 | (30) | ||
AUDIT_COST_BUDGET_TYPE_CODE | VARCHAR2 | (30) | ||
AUDIT_REV_BUDGET_TYPE_CODE | VARCHAR2 | (30) | ||
AUDIT_AMOUNT1 | NUMBER | |||
AUDIT_AMOUNT2 | NUMBER | |||
AUDIT_AMOUNT3 | NUMBER | |||
AUDIT_AMOUNT4 | NUMBER | |||
AUDIT_AMOUNT5 | NUMBER | |||
AUDIT_AMOUNT6 | NUMBER | |||
AUDIT_AMOUNT7 | NUMBER | |||
AUDIT_AMOUNT8 | NUMBER | |||
AUDIT_AMOUNT9 | NUMBER | |||
AUDIT_AMOUNT10 | NUMBER | |||
INVENTORY_ORG_ID | NUMBER | (15) | ||
INVENTORY_ITEM_ID | NUMBER | (15) | ||
QUANTITY_BILLED | NUMBER | |||
UOM_CODE | VARCHAR2 | (3) | ||
UNIT_PRICE | NUMBER | |||
REFERENCE1 | VARCHAR2 | (240) | ||
REFERENCE2 | VARCHAR2 | (240) | ||
REFERENCE3 | VARCHAR2 | (240) | ||
REFERENCE4 | VARCHAR2 | (240) | ||
REFERENCE5 | VARCHAR2 | (240) | ||
REFERENCE6 | VARCHAR2 | (240) | ||
REFERENCE7 | VARCHAR2 | (240) | ||
REFERENCE8 | VARCHAR2 | (240) | ||
REFERENCE9 | VARCHAR2 | (240) | ||
REFERENCE10 | VARCHAR2 | (240) | ||
BILL_TRANS_CURRENCY_CODE | VARCHAR2 | (15) | ||
BILL_TRANS_BILL_AMOUNT | NUMBER | |||
BILL_TRANS_REV_AMOUNT | NUMBER | |||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (30) | ||
PROJFUNC_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_RATE_DATE | DATE | |||
PROJFUNC_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_REV_RATE_DATE | DATE | |||
PROJFUNC_REV_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_REVENUE_AMOUNT | NUMBER | |||
PROJFUNC_INV_RATE_DATE | DATE | |||
PROJFUNC_INV_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_BILL_AMOUNT | NUMBER | |||
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJECT_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_RATE_DATE | DATE | |||
PROJECT_EXCHANGE_RATE | NUMBER | |||
PROJECT_REV_RATE_DATE | DATE | |||
PROJECT_REV_EXCHANGE_RATE | NUMBER | |||
PROJECT_REVENUE_AMOUNT | NUMBER | |||
PROJECT_INV_RATE_DATE | DATE | |||
PROJECT_INV_EXCHANGE_RATE | NUMBER | |||
PROJECT_BILL_AMOUNT | NUMBER | |||
FUNDING_RATE_TYPE | VARCHAR2 | (30) | ||
FUNDING_RATE_DATE | DATE | |||
FUNDING_EXCHANGE_RATE | NUMBER | |||
REVPROC_CURRENCY_CODE | VARCHAR2 | (15) | ||
REVPROC_RATE_TYPE | VARCHAR2 | (30) | ||
REVPROC_RATE_DATE | DATE | |||
REVPROC_EXCHANGE_RATE | NUMBER | |||
INVPROC_CURRENCY_CODE | VARCHAR2 | (15) | ||
INVPROC_RATE_TYPE | VARCHAR2 | (30) | ||
INVPROC_RATE_DATE | DATE | |||
INVPROC_EXCHANGE_RATE | NUMBER | |||
INV_GEN_REJECTION_CODE | VARCHAR2 | (30) | ||
BILLED_FLAG | VARCHAR2 | (1) | ||
ADJUSTING_REVENUE_FLAG | VARCHAR2 | (1) | ||
ZERO_REVENUE_AMOUNT_FLAG | VARCHAR2 | (1) | ||
PROJECT_FUNDING_ID | NUMBER | (15) | ||
REVENUE_HOLD_FLAG | VARCHAR2 | (1) | ||
NON_UPDATEABLE_FLAG | VARCHAR2 | (1) | ||
AUDIT_COST_PLAN_TYPE_ID | NUMBER | (15) | ||
AUDIT_REV_PLAN_TYPE_ID | NUMBER | (15) | ||
PM_PRODUCT_CODE | VARCHAR2 | (30) | ||
PM_EVENT_REFERENCE | VARCHAR2 | (25) | ||
DELIVERABLE_ID | NUMBER | (15) | ||
ACTION_ID | NUMBER | (15) | ||
RECORD_VERSION_NUMBER | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS_ID
, EVENT_ID
, PROJECT_ID
, TASK_ID
, EVENT_NUM
, REVENUE_AMOUNT
, BILL_AMOUNT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, EVENT_TYPE
, DESCRIPTION
, REVENUE_DISTRIBUTED_FLAG
, BILL_HOLD_FLAG
, COMPLETION_DATE
, REV_DIST_REJECTION_CODE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ORGANIZATION_ID
, BILLING_ASSIGNMENT_ID
, EVENT_NUM_REVERSED
, CALLING_PLACE
, CALLING_PROCESS
, AUDIT_COST_BUDGET_TYPE_CODE
, AUDIT_REV_BUDGET_TYPE_CODE
, AUDIT_AMOUNT1
, AUDIT_AMOUNT2
, AUDIT_AMOUNT3
, AUDIT_AMOUNT4
, AUDIT_AMOUNT5
, AUDIT_AMOUNT6
, AUDIT_AMOUNT7
, AUDIT_AMOUNT8
, AUDIT_AMOUNT9
, AUDIT_AMOUNT10
, INVENTORY_ORG_ID
, INVENTORY_ITEM_ID
, QUANTITY_BILLED
, UOM_CODE
, UNIT_PRICE
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, REFERENCE6
, REFERENCE7
, REFERENCE8
, REFERENCE9
, REFERENCE10
, BILL_TRANS_CURRENCY_CODE
, BILL_TRANS_BILL_AMOUNT
, BILL_TRANS_REV_AMOUNT
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_RATE_TYPE
, PROJFUNC_RATE_DATE
, PROJFUNC_EXCHANGE_RATE
, PROJFUNC_REV_RATE_DATE
, PROJFUNC_REV_EXCHANGE_RATE
, PROJFUNC_REVENUE_AMOUNT
, PROJFUNC_INV_RATE_DATE
, PROJFUNC_INV_EXCHANGE_RATE
, PROJFUNC_BILL_AMOUNT
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_TYPE
, PROJECT_RATE_DATE
, PROJECT_EXCHANGE_RATE
, PROJECT_REV_RATE_DATE
, PROJECT_REV_EXCHANGE_RATE
, PROJECT_REVENUE_AMOUNT
, PROJECT_INV_RATE_DATE
, PROJECT_INV_EXCHANGE_RATE
, PROJECT_BILL_AMOUNT
, FUNDING_RATE_TYPE
, FUNDING_RATE_DATE
, FUNDING_EXCHANGE_RATE
, REVPROC_CURRENCY_CODE
, REVPROC_RATE_TYPE
, REVPROC_RATE_DATE
, REVPROC_EXCHANGE_RATE
, INVPROC_CURRENCY_CODE
, INVPROC_RATE_TYPE
, INVPROC_RATE_DATE
, INVPROC_EXCHANGE_RATE
, INV_GEN_REJECTION_CODE
, BILLED_FLAG
, ADJUSTING_REVENUE_FLAG
, ZERO_REVENUE_AMOUNT_FLAG
, PROJECT_FUNDING_ID
, REVENUE_HOLD_FLAG
, NON_UPDATEABLE_FLAG
, AUDIT_COST_PLAN_TYPE_ID
, AUDIT_REV_PLAN_TYPE_ID
, PM_PRODUCT_CODE
, PM_EVENT_REFERENCE
, DELIVERABLE_ID
, ACTION_ID
, RECORD_VERSION_NUMBER
FROM APPS.PA_EVENTS_MRC_V;
|
|
|