DBA Data[Home] [Help] [Dependency Information]


TABLE: AP.OIE_POL_RATES_INTERFACE

Object Details
Object Name: OIE_POL_RATES_INTERFACE
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.OIE_POL_RATES_INTERFACE
Subobject Name:
Status: VALID


This table serves as an interface / staging table for uploaded CONUS and OCONUS rates which can be used to generate policy schedules.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OIE_POL_RATES_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOUNTRY
ColumnSTATE_PROVINCE
ColumnCOUNTY
ColumnCITY_LOCALITY
ColumnSTART_OF_SEASON
ColumnEND_OF_SEASON
ColumnEFFECTIVE_DATE
Columns
Name Datatype Length Mandatory Comments
STATE_PROVINCE VARCHAR2 (80)
Stores the location State or Province
COUNTRY VARCHAR2 (80)
Stores the location Country
CITY_LOCALITY VARCHAR2 (80)
Stores the location City or Locality
COUNTY VARCHAR2 (80)
Stores the location County
START_OF_SEASON VARCHAR2 (5)
Stores the location Start of Season
END_OF_SEASON VARCHAR2 (5)
Stores the location End of Season
MAX_LODGING_AMT NUMBER

Stores the location Max Lodging Amount
NO_GOVT_MEALS_AMT NUMBER

Stores the location Local Meals Amount
PROP_MEALS_AMT NUMBER

Stores the location Proportional Meals Amount
OFF_BASE_INC_AMT NUMBER

Stores the location Off Base Inc Amount
FOOTNOTE_AMT NUMBER

Stores the location Footnote Amount
FOOTNOTE_RATE_AMT NUMBER

Stores the location Footnote Rate Amount
MAX_PER_DIEM_AMT NUMBER

Stores the location Max Per Diem Rate Amount
EFFECTIVE_DATE VARCHAR2 (10)
Stores the location Effective Date
CREATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT STATE_PROVINCE
,      COUNTRY
,      CITY_LOCALITY
,      COUNTY
,      START_OF_SEASON
,      END_OF_SEASON
,      MAX_LODGING_AMT
,      NO_GOVT_MEALS_AMT
,      PROP_MEALS_AMT
,      OFF_BASE_INC_AMT
,      FOOTNOTE_AMT
,      FOOTNOTE_RATE_AMT
,      MAX_PER_DIEM_AMT
,      EFFECTIVE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM AP.OIE_POL_RATES_INTERFACE;

Dependencies

[top of page]

AP.OIE_POL_RATES_INTERFACE does not reference any database object

AP.OIE_POL_RATES_INTERFACE is referenced by following:

SchemaAPPS
SynonymOIE_POL_RATES_INTERFACE