eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CS_CONTRACT_STATUSES_V

Source

View Text - Preformatted


SELECT CSS.CONTRACT_STATUS_ID , CSS.NAME , DECODE(CSS.STATUS_LEVEL, 1, 'CONTRACT', 2, 'LINE', 3, 'ALL') STATUS_LEVEL , CSS.START_DATE_ACTIVE , CSS.END_DATE_ACTIVE , FND1.MEANING UPDATE_ALLOWED , FND2.MEANING ELIGIBLE_FOR_ENTITLEMENTS , FND3.MEANING ELIGIBLE_FOR_INVOICING , FND4.MEANING TERMINATED_FLAG , FND5.MEANING DELETE_ALLOWED , FND6.MEANING VALIDATE_CONTRACT FROM CS_CONTRACT_STATUSES CSS, FND_LOOKUPS FND1, FND_LOOKUPS FND2, FND_LOOKUPS FND3, FND_LOOKUPS FND4, FND_LOOKUPS FND5, FND_LOOKUPS FND6 WHERE FND1.LOOKUP_TYPE = 'YES_NO' AND FND2.LOOKUP_TYPE = 'YES_NO' AND FND3.LOOKUP_TYPE = 'YES_NO' AND FND4.LOOKUP_TYPE = 'YES_NO' AND FND5.LOOKUP_TYPE = 'YES_NO' AND FND6.LOOKUP_TYPE = 'YES_NO' AND CSS.UPDATE_ALLOWED = FND1.LOOKUP_CODE AND CSS.ELIGIBLE_FOR_ENTITLEMENTS = FND2.LOOKUP_CODE AND CSS.ELIGIBLE_FOR_INVOICING = FND3.LOOKUP_CODE AND CSS.TERMINATED_FLAG = FND4.LOOKUP_CODE AND CSS.DELETE_ALLOWED = FND5.LOOKUP_CODE AND CSS.VALIDATE_CONTRACT = FND6.LOOKUP_CODE

View Text - HTML Formatted

SELECT CSS.CONTRACT_STATUS_ID
, CSS.NAME
, DECODE(CSS.STATUS_LEVEL
, 1
, 'CONTRACT'
, 2
, 'LINE'
, 3
, 'ALL') STATUS_LEVEL
, CSS.START_DATE_ACTIVE
, CSS.END_DATE_ACTIVE
, FND1.MEANING UPDATE_ALLOWED
, FND2.MEANING ELIGIBLE_FOR_ENTITLEMENTS
, FND3.MEANING ELIGIBLE_FOR_INVOICING
, FND4.MEANING TERMINATED_FLAG
, FND5.MEANING DELETE_ALLOWED
, FND6.MEANING VALIDATE_CONTRACT
FROM CS_CONTRACT_STATUSES CSS
, FND_LOOKUPS FND1
, FND_LOOKUPS FND2
, FND_LOOKUPS FND3
, FND_LOOKUPS FND4
, FND_LOOKUPS FND5
, FND_LOOKUPS FND6
WHERE FND1.LOOKUP_TYPE = 'YES_NO'
AND FND2.LOOKUP_TYPE = 'YES_NO'
AND FND3.LOOKUP_TYPE = 'YES_NO'
AND FND4.LOOKUP_TYPE = 'YES_NO'
AND FND5.LOOKUP_TYPE = 'YES_NO'
AND FND6.LOOKUP_TYPE = 'YES_NO'
AND CSS.UPDATE_ALLOWED = FND1.LOOKUP_CODE
AND CSS.ELIGIBLE_FOR_ENTITLEMENTS = FND2.LOOKUP_CODE
AND CSS.ELIGIBLE_FOR_INVOICING = FND3.LOOKUP_CODE
AND CSS.TERMINATED_FLAG = FND4.LOOKUP_CODE
AND CSS.DELETE_ALLOWED = FND5.LOOKUP_CODE
AND CSS.VALIDATE_CONTRACT = FND6.LOOKUP_CODE