View: OE_FLOW_STATUS_AIA_SYNC_V

Product:	ONT - Order Management
Description:	This view is created to build the AIA UI (AIA Sales Order status Synchronization) and let user query on the FLOW STATUS field.
Implementation/DBA Data:	APPS.OE_FLOW_STATUS_AIA_SYNC_V

View Text

SELECT OFS.FLOW_STATUS_CODE
, OFS.OBJECT_LEVEL
, OFS.SYNC_REQD_FLAG
, OFS.CREATION_DATE
, OFS.CREATED_BY
, OFS.LAST_UPDATE_DATE
, OFS.LAST_UPDATED_BY
, OFS.LAST_UPDATE_LOGIN
, LKUP.MEANING
FROM OE_FLOW_STATUS_AIA_SYNC OFS
, OE_LOOKUPS LKUP
WHERE OFS.FLOW_STATUS_CODE = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'LINE_FLOW_STATUS'

Columns