[Home] [Help]
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
Name |
FLOW_STATUS_CODE |
OBJECT_LEVEL |
SYNC_REQD_FLAG |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
FLOW_STATUS |