Product: | FII - Financial Intelligence |
---|---|
Description: | FII_AR_E_REVENUE_FCV is the collection view for FII_AR_E_REVENUE_F fact |
Implementation/DBA Data: | Not implemented in this database |
SELECT SEQ_ID
, VIEW_TYPE
, REVENUE_PK
, AR_DOC_NUM_FK
, AR_TRX_TYPE_FK
, BASE_CURRENCY_FK
, BILL_TO_CUSTOMER_FK
, BILL_TO_SITE_FK
, CAMPAIGN_ACTL_FK
, CAMPAIGN_INIT_FK
, CAMPAIGN_STATUS_ACTL_FK
, CAMPAIGN_STATUS_INIT_FK
, CELL_ACTL_FK
, CELL_INIT_FK
, EVENT_OFFER_ACTL_FK
, EVENT_OFFER_INIT_FK
, EVENT_OFFER_REG_FK
, GL_PERIOD_FK
, GL_SET_OF_BOOKS_FK
, INSTANCE_FK
, ITEM_FK
, MARKET_SEGMENT_FK
, MEDIA_ACTL_FK
, MEDIA_INIT_FK
, OFFER_ACTL_FK
, OFFER_INIT_FK
, ORGANIZATION_FK
, PARENT_ITEM_FK
, PAYMENT_TERM_FK
, PRIM_SALESREP_FK
, PROJECT_FK
, REVENUE_SOURCE_FK
, SALESCHANNEL_FK
, SALESREP_FK
, SHIP_TO_CUSTOMER_FK
, SHIP_TO_SITE_FK
, SIC_CODE_FK
, SOLD_TO_CUSTOMER_FK
, SOLD_TO_SITE_FK
, SOURCE_LIST_FK
, TRX_CURRENCY_FK
, UOM_FK
, AMT_B
, AMT_G
, AMT_T
, UNIT_SELLING_PRICE
, UNIT_STAN_PRICE
, BATCH_ID
, CCID
, CUST_TRX_LINE_ID
, DOC_LINE_NUM
, EXCHANGE_RATE
, AGREEMENT_ID
, LINE_QTY_CREDITED_NC
, LINE_QTY_INVOICED_NC
, LINE_QTY_ORDERED_NC
, ACCOUNT_CLASS
, CREATED_FROM
, DOC_REASON_CODE
, EDI_PROC_FLAG
, EX_RATE_TYPE
, LINE_TYPE
, REASON_CODE
, TRX_NUMBER
, AGREEMENT_TYPE
, INV_COMMENT
, JE_DESCRIPTION
, JE_LINE_DESC
, JE_NAME
, ORDER_NUMBER
, ORDER_LINE_ID
, EXCHANGE_DATE
, INVOICE_DATE
, GL_POSTED_DATE
, INSTANCE
, PROD_AMT_B
, PROD_AMT_G
, PROD_AMT_T
, PROD_LINE_QTY_CREDITED_NC
, PROD_LINE_QTY_INVOICED_NC
, ORG_ID
, INVENTORY_ITEM_ID
, INT_LINE_ATTR1
, INT_LINE_ATTR6
, PREVIOUS_CUSTOMER_TRX_ID
, PREVIOUS_CUSTOMER_TRX_LINE_ID
, UOM_CONV_RATE
, SET_OF_BOOKS_ID
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 1
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 1
, 25))||SUBSTR(GL_SEG
, 251)))
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 26
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 26
, 25))||SUBSTR(GL_SEG
, 251)))
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 51
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 51
, 25))||SUBSTR(GL_SEG
, 251)))
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 76
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 76
, 25))||SUBSTR(GL_SEG
, 251)))
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 101
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 101
, 25))||SUBSTR(GL_SEG
, 251)))
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 126
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 126
, 25))||SUBSTR(GL_SEG
, 251)))
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 151
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 151
, 25))||SUBSTR(GL_SEG
, 251)))
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 176
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 176
, 25))||SUBSTR(GL_SEG
, 251)))
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 201
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 201
, 25))||SUBSTR(GL_SEG
, 251)))
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 226
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 226
, 25))||SUBSTR(GL_SEG
, 251)))
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM FIIBV_AR_E_REVENUE_FCV