View: OKE_TERM_VALUES_V

Product:	OKE - Project Contracts
Description:	Term value view
Implementation/DBA Data:	APPS.OKE_TERM_VALUES_V

View Text

SELECT 'AP_PAYMENT_TERMS'
, TO_CHAR( TERM_ID )
, 'N/A'
, NAME
, DESCRIPTION
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, NULL
, DECODE( SIGN( SYSDATE - START_DATE_ACTIVE )
, -1
, 'N'
, DECODE( SIGN( END_DATE_ACTIVE - SYSDATE )
, -1
, 'N'
, 'Y' ) ) ACTIVE
FROM AP_TERMS UNION ALL SELECT 'IB_SHIPPING_METHOD'
, TO_CHAR(ORGANIZATION_ID)
, FREIGHT_CODE
, DESCRIPTION
, DESCRIPTION
, TO_DATE(NULL)
, DISABLE_DATE
, NULL
, DECODE( SIGN( DISABLE_DATE - SYSDATE )
, -1
, 'N'
, 'Y' )
FROM ORG_FREIGHT UNION ALL SELECT 'RA_PAYMENT_TERMS'
, TO_CHAR( TERM_ID )
, 'N/A'
, NAME
, DESCRIPTION
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, NULL
, DECODE( SIGN( SYSDATE - START_DATE_ACTIVE )
, -1
, 'N'
, DECODE( SIGN( END_DATE_ACTIVE - SYSDATE )
, -1
, 'N'
, 'Y' ) ) ACTIVE
FROM RA_TERMS UNION ALL SELECT T.TERM_CODE
, LU.LOOKUP_CODE
, 'N/A'
, LU.MEANING
, LU.DESCRIPTION
, LU.START_DATE_ACTIVE
, LU.END_DATE_ACTIVE
, LU.ENABLED_FLAG
, DECODE( SIGN( SYSDATE - LU.START_DATE_ACTIVE )
, -1
, 'N'
, DECODE( SIGN( LU.END_DATE_ACTIVE - SYSDATE )
, -1
, 'N'
, LU.ENABLED_FLAG ) )
FROM FND_LOOKUP_VALUES_VL LU
, OKE_TERMS_B T
WHERE LU.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
AND LU.LOOKUP_TYPE = T.LOOKUP_TYPE
AND SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP ( T.LOOKUP_TYPE
, T.VIEW_APPLICATION_ID )

Columns