機械翻訳について

CMF_FDS_WITH_PO_DTLS_V

詳細

• スキーマ: FUSION

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

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

列

名前
FD_HEADERS_INT_ID FD_LINES_INT_ID FD_SCHEDULES_INT_ID SOURCE_DOC_ID1 SOURCE_DOC_ID2 SOURCE_DOC_ID3

問合せ

SQL_Statement

select /*+ index(fds CMF_FISCAL_DOC_SCHEDULES_N1) */ fds.FISCAL_DOC_HEADER_ID, fds.FISCAL_DOC_LINE_ID, fds.FISCAL_DOC_SCHEDULE_ID, fds.SOURCE_DOC_ID1, fds.SOURCE_DOC_ID2, fds.SOURCE_DOC_ID3 from CMF_FISCAL_DOC_SCHEDULES fds where fds.SOURCE_DOC_TYPE = 'PURCHASE_ORDER' union select FD_HEADERS_INT_ID, FD_LINES_INT_ID, null, SOURCE_DOC_HEADER_ID, SOURCE_DOC_LINE_ID, SOURCE_DOC_SCHEDULE_ID from CMF_FD_LINES_INT where SOURCE_DOCUMENT_TYPE = 'PURCHASE_ORDER' union select FD_HEADERS_INT_ID, FD_LINES_INT_ID, FD_SCHEDULES_INT_ID, SOURCE_DOC_ID1, SOURCE_DOC_ID2, SOURCE_DOC_ID3 from CMF_FD_SCHEDULES_INT where SOURCE_DOC_TYPE = 'PURCHASE_ORDER'