Product: | FII - Financial Intelligence |
---|---|
Description: | Internal view used for warehouse data extraction |
Implementation/DBA Data: | APPS.FII_AR_TRX_DIST_FCV |
SELECT SEQ_ID
, VIEW_TYPE
, INVOICE_PK
, FUNCTIONAL_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
, COMPANY_CC_ORG_FK
, EVENT_OFFER_ACTL_FK
, EVENT_OFFER_INIT_FK
, EVENT_OFFER_REG_FK
, GL_DATE_FK
, 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_SALESRESOURCE_FK
, PROJECT_FK
, SALESCHANNEL_FK
, SALESRESOURCE_FK
, SHIP_TO_CUSTOMER_FK
, SHIP_TO_SITE_FK
, SIC_CODE_FK
, SOLD_TO_CUSTOMER_FK
, SOLD_TO_SITE_FK
, SOURCE_LIST_FK
, TRANSACTION_CURRENCY_FK
, END_USER_CUSTOMER_FK
, RESELLER_CUSTOMER_FK
, INVOICE_DATE_FK
, SALES_ORDER_DATE_FK
, UOM_FK
, AMT_B
, AMT_G
, AMT_T
, UNIT_SELLING_PRICE
, SO_LINE_SELLING_PRICE
, ACCOUNT_ID
, INVOICE_LINE_ID
, INVOICE_LINE_NUMBER
, EXCHANGE_RATE
, QTY_CREDITED_NC
, INVOICE_LINE_QTY_NC
, ORDER_LINE_QTY_NC
, INVOICE_SOURCE_NAME
, PROCESS_TYPE
, EXCHANGE_RATE_TYPE
, LINE_TYPE
, INVOICE_REASON
, INVOICE_NUMBER
, AGREEMENT_TYPE
, AGREEMENT_NAME
, SALES_ORDER_NUMBER
, ORDER_LINE_ID
, EXCHANGE_DATE
, INVOICE_DATE
, GL_DATE
, INSTANCE
, BILL_TO_CUSTOMER_ID
, BILL_TO_ADDRESS_ID
, CUST_PO_NUMBER
, ORDER_LINE_SOURCE_DOC_TYPE_ID
, ORDER_LINE_TYPE_ID
, INTERFACE_HEADER_CONTEXT
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, '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
, ORG_ID
, INVENTORY_ITEM_ID
, INT_LINE_ATTR1
, INT_LINE_ATTR6
, UOM_CONV_RATE
, SET_OF_BOOKS_ID
, INVOICE_LINE_MEMO
, SALES_ORDER_LINE_NUMBER
, SALES_ORDER_SOURCE
, ORIGINAL_INVOICE_NUM
, ORIGINAL_INVOICE_LINE_NUM
, INVOICE_ID
, INVOICE_DIST_ID
, ORIGINAL_INVOICE_ID
, ORIGINAL_INVOICE_LINE_ID
, ACCOUNT_TYPE
, ACCOUNT_CLASS
, INTERNAL_FLAG
, INTERFACE_LINE_CONTEXT
, INT_LINE_ATTR2
, INT_LINE_ATTR3
, INT_LINE_ATTR4
, INT_LINE_ATTR5
, INT_LINE_ATTR7
, INT_LINE_ATTR8
, INT_LINE_ATTR9
, INT_LINE_ATTR10
, INT_LINE_ATTR11
, INT_LINE_ATTR12
, INT_LINE_ATTR13
, INT_LINE_ATTR14
, INT_LINE_ATTR15
, GL_POSTED_DATE
, TRANSACTION_CLASS
, TRANSACTION_STATUS
, GLOBAL_CURRENCY_RATE
FROM FIIBV_AR_TRX_DIST_FCV