VIEW: APPS.BIL_DIMV_OPTY_STATUSES

Source

View Text - Preformatted

SELECT T.STATUS_CODE ,T.MEANING ,T.DESCRIPTION ,B.ENABLED_FLAG ,B.LEAD_FLAG ,B.OPP_FLAG ,B.OPP_OPEN_STATUS_FLAG ,B.OPP_DECISION_DATE_FLAG ,B.STATUS_RANK ,B.FORECAST_ROLLUP_FLAG ,B.WIN_LOSS_INDICATOR ,B.USAGE_INDICATOR ,B.LAST_UPDATE_DATE ,B.LAST_UPDATED_BY ,B.CREATION_DATE ,B.CREATED_BY ,B.LAST_UPDATE_LOGIN from AS_STATUSES_B B , AS_STATUSES_TL T WHERE B.STATUS_CODE = T.STATUS_CODE and T.LANGUAGE = userenv('LANG') UNION ALL (SELECT FL.LOOKUP_CODE SALES_STAGE_PK , FL.MEANING MEANING , FL.DESCRIPTION DESCRIPTION , FL.ENABLED_FLAG ENABLED_FLAG , 'N' LEAD_FLAG , 'N' OPP_FLAG , 'N' OPP_OPEN_STATUS_FLAG , 'N' OPP_DECISION_DATE_FLAG , TO_NUMBER(FL.LOOKUP_CODE) STATUS_RANK , 'N' FORECAST_ROLLUP_FLAG , 'N' WIN_LOSS_INDICATOR , 'N' USAGE_INDICATOR , FL.END_DATE_ACTIVE LAST_UPDATE_DATE , TO_NUMBER(FL.LOOKUP_CODE) LAST_UPDATED_BY , FL.END_DATE_ACTIVE CREATION_DATE , TO_NUMBER(FL.LOOKUP_CODE) CREATED_BY , TO_NUMBER(FL.LOOKUP_CODE) LAST_UPDATE_LOGIN FROM FND_LOOKUPS FL WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE' AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY

View Text - HTML Formatted

SELECT T.STATUS_CODE
, T.MEANING
, T.DESCRIPTION
, B.ENABLED_FLAG
, B.LEAD_FLAG
, B.OPP_FLAG
, B.OPP_OPEN_STATUS_FLAG
, B.OPP_DECISION_DATE_FLAG
, B.STATUS_RANK
, B.FORECAST_ROLLUP_FLAG
, B.WIN_LOSS_INDICATOR
, B.USAGE_INDICATOR
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
FROM AS_STATUSES_B B
, AS_STATUSES_TL T
WHERE B.STATUS_CODE = T.STATUS_CODE
AND T.LANGUAGE = USERENV('LANG') UNION ALL (SELECT FL.LOOKUP_CODE SALES_STAGE_PK
, FL.MEANING MEANING
, FL.DESCRIPTION DESCRIPTION
, FL.ENABLED_FLAG ENABLED_FLAG
, 'N' LEAD_FLAG
, 'N' OPP_FLAG
, 'N' OPP_OPEN_STATUS_FLAG
, 'N' OPP_DECISION_DATE_FLAG
, TO_NUMBER(FL.LOOKUP_CODE) STATUS_RANK
, 'N' FORECAST_ROLLUP_FLAG
, 'N' WIN_LOSS_INDICATOR
, 'N' USAGE_INDICATOR
, FL.END_DATE_ACTIVE LAST_UPDATE_DATE
, TO_NUMBER(FL.LOOKUP_CODE) LAST_UPDATED_BY
, FL.END_DATE_ACTIVE CREATION_DATE
, TO_NUMBER(FL.LOOKUP_CODE) CREATED_BY
, TO_NUMBER(FL.LOOKUP_CODE) LAST_UPDATE_LOGIN
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY