VIEW: IBE.IBE_ECR_ORDER_HEADERS_FACT#

Source

View Text - Preformatted

select FACT_DATE FACT_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID, RESOURCE_ID RESOURCE_ID, ORG_ID ORG_ID, CURRENCY_CODE CURRENCY_CODE, HEADER_ID HEADER_ID, ORDERED_DATE ORDERED_DATE, ORDER_NUMBER ORDER_NUMBER, TRANSACTIONAL_CURR_CODE TRANSACTIONAL_CURR_CODE, CONVERSION_RATE CONVERSION_RATE, SOLD_TO_ORG_ID SOLD_TO_ORG_ID, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID, AGREEMENT_ID AGREEMENT_ID, SALESREP_ID SALESREP_ID, FUNCTIONAL_AMOUNT FUNCTIONAL_AMOUNT, REPORTED_AMOUNT REPORTED_AMOUNT, PARTY_ID PARTY_ID, CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE, ID ID from "IBE"."IBE_ECR_ORDER_HEADERS_FACT"

View Text - HTML Formatted

SELECT FACT_DATE FACT_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, RESOURCE_ID RESOURCE_ID
, ORG_ID ORG_ID
, CURRENCY_CODE CURRENCY_CODE
, HEADER_ID HEADER_ID
, ORDERED_DATE ORDERED_DATE
, ORDER_NUMBER ORDER_NUMBER
, TRANSACTIONAL_CURR_CODE TRANSACTIONAL_CURR_CODE
, CONVERSION_RATE CONVERSION_RATE
, SOLD_TO_ORG_ID SOLD_TO_ORG_ID
, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID
, AGREEMENT_ID AGREEMENT_ID
, SALESREP_ID SALESREP_ID
, FUNCTIONAL_AMOUNT FUNCTIONAL_AMOUNT
, REPORTED_AMOUNT REPORTED_AMOUNT
, PARTY_ID PARTY_ID
, CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE
, ID ID
FROM "IBE"."IBE_ECR_ORDER_HEADERS_FACT"