VIEW: APPS.FII_AR_TRX_DIST_FCV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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