[Home] [Help] [Dependency Information]
Object Name: | OKL_OR_PAYMENT_HEADER_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_OR_PAYMENT_HEADER_UV |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
START_DATE | DATE | The beginning of the active period, one second after midnight on the date indicated. | ||
DURATION | NUMBER | (10) | The duration of the contract in months | |
RGP_LALEVL_ID | NUMBER | Yes | Primary key column. | |
RGP_LALEVL_RGD_CODE | VARCHAR2 | (30) | Yes | Rule groups code. |
DNZ_CHR_ID | NUMBER | Contract ID. Denormalized for performance. | ||
CLE_ID | NUMBER | ID of the contract line with which this rule group is associated. | ||
SERVICE_FEE_CLE_ID | VARCHAR2 | (0) | Placeholder for Service or Fee Line Identifier | |
SERVICE_FEE_NAME | VARCHAR2 | (0) | Placeholder for Service or Fee Line name | |
ASSET_CLE_ID | VARCHAR2 | (0) | Placeholder for Asset Line Identifier | |
ASSET_NUMBER | VARCHAR2 | (0) | Placeholder for Asset Number | |
ASSET_DESCRIPTION | VARCHAR2 | (0) | Placeholder for Asset Description | |
RUL_LASLH_ID | NUMBER | Yes | Rule Identifier for Rule LASLH | |
RUL_LASLS_RULE_INFO_CAT | VARCHAR2 | (90) | Yes | Rule Information Category for Rule LASLH |
RUL_LASLH_OBJECT1_ID1 | VARCHAR2 | (40) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view | |
RUL_LASLH_OBJECT1_ID2 | VARCHAR2 | (200) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view | |
RUL_LASLH_JTOT_OBJECT1_CODE | VARCHAR2 | (30) | Foreign key to JTF_OBJECTS_B. Represents view referenced by OBJECT_ID columns | |
STY_NAME | VARCHAR2 | (150) | Yes | Stream Type name |
STRUCTURE_CODE | VARCHAR2 | (450) | Structure code | |
STRUCTURE_NAME | VARCHAR2 | (4000) | Structure name | |
FREQUENCY_CODE | VARCHAR2 | (40) | Frequency code | |
FREQUENCY_NAME | VARCHAR2 | (4000) | Frequency name | |
ARREARS_YN | VARCHAR2 | (450) | Flag to indicate whether payment is in Arrears. Valid values Y and N. | |
ARREARS_YN_NAME | VARCHAR2 | (4000) | Lookup Meaning from FND Lookups. |
Cut, paste (and edit) the following text to query this object:
SELECT START_DATE
, DURATION
, RGP_LALEVL_ID
, RGP_LALEVL_RGD_CODE
, DNZ_CHR_ID
, CLE_ID
, SERVICE_FEE_CLE_ID
, SERVICE_FEE_NAME
, ASSET_CLE_ID
, ASSET_NUMBER
, ASSET_DESCRIPTION
, RUL_LASLH_ID
, RUL_LASLS_RULE_INFO_CAT
, RUL_LASLH_OBJECT1_ID1
, RUL_LASLH_OBJECT1_ID2
, RUL_LASLH_JTOT_OBJECT1_CODE
, STY_NAME
, STRUCTURE_CODE
, STRUCTURE_NAME
, FREQUENCY_CODE
, FREQUENCY_NAME
, ARREARS_YN
, ARREARS_YN_NAME
FROM APPS.OKL_OR_PAYMENT_HEADER_UV;
APPS.OKL_OR_PAYMENT_HEADER_UV is not referenced by any database object
|
|
|