VIEW: APPS.PA_BILLING_EXTN_PARAMS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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