POR_REQ_BU_OPTIONS_ALL_SEC

Details

• Schema: FUSION

• Object owner: POR

• Object type: VIEW

Columns

Name

REQ_BU_ID APPR_REQUIRED_BUYER_MOD_FLAG PRC_BU_ID REQ_BU_OPTIONS_ID INV_ORG_ID LINE_TYPE_ID REQIMPORT_GROUP_BY_CODE REAPPROVAL_REQUIRED_FLAG CREATE_ORDERS_FLAG UOM_CONVERSION_FLAG PRICE_CHANGE_PERCENT_TOLERANCE PRICE_CHANGE_AMOUNT_TOLERANCE SHIP_TO_LOCATION_ID ONE_TIME_LOCATION_ID CANCEL_BACKING_REQ_CODE ENABLE_CATG_SUGGESTIONS_FLAG SPEND_CLASS_KNOWLEDGE_BASE REQ_HEADER_DFF_CONTEXT_CODE REQ_LINE_DFF_CONTEXT_CODE REQ_DIST_DFF_CONTEXT_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER MULTIPLE_LEGAL_ENTITIES ENABLE_APPROVER_OVERRIDE_FLAG ALLOW_ONETIME_ADDR_FLAG

Query

SQL_Statement

SELECT REQ_BU_ID, APPR_REQUIRED_BUYER_MOD_FLAG, PRC_BU_ID, REQ_BU_OPTIONS_ID, INV_ORG_ID, LINE_TYPE_ID, REQIMPORT_GROUP_BY_CODE, REAPPROVAL_REQUIRED_FLAG, CREATE_ORDERS_FLAG, UOM_CONVERSION_FLAG, PRICE_CHANGE_PERCENT_TOLERANCE, PRICE_CHANGE_AMOUNT_TOLERANCE, SHIP_TO_LOCATION_ID, ONE_TIME_LOCATION_ID, CANCEL_BACKING_REQ_CODE, ENABLE_CATG_SUGGESTIONS_FLAG, SPEND_CLASS_KNOWLEDGE_BASE, REQ_HEADER_DFF_CONTEXT_CODE, REQ_LINE_DFF_CONTEXT_CODE, REQ_DIST_DFF_CONTEXT_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, MULTIPLE_LEGAL_ENTITIES, ENABLE_APPROVER_OVERRIDE_FLAG, ALLOW_ONETIME_ADDR_FLAG FROM POR_REQ_BU_OPTIONS_ALL