View: PA_EVENTS_FORMS_MRC_V

View Text

SELECT E.ROWID
, E.EVENT_ID
, E.PROJECT_ID
, P.SEGMENT1
, P.NAME
, E.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, E.EVENT_NUM
, E.EVENT_TYPE
, ET.EVENT_TYPE_CLASSIFICATION
, E.COMPLETION_DATE
, E.DESCRIPTION
, E.ORGANIZATION_ID
, O.NAME
, E.BILL_AMOUNT
, E.REVENUE_AMOUNT
, E.BILL_HOLD_FLAG
, E.REVENUE_DISTRIBUTED_FLAG
, P.PROJECT_LEVEL_FUNDING_FLAG
, E.ATTRIBUTE_CATEGORY
, E.ATTRIBUTE1
, E.ATTRIBUTE2
, E.ATTRIBUTE3
, E.ATTRIBUTE4
, E.ATTRIBUTE5
, E.ATTRIBUTE6
, E.ATTRIBUTE7
, E.ATTRIBUTE8
, E.ATTRIBUTE9
, E.ATTRIBUTE10
, E.INVENTORY_ORG_ID
, E.INVENTORY_ITEM_ID
, E.QUANTITY_BILLED
, E.UOM_CODE
, E.UNIT_PRICE
, E.REFERENCE1
, E.REFERENCE2
, E.REFERENCE3
, E.REFERENCE4
, E.REFERENCE5
, E.REFERENCE6
, E.REFERENCE7
, E.REFERENCE8
, E.REFERENCE9
, E.REFERENCE10
, E.LAST_UPDATE_DATE
, E.LAST_UPDATED_BY
, E.CREATION_DATE
, E.CREATED_BY
, E.LAST_UPDATE_LOGIN
, E.BILL_TRANS_CURRENCY_CODE
, E.BILL_TRANS_BILL_AMOUNT
, E.BILL_TRANS_REV_AMOUNT
, E.PROJECT_CURRENCY_CODE
, E.PROJECT_RATE_TYPE
, C.USER_CONVERSION_TYPE PROJECT_RATE_TYPE_NAME
, E.PROJECT_RATE_DATE
, E.PROJECT_EXCHANGE_RATE
, E.PROJECT_BILL_AMOUNT
, E.PROJECT_INV_EXCHANGE_RATE
, E.PROJECT_INV_RATE_DATE
, E.PROJECT_REVENUE_AMOUNT
, E.PROJECT_REV_EXCHANGE_RATE
, E.PROJECT_REV_RATE_DATE
, E.PROJFUNC_CURRENCY_CODE
, E.PROJFUNC_RATE_TYPE
, C1.USER_CONVERSION_TYPE PROJFUNC_RATE_TYPE_NAME
, E.PROJFUNC_RATE_DATE
, E.PROJFUNC_EXCHANGE_RATE
, E.PROJFUNC_BILL_AMOUNT
, E.PROJFUNC_INV_EXCHANGE_RATE
, E.PROJFUNC_INV_RATE_DATE
, E.PROJFUNC_REVENUE_AMOUNT
, E.PROJFUNC_REV_EXCHANGE_RATE
, E.PROJFUNC_REV_RATE_DATE
, E.FUNDING_RATE_TYPE
, C2.USER_CONVERSION_TYPE FUNDING_RATE_TYPE_NAME
, E.FUNDING_RATE_DATE
, E.FUNDING_EXCHANGE_RATE
, E.INVPROC_CURRENCY_CODE
, E.INVPROC_RATE_TYPE
, E.INVPROC_RATE_DATE
, E.INVPROC_EXCHANGE_RATE
, E.REVPROC_CURRENCY_CODE
, E.REVPROC_RATE_TYPE
, E.REVPROC_RATE_DATE
, E.REVPROC_EXCHANGE_RATE
, E.INV_GEN_REJECTION_CODE
, PL1.MEANING
, PL.MEANING
, P.PROJECT_CURRENCY_CODE
, P.PROJECT_BIL_RATE_DATE_CODE
, P.PROJECT_BIL_RATE_TYPE
, P.PROJECT_BIL_RATE_DATE
, P.PROJECT_BIL_EXCHANGE_RATE
, P.PROJFUNC_CURRENCY_CODE
, P.PROJFUNC_BIL_RATE_DATE_CODE
, P.PROJFUNC_BIL_RATE_TYPE
, P.PROJFUNC_BIL_RATE_DATE
, P.PROJFUNC_BIL_EXCHANGE_RATE
, P.FUNDING_RATE_DATE_CODE
, P.FUNDING_RATE_TYPE
, P.FUNDING_RATE_DATE
, P.FUNDING_EXCHANGE_RATE
, P.REVPROC_CURRENCY_CODE
, P.INVPROC_CURRENCY_TYPE
, P.MULTI_CURRENCY_BILLING_FLAG
, E.ADJUSTING_REVENUE_FLAG
, E.ZERO_REVENUE_AMOUNT_FLAG
, E.NON_UPDATEABLE_FLAG
, E.AUDIT_COST_PLAN_TYPE_ID
, E.AUDIT_REV_PLAN_TYPE_ID
, E.REVENUE_HOLD_FLAG
, MC.CURRENCY_CODE
, MC.RATE_TYPE
, C3.USER_CONVERSION_TYPE REP_PROJFUNC_RATE_TYPE_NAME
, E.PROJFUNC_RATE_DATE
, E.PROJFUNC_EXCHANGE_RATE
, MC.CONVERSION_DATE
, MC.EXCHANGE_RATE
, MC.REVENUE_AMOUNT
, MC.PROJFUNC_INV_RATE_DATE
, MC.PROJFUNC_INV_EXCHANGE_RATE
, MC.BILL_AMOUNT
, E.BILLED_FLAG
, E.PM_PRODUCT_CODE
, E.PM_EVENT_REFERENCE
, PL2.MEANING
, E.DELIVERABLE_ID
, E.ACTION_ID
, E.RECORD_VERSION_NUMBER
FROM PA_PROJECTS P
, PA_TASKS T
, HR_ALL_ORGANIZATION_UNITS_TL O
, PA_EVENTS E
, PA_EVENT_TYPES ET
, PA_CONVERSION_TYPES_V C
, PA_CONVERSION_TYPES_V C1
, PA_CONVERSION_TYPES_V C2
, PA_CONVERSION_TYPES_V C3
, PA_LOOKUPS PL
, PA_LOOKUPS PL1
, PA_MC_EVENTS MC
, PA_LOOKUPS PL2
WHERE O.ORGANIZATION_ID = E.ORGANIZATION_ID
AND P.PROJECT_ID = E.PROJECT_ID
AND T.TASK_ID = E.TASK_ID
AND 'Y' IN (SELECT PA_SECURITY.ALLOW_QUERY(E.PROJECT_ID)
FROM SYS.DUAL)
AND E.EVENT_TYPE = ET.EVENT_TYPE
AND E.PROJECT_RATE_TYPE = C.CONVERSION_TYPE(+)
AND E.PROJFUNC_RATE_TYPE = C1.CONVERSION_TYPE(+)
AND E.FUNDING_RATE_TYPE = C2.CONVERSION_TYPE(+)
AND MC.RATE_TYPE = C3.CONVERSION_TYPE(+)
AND E.REV_DIST_REJECTION_CODE = PL.LOOKUP_CODE(+)
AND PL.LOOKUP_TYPE(+) = 'REVENUE DIST REJECTION CODE'
AND E.INV_GEN_REJECTION_CODE = PL1.LOOKUP_CODE(+)
AND PL1.LOOKUP_TYPE(+) = 'REVENUE DIST REJECTION CODE'
AND E.TASK_ID IS NOT NULL
AND O.LANGUAGE = USERENV('LANG')
AND MC.EVENT_ID = E.EVENT_ID
AND MC.PRC_ASSIGNMENT_ID = -99
AND MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99)
AND PL2.LOOKUP_TYPE(+)='PM_PRODUCT_CODE'
AND PL2.LOOKUP_CODE(+)=E.PM_PRODUCT_CODE UNION ALL SELECT E.ROWID
, E.EVENT_ID
, E.PROJECT_ID
, P.SEGMENT1
, P.NAME
, E.TASK_ID
, NULL
, NULL
, E.EVENT_NUM
, E.EVENT_TYPE
, ET.EVENT_TYPE_CLASSIFICATION
, E.COMPLETION_DATE
, E.DESCRIPTION
, E.ORGANIZATION_ID
, O.NAME
, E.BILL_AMOUNT
, E.REVENUE_AMOUNT
, E.BILL_HOLD_FLAG
, E.REVENUE_DISTRIBUTED_FLAG
, P.PROJECT_LEVEL_FUNDING_FLAG
, E.ATTRIBUTE_CATEGORY
, E.ATTRIBUTE1
, E.ATTRIBUTE2
, E.ATTRIBUTE3
, E.ATTRIBUTE4
, E.ATTRIBUTE5
, E.ATTRIBUTE6
, E.ATTRIBUTE7
, E.ATTRIBUTE8
, E.ATTRIBUTE9
, E.ATTRIBUTE10
, E.INVENTORY_ORG_ID
, E.INVENTORY_ITEM_ID
, E.QUANTITY_BILLED
, E.UOM_CODE
, E.UNIT_PRICE
, E.REFERENCE1
, E.REFERENCE2
, E.REFERENCE3
, E.REFERENCE4
, E.REFERENCE5
, E.REFERENCE6
, E.REFERENCE7
, E.REFERENCE8
, E.REFERENCE9
, E.REFERENCE10
, E.LAST_UPDATE_DATE
, E.LAST_UPDATED_BY
, E.CREATION_DATE
, E.CREATED_BY
, E.LAST_UPDATE_LOGIN
, E.BILL_TRANS_CURRENCY_CODE
, E.BILL_TRANS_BILL_AMOUNT
, E.BILL_TRANS_REV_AMOUNT
, E.PROJECT_CURRENCY_CODE
, E.PROJECT_RATE_TYPE
, C.USER_CONVERSION_TYPE PROJECT_RATE_TYPE_NAME
, E.PROJECT_RATE_DATE
, E.PROJECT_EXCHANGE_RATE
, E.PROJECT_BILL_AMOUNT
, E.PROJECT_INV_EXCHANGE_RATE
, E.PROJECT_INV_RATE_DATE
, E.PROJECT_REVENUE_AMOUNT
, E.PROJECT_REV_EXCHANGE_RATE
, E.PROJECT_REV_RATE_DATE
, E.PROJFUNC_CURRENCY_CODE
, E.PROJFUNC_RATE_TYPE
, C1.USER_CONVERSION_TYPE PROJFUNC_RATE_TYPE_NAME
, E.PROJFUNC_RATE_DATE
, E.PROJFUNC_EXCHANGE_RATE
, E.PROJFUNC_BILL_AMOUNT
, E.PROJFUNC_INV_EXCHANGE_RATE
, E.PROJFUNC_INV_RATE_DATE
, E.PROJFUNC_REVENUE_AMOUNT
, E.PROJFUNC_REV_EXCHANGE_RATE
, E.PROJFUNC_REV_RATE_DATE
, E.FUNDING_RATE_TYPE
, C2.USER_CONVERSION_TYPE FUNDING_RATE_TYPE_NAME
, E.FUNDING_RATE_DATE
, E.FUNDING_EXCHANGE_RATE
, E.INVPROC_CURRENCY_CODE
, E.INVPROC_RATE_TYPE
, E.INVPROC_RATE_DATE
, E.INVPROC_EXCHANGE_RATE
, E.REVPROC_CURRENCY_CODE
, E.REVPROC_RATE_TYPE
, E.REVPROC_RATE_DATE
, E.REVPROC_EXCHANGE_RATE
, E.INV_GEN_REJECTION_CODE
, PL1.MEANING
, PL.MEANING
, P.PROJECT_CURRENCY_CODE
, P.PROJECT_BIL_RATE_DATE_CODE
, P.PROJECT_BIL_RATE_TYPE
, P.PROJECT_BIL_RATE_DATE
, P.PROJECT_BIL_EXCHANGE_RATE
, P.PROJFUNC_CURRENCY_CODE
, P.PROJFUNC_BIL_RATE_DATE_CODE
, P.PROJFUNC_BIL_RATE_TYPE
, P.PROJFUNC_BIL_RATE_DATE
, P.PROJFUNC_BIL_EXCHANGE_RATE
, P.FUNDING_RATE_DATE_CODE
, P.FUNDING_RATE_TYPE
, P.FUNDING_RATE_DATE
, P.FUNDING_EXCHANGE_RATE
, P.REVPROC_CURRENCY_CODE
, P.INVPROC_CURRENCY_TYPE
, P.MULTI_CURRENCY_BILLING_FLAG
, E.ADJUSTING_REVENUE_FLAG
, E.ZERO_REVENUE_AMOUNT_FLAG
, E.NON_UPDATEABLE_FLAG
, E.AUDIT_COST_PLAN_TYPE_ID
, E.AUDIT_REV_PLAN_TYPE_ID
, E.REVENUE_HOLD_FLAG
, MC.CURRENCY_CODE
, MC.RATE_TYPE
, C3.USER_CONVERSION_TYPE REP_PROJFUNC_RATE_TYPE_NAME
, E.PROJFUNC_RATE_DATE
, E.PROJFUNC_EXCHANGE_RATE
, MC.CONVERSION_DATE
, MC.EXCHANGE_RATE
, MC.REVENUE_AMOUNT
, MC.PROJFUNC_INV_RATE_DATE
, MC.PROJFUNC_INV_EXCHANGE_RATE
, MC.BILL_AMOUNT
, E.BILLED_FLAG
, E.PM_PRODUCT_CODE
, E.PM_EVENT_REFERENCE
, PL2.MEANING
, E.DELIVERABLE_ID
, E.ACTION_ID
, E.RECORD_VERSION_NUMBER
FROM PA_PROJECTS P
, HR_ALL_ORGANIZATION_UNITS_TL O
, PA_EVENTS E
, PA_EVENT_TYPES ET
, PA_CONVERSION_TYPES_V C
, PA_CONVERSION_TYPES_V C1
, PA_CONVERSION_TYPES_V C2
, PA_CONVERSION_TYPES_V C3
, PA_LOOKUPS PL
, PA_LOOKUPS PL1
, PA_MC_EVENTS MC
, PA_LOOKUPS PL2
WHERE O.ORGANIZATION_ID = E.ORGANIZATION_ID
AND O.LANGUAGE = USERENV('LANG')
AND P.PROJECT_ID = E.PROJECT_ID
AND 'Y' IN (SELECT PA_SECURITY.ALLOW_QUERY(E.PROJECT_ID)
FROM SYS.DUAL)
AND E.EVENT_TYPE = ET.EVENT_TYPE
AND E.PROJECT_RATE_TYPE = C.CONVERSION_TYPE(+)
AND E.PROJFUNC_RATE_TYPE = C1.CONVERSION_TYPE(+)
AND E.FUNDING_RATE_TYPE = C2.CONVERSION_TYPE(+)
AND MC.RATE_TYPE = C3.CONVERSION_TYPE(+)
AND E.REV_DIST_REJECTION_CODE = PL.LOOKUP_CODE(+)
AND PL.LOOKUP_TYPE(+) = 'REVENUE DIST REJECTION CODE'
AND E.INV_GEN_REJECTION_CODE = PL1.LOOKUP_CODE(+)
AND PL1.LOOKUP_TYPE(+) = 'REVENUE DIST REJECTION CODE'
AND E.TASK_ID IS NULL
AND MC.EVENT_ID = E.EVENT_ID
AND MC.PRC_ASSIGNMENT_ID = -99
AND MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99)
AND PL2.LOOKUP_TYPE(+)='PM_PRODUCT_CODE'
AND E.PM_PRODUCT_CODE=PL2.LOOKUP_CODE(+)

Columns