Select data from sap tables OIUY
Display SAP table details
OIUY1_CAT_CD - Generic Category Code in New Royalty
OIUY1_CAT_CDTX - Descriptions for the categories
OIUY1_CAT_CD_VAL - Descriptions for the codes
OIUY1_DOWNLOAD - The intermediate table for download
OIUY1_EXEC_STATD - Execution Statistics for Royalty Reporting
OIUY1_GEN_CD_VAL - Maintain Code with Effective Dated
OIUY1_REP_HIST - Reported data history
OIUY1_TXDOWNLOAD - The intermediate table for Texas download
OIUY3Y_TX_MASTER - Royalty 2.0 - TX GLO/TAMU - Master Data PPN
OIUY3Y_TX_RRC - Royalty 2.0 - TX GLO/TAMU - RRC Master PPN
OIUY3_MIG_DN - Royalty 2.0 - TX GLO/A&M - Migration - DNs
OIUY3_TX_ASUE_DT - Roy 2.0 TX - Auto Suspend Exception Detail
OIUY3_TX_ASUE_HD - Roy 2.0 TX - Auto Suspend Exception Header
OIUY3_TX_ASU_DT - Royalty 2.0 - TX GLO/TAMU - Auto Suspend Detail
OIUY3_TX_ASU_HD - Royalty 2.0 - TX GLO/TAMU - Auto Suspend Header
OIUY3_TX_BAXRF - Royalty 2.0 - TX GLO/TAU - BA Xref
OIUY3_TX_COMMENT - Royalty 2.0 - TX GLO/TAMU - Comment
OIUY3_TX_CTRL - Royalty 2.0 - TX GLO/TAMU Reporting Control Record Master
OIUY3_TX_GLO1_TH - Royalty 2.0 - TX GLO/TAMU - GLO1 Threshold
OIUY3_TX_GLO2_TH - Royalty 2.0 - TX GLO/TAMU - GLO2 Threshold
OIUY3_TX_INTSTG - Royalty 2.0 - TX GLO - Royalty Trans Interface Staging
OIUY3_TX_INTTXN - Royalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface
OIUY3_TX_LEASE - Royalty 2.0 - TX GLO - Lease Master
OIUY3_TX_MASTER - Royalty 2.0 - TX GLO/TAMU - Master Data
OIUY3_TX_OOSHST - Royalty 2.0 - TX - Out of Statute Royalty Transaction Hist
OIUY3_TX_OOSTXN - Royalty 2.0 - TX GLO - Out of Statute Royalty Transactions
OIUY3_TX_OOSWO - Royalty 2.0 - Texas GLO Out Of Statute Write Off
OIUY3_TX_OPSL - Roy 2.0 TX - OPSL Summary Data for a Run
OIUY3_TX_OWNOVR - Royalty 2.0 - TX GLO/TAMU Owner Level Reporting Override
OIUY3_TX_PDCXRF - Royalty 2.0 - TX GLO/TAMU - Production Disposition XRef
OIUY3_TX_PRDT - Royalty 2.0 - TX GLO - Royalty PRA Details
OIUY3_TX_PRDTA - Royalty 2.0 - TX GLO - Royalty PRA Details (Allocated)
OIUY3_TX_RDCXRF - Royalty 2.0 - TX GLO/TAMU - Royalty Disposition XRef
OIUY3_TX_RDXR_CT - Royalty 2.0 - TX GLO/TAMU - Royalty Disposition XRef at CT
OIUY3_TX_REJ - Royalty 2.0 - TX GLO/TAMU - Reject Codes
OIUY3_TX_REJT - Royalty 2.0 - Texas GLO - Reject Code Text
OIUY3_TX_REVSTG - Royalty 2.0 - TX GLO - Royalty Reversals (Staging)
OIUY3_TX_REVTXN - Royalty 2.0 - TX GLO - Royalty Reversals
OIUY3_TX_ROYHST - Royalty 2.0 - TX GLO - Royalty Transaction History
OIUY3_TX_ROYHSTA - Royalty 2.0 - TX GLO - Royalty Trans History (Allocated)
OIUY3_TX_ROYSTG - Royalty 2.0 - TX GLO - Royalty Transactions (Staging)
OIUY3_TX_ROYTXN - Royalty 2.0 - TX GLO - Royalty Transactions
OIUY3_TX_ROYTXNA - Royalty 2.0 - TX GLO - Royalty Transactions (Allocated)
OIUY3_TX_RPDTM - Royalty 2.0 - TX GLO/TAMU - Report Detail - Masters
OIUY3_TX_RPDTP - Royalty 2.0 - TX GLO/TAMU- Report Detail - Production
OIUY3_TX_RPDTS - Royalty 2.0 - TX GLO/TAMU- Report Detail - Summary
OIUY3_TX_RPDTS_UNIT - Royalty 2.0 - TX GLO/TAMU- Report Detail - Summary at Unit
OIUY3_TX_RPGDT - Royalty 2.0 - TX GLO/TAMU - Gas Report
OIUY3_TX_RPODT - Royalty 2.0 - TX GLO/TAMU - Oil Report
OIUY3_TX_RPSM - Royalty 2.0 - TX GLO/TAMU - Report Summary
OIUY3_TX_RRC - Royalty 2.0 - TX GLO/TAMU - RRC Master
OIUY3_TX_SOL - Royalty 2.0 - Texas GLO Statute of Limitation
OIUY3_TX_SOLEDT - Royalty 2.0 - TX GLO/TAMU SOL Exception Detail
OIUY3_TX_SOLEHD - Royalty 2.0 - TX GLO/TAMU SOL Exception Header
OIUY3_TX_UNIT - Royalty 2.0 - TX GLO - Unit Master
OIUY5_OKY_ENTITY - Roy 2.0 OK Lease Details (PPN)
OIUY5_OK_ENTITY - Roy 2.0 OK Lease Details
OIUY5_OK_PRDTA - Roy 2.0 OK PRA Details
OIUY5_OK_PROF - Roy 2.0 OK - Reporting Profile
OIUY5_OK_ROYHSTA - Roy 2.0 OK Royalty History
OIUY5_OK_ROYTXNA - Roy 2.0 OK Royalty Transactions
OIUY5_OK_RPGDT - Roy 2.0 OK Gas Report Details
OIUY5_OK_RPODT - Roy 2.0 OK Oil Report Details
OIUY6Y_WY_MASTER - Royalty 2.0 - WY - Master Data PPN
OIUY6_MIG_DN - Royalty 2.0 - WY - Migration - DNs
OIUY6_WY_ASUE_DT - Roy 2.0 WY - Auto Suspend Exception Detail
OIUY6_WY_ASUE_HD - Roy 2.0 WY - Auto Suspend Exception Header
OIUY6_WY_ASU_DT - Royalty 2.0 - WY - Auto Suspend Detail
OIUY6_WY_ASU_HD - Royalty 2.0 - WY - Auto Suspend Header
OIUY6_WY_CAPOVR - Roy 2.0 - Wyoming - CA Percent Override
OIUY6_WY_CBMOVR - Royalty 2.0 - WY - Coal Bed Methane Override
OIUY6_WY_INTSTG - Royalty 2.0 - WY - Royalty Transaction Interface (Staging)
OIUY6_WY_INTTXN - Royalty 2.0 - WY - Royalty Transaction Interface
OIUY6_WY_LEASE - Royalty 2.0 - WY - Lease Data
OIUY6_WY_MASTER - Royalty 2.0 - WY - Master Data
OIUY6_WY_MKTXRF - Royalty 2.0 - WY - Marketing Type Xref
OIUY6_WY_OOSHST - Royalty 2.0 - WY - Out of Statute Royalty Transaction Hist
OIUY6_WY_OOSTXN - Royalty 2.0 - WY - Out of Statute Royalty Transactions
OIUY6_WY_OOSWO - Royalty 2.0 - Wyoming Out Of Statute Write Off
OIUY6_WY_OPSL - Roy 2.0 WY - OPSL Summary Data for a Run
OIUY6_WY_PDCXRF - Royalty 2.0 - WY - Product Code Xref
OIUY6_WY_PRDT - Royalty 2.0 - WY - Royalty PRA Details
OIUY6_WY_PRDTA - Royalty 2.0 - WY - Royalty PRA Details (Allocated)
OIUY6_WY_PRICE - Royalty 2.0 - WY - Report Pricing
OIUY6_WY_REJ - Royalty 2.0 - WY - Reject Codes
OIUY6_WY_REJT - Royalty 2.0 - WY - Reject Code Text
OIUY6_WY_REVSTG - Royalty 2.0 - WY - Royalty Reversals (Staging)
OIUY6_WY_REVTXN - Royalty 2.0 - WY - Royalty Reversals
OIUY6_WY_ROYHST - Royalty 2.0 - WY - Royalty Transaction History
OIUY6_WY_ROYHSTA - Royalty 2.0 - WY - Royalty Transaction History (Allocated)
OIUY6_WY_ROYSTG - Royalty 2.0 - WY - Royalty Transactions (Staging)
OIUY6_WY_ROYTXN - Royalty 2.0 - WY - Royalty Transactions
OIUY6_WY_ROYTXNA - Royalty 2.0 - WY - Royalty Transactions (Allocated)
OIUY6_WY_RPDTC - Royalty 2.0 - WY - Lease/Unit Report Detail - CA
OIUY6_WY_RPDTD - Royalty 2.0 - WY - Report Details
OIUY6_WY_RPDTL - Royalty 2.0 - WY - Report Details Lease
OIUY6_WY_RPDTM - Royalty 2.0 - WY - Lease/Unit Report Detail - Masters
OIUY6_WY_RPDTP - Royalty 2.0 - WY - Lease/Unit Report Detail - Production
OIUY6_WY_RPDTS - Royalty 2.0 - WY - Lease/Unit Report Detail - PR/CA Summar
OIUY6_WY_RPDTU - Royalty 2.0 - WY - Report Details Unit
OIUY6_WY_SOL - Royalty 2.0 - Wyoming Statute of Limitation
OIUY6_WY_SOLEDT - Royalty 2.0 - WY Statute of Limitation Exception Detail
OIUY6_WY_SOLEHD - Royalty 2.0 - WY Statute of Limitation Exception Header
OIUY6_WY_VTCD - Royalty 2.0 - WY - Volume Type Codes for Alt Prod Vol Calc
OIUY6_WY_ZVOL - Royalty 2.0 - WY - Zero Volume Master
OIUY8_NMY_ENTITY - Roy 2.0 NM PUN/Lease Details (PPN)
OIUY8_NM_ENTITY - Roy 2.0 NM PUN/Lease Details
OIUY8_NM_PRDTA - Roy 2.0 NM PRA Details
OIUY8_NM_PROF - Roy 2.0 NM - Reporting Profile
OIUY8_NM_ROYHSTA - Roy 2.0 NM Royalty History
OIUY8_NM_ROYTXNA - Roy 2.0 NM Royalty Transactions
OIUY8_NM_RPDT - Roy 2.0 NM - Report Details
OIUY9_LAY_ENTITY - Roy 2.0 LA LUW/Lease Details (PPN)
OIUY9_LAY_MASTER - Roy 2.0 LA Master Data PPN
OIUY9_LA_ENTITY - Roy 2.0 LA LUW/Lease Details
OIUY9_LA_MASTER - Roy 2.0 LA Master Data Details
OIUY9_LA_PRDTA - Roy 2.0 LA PRA Details
OIUY9_LA_PROF - Roy 2.0 LA - Reporting Profile
OIUY9_LA_ROYHSTA - Roy 2.0 LA Royalty History
OIUY9_LA_ROYTXNA - Roy 2.0 LA Royalty Transactions
OIUY9_LA_RPDT - Roy 2.0 LA - Report Details
OIUYA_COY_ENTITY - Colorado Generic Rep - Agency Entity (PPN)
OIUYA_COY_MASTER - Roy 2.0 CO Master Data PPN
OIUYA_CO_ENTITY - Roy 2.0 CO Entity/Lease details
OIUYA_CO_FORM7 - Roy 2.0 CO - Form 7 Data
OIUYA_CO_MASTER - Roy 2.0 CO Master Data details
OIUYA_CO_PRDTA - Roy 2.0 CO PRA Details
OIUYA_CO_ROYHSTA - Roy 2.0 CO Royalty History
OIUYA_CO_ROYTXNA - Roy 2.0 CO Royalty Transactions
OIUYA_CO_RPDT - Roy 2.0 CO Report Details
OIUYA_CO_RRST - Roy 2.0 CO - Processed FORM 7 Reports
OIUYA_CO_ZVOL - Roy 2.0 CO - Zero Volume Reporting Master
OIUYC_BA_RPTID - Royalty 2.0 - Report ID Owner Cross Reference
OIUYC_DOC_JEINTF - JE structure with PRA entity details
OIUYC_OVR_MASTER - Override master - Pass Exception data to Royalty loaders
Return Table index