POR_REQUISITION_LINES_ALL is the table used by Oracle Fusion to store the Requisition Line Level details. it is a child table to por_requisition_headers_all table. This post talks about the table structure, constraints and indexes of the table:
By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. Try them only when nothing else works.. kind of SOS...
POR_REQUISITION_LINES_ALL Table Structure
| COLUMN NAME | DATA TYPE | NULLABLE |
| REQUISITION_LINE_ID | NUMBER | N |
| INTERFACE_LINE_KEY | VARCHAR2(200) | Y |
| REPRICE_FLAG | VARCHAR2(4) | Y |
| WORK_ORDER_SUB_TYPE | VARCHAR2(120) | Y |
| REPRICE_FLAG | VARCHAR2(4) | Y |
| REQUISITION_HEADER_ID | NUMBER | N |
| WORK_ORDER_SUB_TYPE | VARCHAR2(120) | Y |
| LINE_NUMBER | NUMBER | N |
| REQUISITION_HEADER_ID | NUMBER | N |
| LINE_NUMBER | NUMBER | N |
| LINE_TYPE_ID | NUMBER | N |
| LINE_TYPE_ID | NUMBER | N |
| CATEGORY_ID | NUMBER | Y |
| CATEGORY_ID | NUMBER | Y |
| ITEM_DESCRIPTION | VARCHAR2(960) | N |
| UOM_CODE | VARCHAR2(12) | Y |
| ITEM_DESCRIPTION | VARCHAR2(960) | N |
| UNIT_PRICE | NUMBER | Y |
| UOM_CODE | VARCHAR2(12) | Y |
| UNIT_PRICE | NUMBER | Y |
| PRICE_VARIANCE_EXCEEDED_FLAG | VARCHAR2(4) | N |
| PRICE_VARIANCE_EXCEEDED_AMT | NUMBER | Y |
| PRICE_VARIANCE_EXCEEDED_FLAG | VARCHAR2(4) | N |
| PRICE_VARIANCE_EXCEEDED_AMT | NUMBER | Y |
| QUANTITY | NUMBER | Y |
| ITEM_ID | NUMBER | Y |
| QUANTITY | NUMBER | Y |
| ITEM_ID | NUMBER | Y |
| ITEM_REVISION | VARCHAR2(72) | Y |
| QUANTITY_DELIVERED | NUMBER | Y |
| ITEM_REVISION | VARCHAR2(72) | Y |
| QUANTITY_DELIVERED | NUMBER | Y |
| SUGGESTED_BUYER_ID | NUMBER | Y |
| ASSIGNED_BUYER_ID | NUMBER | Y |
| SUGGESTED_BUYER_ID | NUMBER | Y |
| ASSIGNED_BUYER_ID | NUMBER | Y |
| NEGOTIATION_REQUIRED_FLAG | VARCHAR2(4) | Y |
| NEED_BY_DATE | DATE | Y |
| NEGOTIATION_REQUIRED_FLAG | VARCHAR2(4) | Y |
| NEED_BY_DATE | DATE | Y |
| PO_HEADER_ID | NUMBER | Y |
| PO_HEADER_ID | NUMBER | Y |
| PO_LINE_ID | NUMBER | Y |
| PO_LINE_ID | NUMBER | Y |
| TO_HEADER_ID | NUMBER | Y |
| TO_HEADER_ID | NUMBER | Y |
| TO_LINE_ID | NUMBER | Y |
| LINE_LOCATION_ID | NUMBER | Y |
| TO_LINE_ID | NUMBER | Y |
| LINE_LOCATION_ID | NUMBER | Y |
| MODIFIED_BY_BUYER_FLAG | VARCHAR2(4) | Y |
| PARENT_REQ_LINE_ID | NUMBER | Y |
| MODIFIED_BY_BUYER_FLAG | VARCHAR2(4) | Y |
| PARENT_REQ_LINE_ID | NUMBER | Y |
| NOTE_TO_BUYER | VARCHAR2(4000) | Y |
| NOTE_TO_BUYER | VARCHAR2(4000) | Y |
| NOTE_TO_RECEIVER | VARCHAR2(4000) | Y |
| MODIFIED_BY_BUYER_ID | NUMBER | Y |
| NOTE_TO_RECEIVER | VARCHAR2(4000) | Y |
| MODIFIED_BY_BUYER_ID | NUMBER | Y |
| SOURCE_DOCUMENT_TYPE | VARCHAR2(100) | Y |
| SOURCE_DOC_HEADER_ID | NUMBER | Y |
| SOURCE_DOCUMENT_TYPE | VARCHAR2(100) | Y |
| SOURCE_DOC_HEADER_ID | NUMBER | Y |
| SOURCE_DOC_LINE_ID | NUMBER | Y |
| SOURCE_DOC_LINE_ID | NUMBER | Y |
| CURRENCY_CODE | VARCHAR2(60) | Y |
| RATE_TYPE | VARCHAR2(120) | Y |
| CURRENCY_CODE | VARCHAR2(60) | Y |
| RATE_DATE | DATE | Y |
| RATE_TYPE | VARCHAR2(120) | Y |
| RATE_DATE | DATE | Y |
| RATE | NUMBER | Y |
| CURRENCY_UNIT_PRICE | NUMBER | Y |
| RATE | NUMBER | Y |
| CURRENCY_UNIT_PRICE | NUMBER | Y |
| SUGGESTED_VENDOR_NAME | VARCHAR2(1440) | Y |
| SUGGESTED_VENDOR_NAME | VARCHAR2(1440) | Y |
| SUGGESTED_VENDOR_SITE | VARCHAR2(960) | Y |
| SUGGESTED_VENDOR_CONTACT | VARCHAR2(320) | Y |
| SUGGESTED_VENDOR_SITE | VARCHAR2(960) | Y |
| SUGGESTED_VENDOR_CONTACT_PHONE | VARCHAR2(120) | Y |
| SUGGESTED_VENDOR_CONTACT | VARCHAR2(320) | Y |
| SUGGESTED_VENDOR_CONTACT_FAX | VARCHAR2(120) | Y |
| SUGGESTED_VENDOR_CONTACT_PHONE | VARCHAR2(120) | Y |
| SUGGESTED_VENDOR_CONTACT_FAX | VARCHAR2(120) | Y |
| SUGGESTED_VENDOR_CONTACT_EMAIL | VARCHAR2(4000) | Y |
| SUGGESTED_SUPPLIER_ITEM_NUMBER | VARCHAR2(1200) | Y |
| SUGGESTED_VENDOR_CONTACT_EMAIL | VARCHAR2(4000) | Y |
| UN_NUMBER_ID | NUMBER | Y |
| SUGGESTED_SUPPLIER_ITEM_NUMBER | VARCHAR2(1200) | Y |
| HAZARD_CLASS_ID | NUMBER | Y |
| UN_NUMBER_ID | NUMBER | Y |
| HAZARD_CLASS_ID | NUMBER | Y |
| URGENT_FLAG | VARCHAR2(4) | Y |
| CANCEL_FLAG | VARCHAR2(4) | Y |
| URGENT_FLAG | VARCHAR2(4) | Y |
| DESTINATION_TYPE_CODE | VARCHAR2(100) | Y |
| CANCEL_FLAG | VARCHAR2(4) | Y |
| DESTINATION_ORGANIZATION_ID | NUMBER | Y |
| DESTINATION_TYPE_CODE | VARCHAR2(100) | Y |
| DESTINATION_ORGANIZATION_ID | NUMBER | Y |
| DESTINATION_SUBINVENTORY | VARCHAR2(40) | Y |
| DELIVER_TO_LOCATION_ID | NUMBER | Y |
| DESTINATION_SUBINVENTORY | VARCHAR2(40) | Y |
| DELIVER_TO_LOCATION_ID | NUMBER | Y |
| ONE_TIME_LOCATION_FLAG | VARCHAR2(4) | Y |
| REQUESTER_ID | NUMBER | Y |
| ONE_TIME_LOCATION_FLAG | VARCHAR2(4) | Y |
| QUANTITY_CANCELLED | NUMBER | Y |
| REQUESTER_ID | NUMBER | Y |
| CANCEL_DATE | DATE | Y |
| QUANTITY_CANCELLED | NUMBER | Y |
| CANCEL_DATE | DATE | Y |
| CANCEL_REASON | VARCHAR2(960) | Y |
| VENDOR_ID | NUMBER | Y |
| CANCEL_REASON | VARCHAR2(960) | Y |
| VENDOR_ID | NUMBER | Y |
| VENDOR_SITE_ID | NUMBER | Y |
| VENDOR_CONTACT_ID | NUMBER | Y |
| VENDOR_SITE_ID | NUMBER | Y |
| QUANTITY_RECEIVED | NUMBER | Y |
| VENDOR_CONTACT_ID | NUMBER | Y |
| REQ_BU_ID | NUMBER | N |
| QUANTITY_RECEIVED | NUMBER | Y |
| REQ_BU_ID | NUMBER | N |
| PRC_BU_ID | NUMBER | Y |
| CONTENT_PRC_BU_ID | NUMBER | Y |
| PRC_BU_ID | NUMBER | Y |
| CONTENT_PRC_BU_ID | NUMBER | Y |
| ITEM_SOURCE | VARCHAR2(100) | Y |
| PUNCHOUT_CATALOG_ID | NUMBER | Y |
| ITEM_SOURCE | VARCHAR2(100) | Y |
| PUBLIC_LIST_ID | NUMBER | Y |
| PUNCHOUT_CATALOG_ID | NUMBER | Y |
| PUBLIC_LIST_ID | NUMBER | Y |
| SMART_FORM_ID | NUMBER | Y |
| SMART_FORM_ID | NUMBER | Y |
| MANUFACTURER_NAME | VARCHAR2(960) | Y |
| MANUFACTURER_PART_NUMBER | VARCHAR2(2800) | Y |
| MANUFACTURER_NAME | VARCHAR2(960) | Y |
| MANUFACTURER_PART_NUMBER | VARCHAR2(2800) | Y |
| UNSPSC_CODE | VARCHAR2(2800) | Y |
| SUPPLIER_DUNS | VARCHAR2(240) | Y |
| UNSPSC_CODE | VARCHAR2(2800) | Y |
| SUPPLIER_DUNS | VARCHAR2(240) | Y |
| PCARD_FLAG | VARCHAR2(4) | Y |
| NEW_SUPPLIER_FLAG | VARCHAR2(4) | Y |
| PCARD_FLAG | VARCHAR2(4) | Y |
| NEW_SUPPLIER_FLAG | VARCHAR2(4) | Y |
| NOTE_TO_SUPPLIER | VARCHAR2(4000) | Y |
| NOTE_TO_SUPPLIER | VARCHAR2(4000) | Y |
| SUPPLIER_REF_NUMBER | VARCHAR2(600) | Y |
| SECONDARY_UOM_CODE | VARCHAR2(12) | Y |
| SUPPLIER_REF_NUMBER | VARCHAR2(600) | Y |
| SECONDARY_QUANTITY | NUMBER | Y |
| SECONDARY_UOM_CODE | VARCHAR2(12) | Y |
| SECONDARY_QUANTITY | NUMBER | Y |
| SECONDARY_QUANTITY_RECEIVED | NUMBER | Y |
| SECONDARY_QUANTITY_CANCELLED | NUMBER | Y |
| SECONDARY_QUANTITY_RECEIVED | NUMBER | Y |
| SECONDARY_QUANTITY_CANCELLED | NUMBER | Y |
| INFO_TEMPLATE_TOUCHED_FLAG | VARCHAR2(4) | Y |
| INFO_TEMPLATE_TOUCHED_FLAG | VARCHAR2(4) | Y |
| ON_RFQ_FLAG | VARCHAR2(4) | Y |
| AUCTION_HEADER_ID | NUMBER | Y |
| ON_RFQ_FLAG | VARCHAR2(4) | Y |
| AUCTION_HEADER_ID | NUMBER | Y |
| AUCTION_DISPLAY_NUMBER | VARCHAR2(160) | Y |
| AUCTION_LINE_NUMBER | NUMBER | Y |
| AUCTION_DISPLAY_NUMBER | VARCHAR2(160) | Y |
| AUCTION_LINE_NUMBER | NUMBER | Y |
| REQS_IN_POOL_FLAG | VARCHAR2(4) | Y |
| BID_NUMBER | NUMBER | Y |
| REQS_IN_POOL_FLAG | VARCHAR2(4) | Y |
| BID_LINE_NUMBER | NUMBER | Y |
| BID_NUMBER | NUMBER | Y |
| BID_LINE_NUMBER | NUMBER | Y |
| AT_SOURCING_FLAG | VARCHAR2(4) | Y |
| AMOUNT | NUMBER | Y |
| AT_SOURCING_FLAG | VARCHAR2(4) | Y |
| AMOUNT | NUMBER | Y |
| CURRENCY_AMOUNT | NUMBER | Y |
| CURRENCY_AMOUNT | NUMBER | Y |
| ITEM_USER_OVERRIDE_FLAG | VARCHAR2(4) | Y |
| BPA_PRICE_USER_OVERRIDE_FLAG | VARCHAR2(4) | Y |
| ITEM_USER_OVERRIDE_FLAG | VARCHAR2(4) | Y |
| ORDER_TYPE_LOOKUP_CODE | VARCHAR2(100) | N |
| BPA_PRICE_USER_OVERRIDE_FLAG | VARCHAR2(4) | Y |
| ORDER_TYPE_LOOKUP_CODE | VARCHAR2(100) | N |
| PURCHASE_BASIS | VARCHAR2(120) | N |
| MATCHING_BASIS | VARCHAR2(120) | N |
| PURCHASE_BASIS | VARCHAR2(120) | N |
| MATCHING_BASIS | VARCHAR2(120) | N |
| NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2(4) | Y |
| NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2(4) | Y |
| REQTOPO_AUTOMATION_FAILED | VARCHAR2(4) | Y |
| REQTOPO_AUTO_FAILED_REASON | VARCHAR2(120) | Y |
| REQTOPO_AUTOMATION_FAILED | VARCHAR2(4) | Y |
| REQTOPO_AUTO_FAILED_REASON | VARCHAR2(120) | Y |
| DEFAULT_TAXATION_COUNTRY | VARCHAR2(8) | Y |
| DEFAULT_TAXATION_COUNTRY | VARCHAR2(8) | Y |
| DOCUMENT_SUB_TYPE | VARCHAR2(960) | Y |
| DOCUMENT_SUB_TYPE | VARCHAR2(960) | Y |
| TRX_BUSINESS_CATEGORY | VARCHAR2(960) | Y |
| TRX_BUSINESS_CATEGORY | VARCHAR2(960) | Y |
| USER_DEFINED_FISC_CLASS | VARCHAR2(960) | Y |
| TAX_CLASSIFICATION_CODE | VARCHAR2(200) | Y |
| USER_DEFINED_FISC_CLASS | VARCHAR2(960) | Y |
| TAX_CLASSIFICATION_CODE | VARCHAR2(200) | Y |
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2(960) | Y |
| PRODUCT_FISC_CLASSIFICATION_ID | NUMBER | Y |
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2(960) | Y |
| PRODUCT_FISC_CLASSIFICATION_ID | NUMBER | Y |
| LINE_INTENDED_USE | VARCHAR2(960) | Y |
| LINE_INTENDED_USE_ID | NUMBER | Y |
| LINE_INTENDED_USE | VARCHAR2(960) | Y |
| LINE_INTENDED_USE_ID | NUMBER | Y |
| PRODUCT_TYPE | VARCHAR2(960) | Y |
| PRODUCT_CATEGORY | VARCHAR2(960) | Y |
| PRODUCT_TYPE | VARCHAR2(960) | Y |
| ASSESSABLE_VALUE | NUMBER | Y |
| PRODUCT_CATEGORY | VARCHAR2(960) | Y |
| ASSESSABLE_VALUE | NUMBER | Y |
| TAX_ATTR_USER_OVERRIDE_FLAG | VARCHAR2(4) | Y |
| BUYER_PROCESSING_FLAG | VARCHAR2(4) | Y |
| TAX_ATTR_USER_OVERRIDE_FLAG | VARCHAR2(4) | Y |
| LINE_GROUP | VARCHAR2(120) | Y |
| BUYER_PROCESSING_FLAG | VARCHAR2(4) | Y |
| LINE_STATUS | VARCHAR2(100) | Y |
| LINE_GROUP | VARCHAR2(120) | Y |
| LINE_STATUS | VARCHAR2(100) | Y |
| FUNDS_STATUS | VARCHAR2(120) | Y |
| LAST_SUBMITTED_DATE | TIMESTAMP(6) | Y |
| FUNDS_STATUS | VARCHAR2(120) | Y |
| LAST_APPROVAL_DATE | TIMESTAMP(6) | Y |
| LAST_SUBMITTED_DATE | TIMESTAMP(6) | Y |
| LAST_APPROVAL_DATE | TIMESTAMP(6) | Y |
| ATTRIBUTE_CATEGORY | VARCHAR2(120) | Y |
| ATTRIBUTE_CATEGORY | VARCHAR2(120) | Y |
| ATTRIBUTE1 – ATTRIBUTE20 | VARCHAR2(600) | Y |
| ATTRIBUTE_DATE1 – ATTRIBUTE_DATE10 | DATE | Y |
| ATTRIBUTE_TIMESTAMP1 – ATTRIBUTE_TIMESTAMP10 | TIMESTAMP(6) | Y |
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP(6) | Y |
| ATTRIBUTE_NUMBER1 – ATTRIBUTE_NUMBER10 | NUMBER | Y |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2(120) | Y |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2(120) | Y |
| GLOBAL_ATTRIBUTE1 – GLOBAL_ATTRIBUTE20 | VARCHAR2(600) | Y |
| CREATION_DATE | TIMESTAMP(6) | N |
| CREATED_BY | VARCHAR2(256) | N |
| CREATION_DATE | TIMESTAMP(6) | N |
| LAST_UPDATED_BY | VARCHAR2(256) | N |
| LAST_UPDATE_DATE | TIMESTAMP(6) | N |
| LAST_UPDATED_BY | VARCHAR2(256) | N |
| LAST_UPDATE_DATE | TIMESTAMP(6) | N |
| LAST_UPDATE_LOGIN | VARCHAR2(128) | Y |
| REQUEST_ID | NUMBER | Y |
| LAST_UPDATE_LOGIN | VARCHAR2(128) | Y |
| REQUEST_ID | NUMBER | Y |
| JOB_DEFINITION_NAME | VARCHAR2(400) | Y |
| JOB_DEFINITION_PACKAGE | VARCHAR2(3600) | Y |
| JOB_DEFINITION_NAME | VARCHAR2(400) | Y |
| OBJECT_VERSION_NUMBER | NUMBER | N |
| JOB_DEFINITION_PACKAGE | VARCHAR2(3600) | Y |
| OBJECT_VERSION_NUMBER | NUMBER | N |
| REQ_PO_INSTANCE_ID | NUMBER | Y |
| REQ_PO_INSTANCE_ID | NUMBER | Y |
| CONFIGURED_ITEM_FLAG | VARCHAR2(4) | Y |
| BASE_MODEL_ID | NUMBER | Y |
| CONFIGURED_ITEM_FLAG | VARCHAR2(4) | Y |
| BASE_MODEL_ID | NUMBER | Y |
| BASE_MODEL_PRICE | NUMBER | Y |
| BASE_MODEL_PRICE | NUMBER | Y |
| OPTIONS_PRICE | NUMBER | Y |
| OPTIONS_PRICE | NUMBER | Y |
| BACK_TO_BACK_FLAG | VARCHAR2(4) | Y |
| CARRIER_ID | NUMBER | Y |
| BACK_TO_BACK_FLAG | VARCHAR2(4) | Y |
| CARRIER_ID | NUMBER | Y |
| MODE_OF_TRANSPORT | VARCHAR2(120) | Y |
| MODE_OF_TRANSPORT | VARCHAR2(120) | Y |
| SERVICE_LEVEL | VARCHAR2(120) | Y |
| CUSTOMER_ITEM | VARCHAR2(100) | Y |
| SERVICE_LEVEL | VARCHAR2(120) | Y |
| CUSTOMER_ITEM | VARCHAR2(100) | Y |
| CUSTOMER_ITEM_DESC | VARCHAR2(960) | Y |
| CUSTOMER_PO_NUMBER | VARCHAR2(200) | Y |
| CUSTOMER_ITEM_DESC | VARCHAR2(960) | Y |
| CUSTOMER_PO_LINE_NUMBER | VARCHAR2(200) | Y |
| CUSTOMER_PO_NUMBER | VARCHAR2(200) | Y |
| CUSTOMER_PO_LINE_NUMBER | VARCHAR2(200) | Y |
| CUSTOMER_PO_SCHEDULE_NUMBER | VARCHAR2(200) | Y |
| DELIVER_TO_CUST_ID | NUMBER | Y |
| CUSTOMER_PO_SCHEDULE_NUMBER | VARCHAR2(200) | Y |
| DELIVER_TO_CUST_CONTACT_ID | NUMBER | Y |
| DELIVER_TO_CUST_ID | NUMBER | Y |
| DELIVER_TO_CUST_CONTACT_ID | NUMBER | Y |
| DELIVER_TO_CUST_LOCATION_ID | NUMBER | Y |
| DAYS_EARLY_RECEIPT_ALLOWED | NUMBER | Y |
| DELIVER_TO_CUST_LOCATION_ID | NUMBER | Y |
| DAYS_EARLY_RECEIPT_ALLOWED | NUMBER | Y |
| DAYS_LATE_RECEIPT_ALLOWED | NUMBER | Y |
| DAYS_LATE_RECEIPT_ALLOWED | NUMBER | Y |
| QTY_RCV_TOLERANCE | NUMBER | Y |
| REQUESTED_SHIP_DATE | DATE | Y |
| QTY_RCV_TOLERANCE | NUMBER | Y |
| REQUESTED_SHIP_DATE | DATE | Y |
| SALES_ORDER_NUMBER | VARCHAR2(200) | Y |
| SALES_ORDER_LINE_NUMBER | VARCHAR2(200) | Y |
| SALES_ORDER_NUMBER | VARCHAR2(200) | Y |
| SALES_ORDER_LINE_NUMBER | VARCHAR2(200) | Y |
| SALES_ORDER_SCHEDULE_NUMBER | VARCHAR2(200) | Y |
| SHIP_TO_CUST_ID | NUMBER | Y |
| SALES_ORDER_SCHEDULE_NUMBER | VARCHAR2(200) | Y |
| SHIP_TO_CUST_CONTACT_ID | NUMBER | Y |
| SHIP_TO_CUST_ID | NUMBER | Y |
| SHIP_TO_CUST_CONTACT_ID | NUMBER | Y |
| SHIP_TO_CUST_LOCATION_ID | NUMBER | Y |
| SHIP_TO_CUST_LOCATION_ID | NUMBER | Y |
| SOURCE_ORGANIZATION_ID | NUMBER | Y |
| SOURCE_ORGANIZATION_ID | NUMBER | Y |
| SOURCE_SUBINVENTORY | VARCHAR2(40) | Y |
| SOURCE_TYPE_CODE | VARCHAR2(40) | N |
| SOURCE_SUBINVENTORY | VARCHAR2(40) | Y |
| FIRST_PTY_REG_ID | NUMBER | Y |
| SOURCE_TYPE_CODE | VARCHAR2(40) | N |
| FIRST_PTY_REG_ID | NUMBER | Y |
| THIRD_PTY_REG_ID | NUMBER | Y |
| FINAL_DISCHARGE_LOCATION_ID | NUMBER | Y |
| THIRD_PTY_REG_ID | NUMBER | Y |
| FINAL_DISCHARGE_LOCATION_ID | NUMBER | Y |
| ORIGINAL_SUBMITTED_DATE | TIMESTAMP(6) | Y |
| ORIGINAL_APPROVAL_DATE | TIMESTAMP(6) | Y |
| ORIGINAL_SUBMITTED_DATE | TIMESTAMP(6) | Y |
| REINSTATE_LINE_LOCATION_ID | NUMBER | Y |
| ORIGINAL_APPROVAL_DATE | TIMESTAMP(6) | Y |
| REINSTATE_LINE_LOCATION_ID | NUMBER | Y |
| WORK_ORDER_PRODUCT | VARCHAR2(1200) | Y |
| WORK_ORDER_PRODUCT | VARCHAR2(1200) | Y |
| WORK_ORDER_NUMBER | VARCHAR2(480) | Y |
| WORK_ORDER_ID | NUMBER | Y |
| WORK_ORDER_NUMBER | VARCHAR2(480) | Y |
| WORK_ORDER_ID | NUMBER | Y |
| WORK_ORDER_OPERATION_SEQ | NUMBER | Y |
| WORK_ORDER_OPERATION_ID | NUMBER | Y |
| WORK_ORDER_OPERATION_SEQ | NUMBER | Y |
| WORK_ORDER_OPERATION_ID | NUMBER | Y |
| ORCHESTRATION_CODE | VARCHAR2(80) | Y |
| REQUESTER_SUPERVISOR_LEVEL1 | NUMBER | Y |
| ORCHESTRATION_CODE | VARCHAR2(80) | Y |
| REQUESTER_SUPERVISOR_LEVEL1 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL2 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL2 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL3 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL3 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL4 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL4 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL5 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL5 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL6 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL6 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL7 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL7 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL8 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL8 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL9 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL10 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL9 | NUMBER | Y |
| REQUESTER_SUPERVISOR_LEVEL10 | NUMBER | Y |
| EXTERNAL_UOM_VALUE | VARCHAR2(1440) | Y |
| EXTERNAL_UOM_VALUE | VARCHAR2(1440) | Y |
| EXTERNAL_UOM_QUANTITY | VARCHAR2(200) | Y |
| EXTERNAL_CATEGORY_VALUE | VARCHAR2(1440) | Y |
| EXTERNAL_UOM_QUANTITY | VARCHAR2(200) | Y |
| EXTERNAL_CATEGORY_VALUE | VARCHAR2(1440) | Y |
| INTERFACE_LINE_KEY | VARCHAR2(200) | Y |
| DISABLE_AUTOSOURCING_FLAG | VARCHAR2(4) | Y |
POR_REQUISITION_LINES_ALL Indexes
index type N denotes the Normal index while F denotes the Function Based index.
| INDEX_NAME | INDEX_TYPE | Unique? | COLUMN_NAME |
| POR_REQUISITION_LINES_N1 | N | N | LINE_LOCATION_ID |
| POR_REQUISITION_LINES_N10 | N | N | DELIVER_TO_LOCATION_ID |
| POR_REQUISITION_LINES_N11 | N | N | SUGGESTED_SUPPLIER_ITEM_NUMBER |
| POR_REQUISITION_LINES_N12 | N | N | CREATION_DATE |
| POR_REQUISITION_LINES_N12 | N | N | SUGGESTED_BUYER_ID |
| POR_REQUISITION_LINES_N13 | N | N | AUCTION_HEADER_ID |
| POR_REQUISITION_LINES_N13 | N | N | AUCTION_LINE_NUMBER |
| POR_REQUISITION_LINES_N14 | N | N | LAST_UPDATE_DATE |
| POR_REQUISITION_LINES_N15 | N | N | VENDOR_SITE_ID |
| POR_REQUISITION_LINES_N15 | N | N | VENDOR_ID |
| POR_REQUISITION_LINES_N16 | N | N | REQS_IN_POOL_FLAG |
| POR_REQUISITION_LINES_N16 | N | N | SUGGESTED_BUYER_ID |
| POR_REQUISITION_LINES_N17 | N | N | AUCTION_DISPLAY_NUMBER |
| POR_REQUISITION_LINES_N17 | N | N | PRC_BU_ID |
| POR_REQUISITION_LINES_N17 | N | N | SUGGESTED_BUYER_ID |
| POR_REQUISITION_LINES_N18 | N | N | PRC_BU_ID |
| POR_REQUISITION_LINES_N18 | N | N | REQS_IN_POOL_FLAG |
| POR_REQUISITION_LINES_N18 | N | N | DESTINATION_TYPE_CODE |
| POR_REQUISITION_LINES_N19 | N | N | REQ_BU_ID |
| POR_REQUISITION_LINES_N2 | N | N | CATEGORY_ID |
| POR_REQUISITION_LINES_N20 | N | N | PO_LINE_ID |
| POR_REQUISITION_LINES_N21 | N | N | PARENT_REQ_LINE_ID |
| POR_REQUISITION_LINES_N22 | N | N | PO_HEADER_ID |
| POR_REQUISITION_LINES_N23 | N | N | REQS_IN_POOL_FLAG |
| POR_REQUISITION_LINES_N23 | N | N | ASSIGNED_BUYER_ID |
| POR_REQUISITION_LINES_N24 | N | N | ASSIGNED_BUYER_ID |
| POR_REQUISITION_LINES_N24 | N | N | LINE_LOCATION_ID |
| POR_REQUISITION_LINES_N24 | N | N | PRC_BU_ID |
| POR_REQUISITION_LINES_N25 | N | N | CREATION_DATE |
| POR_REQUISITION_LINES_N25 | N | N | ASSIGNED_BUYER_ID |
| POR_REQUISITION_LINES_N26 | N | N | AUCTION_DISPLAY_NUMBER |
| POR_REQUISITION_LINES_N26 | N | N | PRC_BU_ID |
| POR_REQUISITION_LINES_N26 | N | N | ASSIGNED_BUYER_ID |
| POR_REQUISITION_LINES_N27 | N | N | TO_HEADER_ID |
| POR_REQUISITION_LINES_N28 | N | N | TO_LINE_ID |
| POR_REQUISITION_LINES_N29 | N | N | REQ_PO_INSTANCE_ID |
| POR_REQUISITION_LINES_N3 | N | N | NEED_BY_DATE |
| POR_REQUISITION_LINES_N30 | N | N | WORK_ORDER_ID |
| POR_REQUISITION_LINES_N30 | N | N | WORK_ORDER_OPERATION_ID |
| POR_REQUISITION_LINES_N30 | N | N | ORCHESTRATION_CODE |
| POR_REQUISITION_LINES_N31 | N | N | VENDOR_ID |
| POR_REQUISITION_LINES_N31 | N | N | REQ_BU_ID |
| POR_REQUISITION_LINES_N31 | N | N | REQUISITION_HEADER_ID |
| POR_REQUISITION_LINES_N32 | N | N | INTERFACE_LINE_KEY |
| POR_REQUISITION_LINES_N4 | N | N | REQUESTER_ID |
| POR_REQUISITION_LINES_N5 | N | N | SUGGESTED_VENDOR_NAME |
| POR_REQUISITION_LINES_N6 | N | N | SUGGESTED_BUYER_ID |
| POR_REQUISITION_LINES_N6 | N | N | LINE_LOCATION_ID |
| POR_REQUISITION_LINES_N6 | N | N | PRC_BU_ID |
| POR_REQUISITION_LINES_N7 | N | N | ITEM_ID |
| POR_REQUISITION_LINES_N7 | N | N | REQ_BU_ID |
| POR_REQUISITION_LINES_N7 | N | N | REQUISITION_HEADER_ID |
| POR_REQUISITION_LINES_N8 | N | N | SOURCE_DOC_HEADER_ID |
| POR_REQUISITION_LINES_N9 | N | N | DESTINATION_ORGANIZATION_ID |
| POR_REQUISITION_LINES_U1 | N | Y | REQUISITION_LINE_ID |
| POR_REQUISITION_LINES_U2 | N | Y | REQUISITION_HEADER_ID |
| POR_REQUISITION_LINES_U2 | N | Y | LINE_NUMBER |
Related Posts
Purchase Order Detail Query in Fusion
POR_REQUISITION_HEADERS_ALL: Columns & Indexes
PO_HEADERS_ALL: PO Table Columns & Indexes
Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.
Reference:
support.oracle.com
Check out the Amazon Deals of the day based on your interests..
1 thought on “POR_REQUISITION_LINES_ALL: Columns & Index”
Comments are closed.