CMF_SALES_ORDER_FOS_INFO

Details

Schema: FUSION
Object owner: CMF
Object type: VIEW

Columns

Name
SALESORDERHEADERID SALESORDERNUMBER TRADEEVENTDEFINITIONID TRADEEVENTID TRADEEVENTNUMBER TRADEEVENTTYPECODE TRADEEVENTDATE TRADEEVENTAGREEMENTNUMBER SALESORDERALLOCATEDQUANTITY SALESORDERUOM SALESORDERDATE SALESORDERLINENUMBER SALESORDERFULFILLMENTLINE SALESORDERUNITPRICE SALESORDERCURRENCYCODE

Name

SALESORDERHEADERID

SALESORDERNUMBER

TRADEEVENTDEFINITIONID

TRADEEVENTID

TRADEEVENTNUMBER

TRADEEVENTTYPECODE

TRADEEVENTDATE

TRADEEVENTAGREEMENTNUMBER

SALESORDERALLOCATEDQUANTITY

SALESORDERUOM

SALESORDERDATE

SALESORDERLINENUMBER

SALESORDERFULFILLMENTLINE

SALESORDERUNITPRICE

SALESORDERCURRENCYCODE

Query

SQL_Statement
SELECT HEADERPEO.HEADER_ID AS SalesOrderHeaderId, FOSSOURCEEVENTINFORMATIONPEO.DOCUMENT_NUMBER AS SalesOrderNumber, FOSSOURCEEVENTINFORMATIONPEO.EVENT_DEFINITION_ID AS TradeEventDefinitionId, FOSSOURCEEVENTINFORMATIONPEO.EVENT_DATA_ID AS TradeEventId, FOSSOURCEEVENTINFORMATIONPEO.EVENT_NUMBER AS TradeEventNumber, FOSSOURCEEVENTINFORMATIONPEO.EVENT_TYPE AS TradeEventTypeCode, FOSSOURCEEVENTINFORMATIONPEO.EVENT_DATE AS TradeEventDate, FOSSOURCEEVENTINFORMATIONPEO.AGREEMENT_NUMBER AS TradeEventAgreementNumber, FOSSOURCEEVENTINFORMATIONPEO.QUANTITY AS SalesOrderAllocatedQuantity, FOSSOURCEEVENTINFORMATIONPEO.UOM AS SalesOrderUOM, FOSSOURCEEVENTINFORMATIONPEO.DOCUMENT_DATE AS SalesOrderDate, FOSSOURCEEVENTINFORMATIONPEO.DOCUMENT_LINE_NUMBER AS SalesOrderLineNumber, FOSSOURCEEVENTINFORMATIONPEO.DOCUMENT_LINE_DETAIL_NUMBER AS SalesOrderFulfillmentLine, FOSTRANSFERPRICEFDCPEO.UNIT_PRICE AS SalesOrderUnitPrice , FOSTRANSFERPRICEFDCPEO.CURRENCY_CODE AS SalesOrderCurrencyCode FROM DOO_HEADERS_ALL HEADERPEO, FOS_SOURCE_EVENT_INFORMATION_V FOSSOURCEEVENTINFORMATIONPEO, FOS_TRANSFER_PRICE_FDC_V FOSTRANSFERPRICEFDCPEO WHERE HEADERPEO.ORDER_NUMBER = FOSSOURCEEVENTINFORMATIONPEO.DOCUMENT_NUMBER AND ( - 1 = FOSTRANSFERPRICEFDCPEO.SOURCE_SYSTEM_ID ) AND ( FOSSOURCEEVENTINFORMATIONPEO.EVENT_DEFINITION_ID = FOSTRANSFERPRICEFDCPEO.EVENT_DEFINITION_ID ) AND ( FOSSOURCEEVENTINFORMATIONPEO.EVENT_DATA_ID = FOSTRANSFERPRICEFDCPEO.EVENT_DATA_ID ) AND ( FOSSOURCEEVENTINFORMATIONPEO.DOCUMENT_TYPE = FOSTRANSFERPRICEFDCPEO.DOCUMENT_TYPE ) AND ('OO' = FOSSOURCEEVENTINFORMATIONPEO.DOCUMENT_TYPE)

SQL_Statement

SELECT

HEADERPEO.HEADER_ID AS SalesOrderHeaderId,

FOSSOURCEEVENTINFORMATIONPEO.DOCUMENT_NUMBER AS SalesOrderNumber,

FOSSOURCEEVENTINFORMATIONPEO.EVENT_DEFINITION_ID AS TradeEventDefinitionId,

FOSSOURCEEVENTINFORMATIONPEO.EVENT_DATA_ID AS TradeEventId,

FOSSOURCEEVENTINFORMATIONPEO.EVENT_NUMBER AS TradeEventNumber,

FOSSOURCEEVENTINFORMATIONPEO.EVENT_TYPE AS TradeEventTypeCode,

FOSSOURCEEVENTINFORMATIONPEO.EVENT_DATE AS TradeEventDate,

FOSSOURCEEVENTINFORMATIONPEO.AGREEMENT_NUMBER AS TradeEventAgreementNumber,

FOSSOURCEEVENTINFORMATIONPEO.QUANTITY AS SalesOrderAllocatedQuantity,

FOSSOURCEEVENTINFORMATIONPEO.UOM AS SalesOrderUOM,

FOSSOURCEEVENTINFORMATIONPEO.DOCUMENT_DATE AS SalesOrderDate,

FOSSOURCEEVENTINFORMATIONPEO.DOCUMENT_LINE_NUMBER AS SalesOrderLineNumber,

FOSSOURCEEVENTINFORMATIONPEO.DOCUMENT_LINE_DETAIL_NUMBER AS SalesOrderFulfillmentLine,

FOSTRANSFERPRICEFDCPEO.UNIT_PRICE AS SalesOrderUnitPrice ,

FOSTRANSFERPRICEFDCPEO.CURRENCY_CODE AS SalesOrderCurrencyCode

FROM

DOO_HEADERS_ALL HEADERPEO,

FOS_SOURCE_EVENT_INFORMATION_V FOSSOURCEEVENTINFORMATIONPEO,

FOS_TRANSFER_PRICE_FDC_V FOSTRANSFERPRICEFDCPEO

WHERE

HEADERPEO.ORDER_NUMBER = FOSSOURCEEVENTINFORMATIONPEO.DOCUMENT_NUMBER

AND ( - 1 = FOSTRANSFERPRICEFDCPEO.SOURCE_SYSTEM_ID )

AND ( FOSSOURCEEVENTINFORMATIONPEO.EVENT_DEFINITION_ID = FOSTRANSFERPRICEFDCPEO.EVENT_DEFINITION_ID )

AND ( FOSSOURCEEVENTINFORMATIONPEO.EVENT_DATA_ID = FOSTRANSFERPRICEFDCPEO.EVENT_DATA_ID )

AND ( FOSSOURCEEVENTINFORMATIONPEO.DOCUMENT_TYPE = FOSTRANSFERPRICEFDCPEO.DOCUMENT_TYPE )

AND ('OO' = FOSSOURCEEVENTINFORMATIONPEO.DOCUMENT_TYPE)