VIEW: APPS.PA_EVENTS_V

Source

View Text - Preformatted

SELECT E.ROWID , E.EVENT_ID , E.PROJECT_ID , P.SEGMENT1 , P.NAME , E.TASK_ID , T.TASK_NUMBER , T.TASK_NAME , E.AGREEMENT_ID , P.DATE_EFF_FUNDS_CONSUMPTION , 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 , 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_LOOKUPS PL, PA_LOOKUPS PL1, 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 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 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.AGREEMENT_ID , P.DATE_EFF_FUNDS_CONSUMPTION , 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 , 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_LOOKUPS PL, PA_LOOKUPS PL1, 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 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 PL2.LOOKUP_TYPE(+)='PM_PRODUCT_CODE' AND E.PM_PRODUCT_CODE=PL2.LOOKUP_CODE(+)

View Text - HTML Formatted

SELECT E.ROWID
, E.EVENT_ID
, E.PROJECT_ID
, P.SEGMENT1
, P.NAME
, E.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, E.AGREEMENT_ID
, P.DATE_EFF_FUNDS_CONSUMPTION
, 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
, 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_LOOKUPS PL
, PA_LOOKUPS PL1
, 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 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 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.AGREEMENT_ID
, P.DATE_EFF_FUNDS_CONSUMPTION
, 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
, 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_LOOKUPS PL
, PA_LOOKUPS PL1
, 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 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 PL2.LOOKUP_TYPE(+)='PM_PRODUCT_CODE'
AND E.PM_PRODUCT_CODE=PL2.LOOKUP_CODE(+)