VIEW: APPS.MSD_SR_AUTH_ALL_LB_V

Source

View Text - Preformatted

SELECT DISTINCT MP.PLAN_ID, 34, MFGLOOKUP.MEANING AUTHORIZATION, MFGLOOKUP.MEANING AUTHORIZATION, MFGLOOKUP.LOOKUP_CODE, 40, MSD_SR_UTIL.get_all_auth_desc, MSD_SR_UTIL.get_all_auth_desc, MSD_SR_UTIL.get_all_auth_pk FROM MFG_LOOKUPS MFGLOOKUP , msc_plans mp WHERE MFGLOOKUP .LOOKUP_TYPE = 'MSC_AUTHORIZATIONS' AND MFGLOOKUP .ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN NVL(MFGLOOKUP .START_DATE_ACTIVE, TRUNC(SYSDATE)) AND NVL( MFGLOOKUP .END_DATE_ACTIVE, TRUNC(SYSDATE)) and ( mp.CALCULATE_LIABILITY = 1 or mp.plan_id = -1)

View Text - HTML Formatted

SELECT DISTINCT MP.PLAN_ID
, 34
, MFGLOOKUP.MEANING AUTHORIZATION
, MFGLOOKUP.MEANING AUTHORIZATION
, MFGLOOKUP.LOOKUP_CODE
, 40
, MSD_SR_UTIL.GET_ALL_AUTH_DESC
, MSD_SR_UTIL.GET_ALL_AUTH_DESC
, MSD_SR_UTIL.GET_ALL_AUTH_PK
FROM MFG_LOOKUPS MFGLOOKUP
, MSC_PLANS MP
WHERE MFGLOOKUP .LOOKUP_TYPE = 'MSC_AUTHORIZATIONS'
AND MFGLOOKUP .ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(MFGLOOKUP .START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL( MFGLOOKUP .END_DATE_ACTIVE
, TRUNC(SYSDATE))
AND ( MP.CALCULATE_LIABILITY = 1 OR MP.PLAN_ID = -1)