View: PA_BILLING_EXTN_PARAMS_V

Product:	PA - Projects
Description:	View of events for a MCB for a specific bill assignment id for use with billing extensions. Full Description: is a runtime view for use in billing extensions that shows a single row with all the new conversion attributes and can be used if
Implementation/DBA Data:	APPS.PA_BILLING_EXTN_PARAMS_V

View Text

SELECT BE.BILLING_ASSIGNMENT_ID
, BE.RATE_OVERRIDE_CURRENCY_CODE
, BE.PROJECT_CURRENCY_CODE
, BE.PROJECT_RATE_TYPE
, BE.PROJECT_RATE_DATE
, BE.PROJECT_EXCHANGE_RATE
, BE.PROJFUNC_CURRENCY_CODE
, BE.PROJFUNC_RATE_TYPE
, BE.PROJFUNC_RATE_DATE
, BE.PROJFUNC_EXCHANGE_RATE
, BE.FUNDING_RATE_TYPE
, BE.FUNDING_RATE_DATE
, BE.FUNDING_EXCHANGE_RATE
, B.DEFAULT_COST_PLAN_TYPE_ID
, B.DEFAULT_REV_PLAN_TYPE_ID
FROM PA_BILLING_ASSIGNMENTS BE
, PA_BILLING_EXTENSIONS B
WHERE BE.BILLING_ASSIGNMENT_ID = PA_BILLING.GETBILLINGASSIGNMENTID
AND BE.PROJECT_ID IS NOT NULL
AND B.BILLING_EXTENSION_ID = BE.BILLING_EXTENSION_ID UNION SELECT BE.BILLING_ASSIGNMENT_ID
, BE.RATE_OVERRIDE_CURRENCY_CODE
, BE.PROJECT_CURRENCY_CODE
, BE.PROJECT_RATE_TYPE
, BE.PROJECT_RATE_DATE
, BE.PROJECT_EXCHANGE_RATE
, BE.PROJFUNC_CURRENCY_CODE
, BE.PROJFUNC_RATE_TYPE
, BE.PROJFUNC_RATE_DATE
, BE.PROJFUNC_EXCHANGE_RATE
, BE.FUNDING_RATE_TYPE
, BE.FUNDING_RATE_DATE
, BE.FUNDING_EXCHANGE_RATE
, B.DEFAULT_COST_PLAN_TYPE_ID
, B.DEFAULT_REV_PLAN_TYPE_ID
FROM PA_BILLING_ASSIGNMENTS BE
, PA_BILLING_EXTENSIONS B
WHERE BE.BILLING_ASSIGNMENT_ID = PA_BILLING.GETBILLINGASSIGNMENTID
AND BE.TOP_TASK_ID IS NOT NULL
AND B.BILLING_EXTENSION_ID = BE.BILLING_EXTENSION_ID UNION SELECT BE.BILLING_ASSIGNMENT_ID
, BE.RATE_OVERRIDE_CURRENCY_CODE
, P.PROJECT_CURRENCY_CODE
, P.PROJECT_BIL_RATE_TYPE
, P.PROJECT_BIL_RATE_DATE
, P.PROJECT_BIL_EXCHANGE_RATE
, P.PROJFUNC_CURRENCY_CODE
, P.PROJFUNC_BIL_RATE_TYPE
, P.PROJFUNC_BIL_RATE_DATE
, P.PROJFUNC_BIL_EXCHANGE_RATE
, P.FUNDING_RATE_TYPE
, P.FUNDING_RATE_DATE
, P.FUNDING_EXCHANGE_RATE
, B.DEFAULT_COST_PLAN_TYPE_ID
, B.DEFAULT_REV_PLAN_TYPE_ID
FROM PA_BILLING_ASSIGNMENTS BE
, PA_PROJECTS_ALL P
, PA_BILLING_EXTENSIONS B
WHERE P.PROJECT_TYPE = BE.PROJECT_TYPE
AND BE.PROJECT_TYPE IS NOT NULL
AND B.BILLING_EXTENSION_ID = BE.BILLING_EXTENSION_ID
AND BE.BILLING_ASSIGNMENT_ID = PA_BILLING.GETBILLINGASSIGNMENTID
AND P.PROJECT_ID = PA_BILLING.GETPROJID
AND P.ORG_ID = BE.ORG_ID UNION SELECT BE.BILLING_ASSIGNMENT_ID
, BE.RATE_OVERRIDE_CURRENCY_CODE
, P.PROJECT_CURRENCY_CODE
, P.PROJECT_BIL_RATE_TYPE
, P.PROJECT_BIL_RATE_DATE
, P.PROJECT_BIL_EXCHANGE_RATE
, P.PROJFUNC_CURRENCY_CODE
, P.PROJFUNC_BIL_RATE_TYPE
, P.PROJFUNC_BIL_RATE_DATE
, P.PROJFUNC_BIL_EXCHANGE_RATE
, P.FUNDING_RATE_TYPE
, P.FUNDING_RATE_DATE
, P.FUNDING_EXCHANGE_RATE
, B.DEFAULT_COST_PLAN_TYPE_ID
, B.DEFAULT_REV_PLAN_TYPE_ID
FROM PA_BILLING_ASSIGNMENTS BE
, PA_PROJECTS_ALL P
, PA_BILLING_EXTENSIONS B
WHERE P.DISTRIBUTION_RULE = BE.DISTRIBUTION_RULE
AND BE.DISTRIBUTION_RULE IS NOT NULL
AND B.BILLING_EXTENSION_ID = BE.BILLING_EXTENSION_ID
AND BE.BILLING_ASSIGNMENT_ID = PA_BILLING.GETBILLINGASSIGNMENTID
AND P.PROJECT_ID = PA_BILLING.GETPROJID
AND P.ORG_ID = BE.ORG_ID

Columns