VIEW: APPS.PA_PROJ_FUND_VALID_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)