FOS_EVENT_DOCUMENT_REF_V

Details

• Schema: FUSION

• Object owner: FOS

• Object type: VIEW

Columns

Name
FLOW_INSTANCE_ID TARGET_DOCUMENT_HEADER TARGET_DOCUMENT_HEADER_ID TARGET_DOCUMENT_LINE TARGET_DOCUMENT_LINE_ID ORDER_TYPE_CODE ORDER_TYPE_MEANING

Query

SQL_Statement

SELECT fi.flow_instance_id, fi.target_document_header, fi.target_document_header_id, fi.target_document_line, fi.target_document_line_id, edi.order_type_code, otc.meaning order_type_meaning FROM fos_flow_instances fi, fos_doc_flow_assignment dfa, fos_event_doc_info edi, fnd_lookups otc WHERE fi.document_flow_assignment_id = dfa.document_flow_assignment_id AND dfa.source_document_id = edi.source_document_id AND dfa.document_type = edi.document_type AND dfa.system_id = edi.document_source_system_id AND otc.lookup_code (+) = edi.order_type_code AND otc.lookup_type (+) = 'ORA_DOO_ORDER_TYPES'