POR_REQ_XLA_TRANSACTIONS_V

Details

• Schema: FUSION

• Object owner: POR

• Object type: VIEW

Columns

Name
REQUISITION_HEADER_ID REQUISITION_NUMBER REQ_BU_ID DESCRIPTION DOCUMENT_STATUS PREPARER_ID RQ_BUDGET_CONTROL_ENABLED_FLAG LIST_NAME

Query

SQL_Statement

SELECT headers.requisition_header_id, headers.requisition_number, headers.req_bu_id, headers.description, headers.document_status, headers.preparer_id, headers.budget_control_enabled_flag AS rq_budget_control_enabled_flag, person.list_name FROM POR_REQUISITION_HEADERS_ALL headers, PER_PERSON_NAMES_F_V person WHERE headers.preparer_id = person.person_id (+) AND (sysdate >= person.EFFECTIVE_START_DATE (+) AND sysdate <= person.EFFECTIVE_END_DATE (+))