[Home] [Help]
View: OEFV_SALES_CREDIT_TYPES
View Text
SELECT CRTYPE.SALES_CREDIT_TYPE_ID
, CRTYPE.NAME
, CRTYPE.DESCRIPTION
, LOOKUP.MEANING
, LOOKUP2.MEANING
, '_DF:OE:SO_SALES_CREDIT_TYPES:CRTYPE'
, CRTYPE.LAST_UPDATE_DATE
, CRTYPE.LAST_UPDATED_BY
, CRTYPE.CREATION_DATE
, CRTYPE.CREATED_BY
FROM SO_SALES_CREDIT_TYPES CRTYPE
, SO_LOOKUPS LOOKUP
, SO_LOOKUPS LOOKUP2
WHERE LOOKUP.LOOKUP_TYPE = 'YES_NO'
AND LOOKUP.LOOKUP_CODE = CRTYPE.ENABLED_FLAG
AND LOOKUP2.LOOKUP_TYPE = 'YES_NO'
AND LOOKUP2.LOOKUP_CODE = CRTYPE.QUOTA_FLAG WITH READ ONLY
Columns
| Name |
| SALES_CREDIT_TYPE_ID |
| NAME |
| DESCRIPTION |
| QUOTA |
| ENABLED |
| "_DF" |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
APPS.OEFV_SALES_CREDIT_TYPES