VIEW: APPS.OKE_TERM_VALUES_V

Source

View Text - Preformatted

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 , NULL FROM AP_TERMS UNION ALL SELECT 'IB_SHIPPING_METHOD' , TO_CHAR(ORGF.ORGANIZATION_ID) , ORGF.FREIGHT_CODE , ORGF.DESCRIPTION , ORGF.DESCRIPTION , TO_DATE(NULL) , ORGF.DISABLE_DATE , NULL , DECODE( SIGN( ORGF.DISABLE_DATE - SYSDATE ) , -1 , 'N' , 'Y' ) , MP.ORGANIZATION_CODE FROM ORG_FREIGHT ORGF, MTL_PARAMETERS MP WHERE ORGF.ORGANIZATION_ID=MP.ORGANIZATION_ID 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 , NULL 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 ) ) , NULL 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 ) AND T.TERM_CODE <> 'RA_PAYMENT_TERMS'

View Text - HTML Formatted

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
, NULL
FROM AP_TERMS UNION ALL SELECT 'IB_SHIPPING_METHOD'
, TO_CHAR(ORGF.ORGANIZATION_ID)
, ORGF.FREIGHT_CODE
, ORGF.DESCRIPTION
, ORGF.DESCRIPTION
, TO_DATE(NULL)
, ORGF.DISABLE_DATE
, NULL
, DECODE( SIGN( ORGF.DISABLE_DATE - SYSDATE )
, -1
, 'N'
, 'Y' )
, MP.ORGANIZATION_CODE
FROM ORG_FREIGHT ORGF
, MTL_PARAMETERS MP
WHERE ORGF.ORGANIZATION_ID=MP.ORGANIZATION_ID 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
, NULL
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 ) )
, NULL
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 )
AND T.TERM_CODE <> 'RA_PAYMENT_TERMS'