CMF_FDS_WITH_PO_DTLS_V

Details

• Schema: FUSION

• Object owner: CMF

• Object type: VIEW

Columns

Name
FD_HEADERS_INT_ID FD_LINES_INT_ID FD_SCHEDULES_INT_ID SOURCE_DOC_ID1 SOURCE_DOC_ID2 SOURCE_DOC_ID3

Query

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'