View: PA_PROJ_FUND_VALID_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PROJ_FUND_VALID_V

View Text

SELECT P.PROJECT_ID PROJECT_ID
, P.NAME NAME
, P.SEGMENT1 SEGMENT1
, C.CUSTOMER_ID CUSTOMER_ID
, PT.ALLOWABLE_FUNDING_LEVEL_CODE ALLOWABLE_FUNDING_LEVEL_CODE
, LK.MEANING MEANING
, PT.PROJECT_TYPE_CLASS_CODE PROJECT_TYPE_CLASS_CODE
, C.CUSTOMER_BILL_SPLIT CUSTOMER_BILL_SPLIT
, P.TEMPLATE_FLAG TEMPLATE_FLAG
, P.MULTI_CURRENCY_BILLING_FLAG MULTI_CURRENCY_BILLING_FLAG
, INVPROC_CURRENCY_TYPE INVPROC_CURRENCY_TYPE
, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_BIL_RATE_DATE_CODE PROJECT_BIL_RATE_DATE_CODE
, PROJECT_BIL_RATE_TYPE PROJECT_BIL_RATE_TYPE
, C.USER_CONVERSION_TYPE PROJECT_BIL_RATE_TYPE_NAME
, PROJECT_BIL_RATE_DATE PROJECT_BIL_RATE_DATE
, PROJECT_BIL_EXCHANGE_RATE PROJECT_BIL_EXCHANGE_RATE
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJFUNC_BIL_RATE_DATE_CODE PROJFUNC_BIL_RATE_DATE_CODE
, PROJFUNC_BIL_RATE_TYPE PROJFUNC_BIL_RATE_TYPE
, C1.USER_CONVERSION_TYPE PROJFUNC_BIL_RATE_TYPE_NAME
, PROJFUNC_BIL_RATE_DATE PROJFUNC_BIL_RATE_DATE
, PROJFUNC_BIL_EXCHANGE_RATE PROJFUNC_BIL_EXCHANGE_RATE
, P.ENABLE_TOP_TASK_CUSTOMER_FLAG ENABLE_TOP_TASK_CUSTOMER_FLAG
, P.ORG_ID ORG_ID
, PT.CC_PRVDR_FLAG CC_PRVDR_FLAG
FROM PA_PROJECTS_ALL P
, PA_PROJECT_TYPES_ALL PT
, PA_PROJECT_CUSTOMERS C
, PA_LOOKUPS LK
, PA_CONVERSION_TYPES_V C
, PA_CONVERSION_TYPES_V C1
WHERE (DECODE(P.TEMPLATE_FLAG
, 'Y'
, 'Y'
, PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)) = 'Y'
AND DECODE(P.TEMPLATE_FLAG
, 'Y'
, 'Y'
, PA_SECURITY.ALLOW_UPDATE(P.PROJECT_ID)) = 'Y' )
AND NVL(P.ORG_ID
, -99) = NVL(PT.ORG_ID
, -99)
AND PT.PROJECT_TYPE = P.PROJECT_TYPE
AND PT.ORG_ID = P.ORG_ID
AND P.PROJECT_ID = C.PROJECT_ID
AND PA_PROJECT_STUS_UTILS.IS_PROJECT_STATUS_CLOSED( P.PROJECT_STATUS_CODE) = 'N'
AND LK.LOOKUP_TYPE(+) = 'ALLOWABLE FUNDING LEVEL'
AND LK.LOOKUP_CODE(+) = PT.ALLOWABLE_FUNDING_LEVEL_CODE
AND PA_MULTI_CURRENCY_BILLING.IS_FUNDING_ACROSS_OU_ALLOWED = 'Y' /*
AND ((P.MULTI_CURRENCY_BILLING_FLAG = 'N'
AND P.PROJFUNC_CURRENCY_CODE = PA_CURRENCY.GET_CURRENCY_CODE) OR P.MULTI_CURRENCY_BILLING_FLAG = 'Y') */
AND P.PROJECT_BIL_RATE_TYPE = C.CONVERSION_TYPE(+)
AND P.PROJFUNC_BIL_RATE_TYPE = C1.CONVERSION_TYPE(+) UNION SELECT P.PROJECT_ID PROJECT_ID
, P.NAME NAME
, P.SEGMENT1 SEGMENT1
, C.CUSTOMER_ID CUSTOMER_ID
, PT.ALLOWABLE_FUNDING_LEVEL_CODE ALLOWABLE_FUNDING_LEVEL_CODE
, LK.MEANING MEANING
, PT.PROJECT_TYPE_CLASS_CODE PROJECT_TYPE_CLASS_CODE
, C.CUSTOMER_BILL_SPLIT CUSTOMER_BILL_SPLIT
, P.TEMPLATE_FLAG TEMPLATE_FLAG
, P.MULTI_CURRENCY_BILLING_FLAG MULTI_CURRENCY_BILLING_FLAG
, INVPROC_CURRENCY_TYPE INVPROC_CURRENCY_TYPE
, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_BIL_RATE_DATE_CODE PROJECT_BIL_RATE_DATE_CODE
, PROJECT_BIL_RATE_TYPE PROJECT_BIL_RATE_TYPE
, C.USER_CONVERSION_TYPE PROJECT_BIL_RATE_TYPE_NAME
, PROJECT_BIL_RATE_DATE PROJECT_BIL_RATE_DATE
, PROJECT_BIL_EXCHANGE_RATE PROJECT_BIL_EXCHANGE_RATE
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJFUNC_BIL_RATE_DATE_CODE PROJFUNC_BIL_RATE_DATE_CODE
, PROJFUNC_BIL_RATE_TYPE PROJFUNC_BIL_RATE_TYPE
, C1.USER_CONVERSION_TYPE PROJFUNC_BIL_RATE_TYPE_NAME
, PROJFUNC_BIL_RATE_DATE PROJFUNC_BIL_RATE_DATE
, PROJFUNC_BIL_EXCHANGE_RATE PROJFUNC_BIL_EXCHANGE_RATE
, P.ENABLE_TOP_TASK_CUSTOMER_FLAG ENABLE_TOP_TASK_CUSTOMER_FLAG
, P.ORG_ID ORG_ID
, PT.CC_PRVDR_FLAG CC_PRVDR_FLAG
FROM PA_PROJECTS P
, PA_PROJECT_TYPES PT
, PA_PROJECT_CUSTOMERS C
, PA_LOOKUPS LK
, PA_CONVERSION_TYPES_V C
, PA_CONVERSION_TYPES_V C1
WHERE (DECODE(P.TEMPLATE_FLAG
, 'Y'
, 'Y'
, PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)) = 'Y'
AND DECODE(P.TEMPLATE_FLAG
, 'Y'
, 'Y'
, PA_SECURITY.ALLOW_UPDATE(P.PROJECT_ID)) = 'Y' )
AND PT.PROJECT_TYPE = P.PROJECT_TYPE
AND PT.ORG_ID = P.ORG_ID
AND P.PROJECT_ID = C.PROJECT_ID
AND PA_PROJECT_STUS_UTILS.IS_PROJECT_STATUS_CLOSED( P.PROJECT_STATUS_CODE) = 'N'
AND LK.LOOKUP_TYPE(+) = 'ALLOWABLE FUNDING LEVEL'
AND LK.LOOKUP_CODE(+) = PT.ALLOWABLE_FUNDING_LEVEL_CODE
AND PA_MULTI_CURRENCY_BILLING.IS_FUNDING_ACROSS_OU_ALLOWED = 'N' /*
AND ((P.MULTI_CURRENCY_BILLING_FLAG = 'N'
AND P.PROJFUNC_CURRENCY_CODE = PA_CURRENCY.GET_CURRENCY_CODE) OR P.MULTI_CURRENCY_BILLING_FLAG = 'Y') */
AND P.PROJECT_BIL_RATE_TYPE = C.CONVERSION_TYPE(+)
AND P.PROJFUNC_BIL_RATE_TYPE = C1.CONVERSION_TYPE(+)

Columns