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