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' |