FND Design Data [Home] [Help]

View: SO_FOBS_ACTIVE_V

Product: OE - Order Entry
Description:
Implementation/DBA Data: ViewAPPS.SO_FOBS_ACTIVE_V
View Text

SELECT MEANING FOB
, LOOKUP_CODE FOB_CODE
FROM AR_LOOKUPS
WHERE LOOKUP_TYPE = 'FOB'
AND ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns

Name
FOB
FOB_CODE