[Home] [Help] [Dependency Information]
Object Name: | PN_OPEX_RECON_ALL# |
---|---|
Object Type: | VIEW |
Owner: | PN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECON_ID | NUMBER | Yes | ||
AGREEMENT_ID | NUMBER | Yes | ||
AGREEMENT_NAME | VARCHAR2 | (90) | ||
AGREEMENT_NUM | VARCHAR2 | (90) | ||
CAP_APPLIED_CODE | VARCHAR2 | (30) | ||
FEE_PCT | NUMBER | |||
TAXABLE_FLAG | VARCHAR2 | (1) | ||
ADMIN_FEE_FLAG | VARCHAR2 | (1) | ||
CAP_MIN_FLAG | VARCHAR2 | (1) | ||
GROSS_UP_FLAG | VARCHAR2 | (1) | ||
FY_CONSTR_APPLY_TO_CODE | VARCHAR2 | (30) | ||
FY_CONSTR_UNIT_CODE | VARCHAR2 | (30) | ||
FY_CONSTR_PRORATE_FLAG | VARCHAR2 | (1) | ||
FY_CONSTR_MAX | NUMBER | |||
FY_CONSTR_MIN | NUMBER | |||
SY_CAP_APPLY_TO_CODE | VARCHAR2 | (30) | ||
SY_CAP_LIMIT_CODE | VARCHAR2 | (30) | ||
SY_CAP_COMPARE_TO_CODE | VARCHAR2 | (30) | ||
SY_CAP_CARRY_FWD_CODE | VARCHAR2 | (30) | ||
SY_CAP_PCT | NUMBER | |||
SY_CAP_INDEX_ID | NUMBER | |||
SY_CAP_INDEX_FINDER_MONTH | NUMBER | |||
SY_MIN_LIMIT_CODE | VARCHAR2 | (30) | ||
SY_MIN_COMPARE_TO_CODE | VARCHAR2 | (30) | ||
SY_MIN_APPLY_TO_CODE | VARCHAR2 | (30) | ||
SY_MIN_CARRY_FWD_CODE | VARCHAR2 | (30) | ||
SY_MIN_PCT | NUMBER | |||
SY_MIN_INDEX_ID | NUMBER | |||
SY_MIN_INDEX_FINDER_MONTH | NUMBER | |||
STOP_TYPE_CODE | VARCHAR2 | (30) | ||
STOP_AMT | NUMBER | |||
STOP_AMT_TYPE_CODE | VARCHAR2 | (30) | ||
PRORATA_BASIS_TYPE_CODE | VARCHAR2 | (30) | ||
PERIOD_START_DT | DATE | Yes | ||
PERIOD_END_DT | DATE | Yes | ||
ST_RECV_DT | DATE | Yes | ||
ST_AMT_DUE | NUMBER | |||
RECON_PERFORM_DT | DATE | Yes | ||
RESP_PERSON_ID | NUMBER | |||
REVISION_NAME | VARCHAR2 | (50) | Yes | |
REVISION_NUMBER | NUMBER | Yes | ||
AUDIT_ST_CODE | VARCHAR2 | (30) | ||
AUDITOR | VARCHAR2 | (50) | ||
AUDITOR_TYPE | VARCHAR2 | (1) | ||
STATUS_CODE | VARCHAR2 | (30) | ||
CURRENT_FLAG | VARCHAR2 | (1) | ||
ADJ_TEN_CHARGE_ST | NUMBER | |||
ADJ_TEN_CHARGE_EXP | NUMBER | |||
ADJ_RECON_AMT_ST | NUMBER | |||
ADJ_RECON_AMT_EXP | NUMBER | |||
TEN_SHR_SUB_CAP | NUMBER | |||
TEN_SHR_AFT_CAP | NUMBER | |||
TEN_TOT_CHARGE | NUMBER | |||
SAVINGS_CREDIT | NUMBER | |||
OVERRUN_CREDIT | NUMBER | |||
PAY_TRM_AMT | NUMBER | |||
AMT_DUE_ST | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
ORG_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT RECON_ID
, AGREEMENT_ID
, AGREEMENT_NAME
, AGREEMENT_NUM
, CAP_APPLIED_CODE
, FEE_PCT
, TAXABLE_FLAG
, ADMIN_FEE_FLAG
, CAP_MIN_FLAG
, GROSS_UP_FLAG
, FY_CONSTR_APPLY_TO_CODE
, FY_CONSTR_UNIT_CODE
, FY_CONSTR_PRORATE_FLAG
, FY_CONSTR_MAX
, FY_CONSTR_MIN
, SY_CAP_APPLY_TO_CODE
, SY_CAP_LIMIT_CODE
, SY_CAP_COMPARE_TO_CODE
, SY_CAP_CARRY_FWD_CODE
, SY_CAP_PCT
, SY_CAP_INDEX_ID
, SY_CAP_INDEX_FINDER_MONTH
, SY_MIN_LIMIT_CODE
, SY_MIN_COMPARE_TO_CODE
, SY_MIN_APPLY_TO_CODE
, SY_MIN_CARRY_FWD_CODE
, SY_MIN_PCT
, SY_MIN_INDEX_ID
, SY_MIN_INDEX_FINDER_MONTH
, STOP_TYPE_CODE
, STOP_AMT
, STOP_AMT_TYPE_CODE
, PRORATA_BASIS_TYPE_CODE
, PERIOD_START_DT
, PERIOD_END_DT
, ST_RECV_DT
, ST_AMT_DUE
, RECON_PERFORM_DT
, RESP_PERSON_ID
, REVISION_NAME
, REVISION_NUMBER
, AUDIT_ST_CODE
, AUDITOR
, AUDITOR_TYPE
, STATUS_CODE
, CURRENT_FLAG
, ADJ_TEN_CHARGE_ST
, ADJ_TEN_CHARGE_EXP
, ADJ_RECON_AMT_ST
, ADJ_RECON_AMT_EXP
, TEN_SHR_SUB_CAP
, TEN_SHR_AFT_CAP
, TEN_TOT_CHARGE
, SAVINGS_CREDIT
, OVERRUN_CREDIT
, PAY_TRM_AMT
, AMT_DUE_ST
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ORG_ID
FROM PN.PN_OPEX_RECON_ALL#;
|
|
|