機械翻訳について

CST_XLA_TRADE_EVENTS_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: CST

• オブジェクト・タイプ: VIEW

列

名前
TRADE_EVENT_ID SOURCE_DOCUMENT_TYPE SOURCE_DOCUMENT_NUMBER TRADE_ORG_CODE SFO_AGREEMENT_NUMBER FROM_PROFIT_CENTER_BU_ID PRIOR_TRADE_ORGANIZATION_ID FROM_INV_ORG_CODE FROM_PROFIT_CENTER_BU_NAME

問合せ

SQL_Statement

SELECT CTE.TRADE_EVENT_ID TRADE_EVENT_ID, CTE.TXN_SOURCE_DOC_TYPE SOURCE_DOCUMENT_TYPE , CTE.TXN_SOURCE_DOC_NUMBER SOURCE_DOCUMENT_NUMBER , IOP.ORGANIZATION_CODE TRADE_ORG_CODE, CTE.AGREEMENT_NUMBER SFO_AGREEMENT_NUMBER, CTE.PRIOR_BU_ID FROM_PROFIT_CENTER_BU_ID, CTE.PRIOR_INVENTORY_ORG_ID PRIOR_TRADE_ORGANIZATION_ID, IOP.ORGANIZATION_CODE FROM_INV_ORG_CODE, HAOU.NAME FROM_PROFIT_CENTER_BU_NAME FROM CST_TRADE_EVENTS CTE, INV_ORG_PARAMETERS IOP, HR_ALL_ORGANIZATION_UNITS HAOU WHERE CTE.PRIOR_INVENTORY_ORG_ID=IOP.ORGANIZATION_ID(+) AND HAOU.ORGANIZATION_ID(+) = IOP.BUSINESS_UNIT_ID