[Home] [Help] [Dependency Information]
Object Name: | PN_VAR_SUMM_DET_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REFERENCE_NUM | NUMBER | |||
RENT_NUM | VARCHAR2 | (30) | ||
VAR_RENT_ID | NUMBER | |||
PARENT | VARCHAR2 | (80) | ||
LEASE_STATUS | VARCHAR2 | (30) | ||
PRORATION_RULE | VARCHAR2 | (30) | ||
LEASE_TYPE | VARCHAR2 | (30) | ||
LEASE_CLASS | VARCHAR2 | (30) | ||
ACT_INV_DATE | DATE | |||
INV_DATE | DATE | |||
INV_START_DATE | DATE | |||
INV_END_DATE | DATE | |||
ACT_AMOUNT | NUMBER | |||
METHOD | VARCHAR2 | (14) | ||
BILLING_FREQ | VARCHAR2 | (30) | ||
REPORTING_FREQUENCY | VARCHAR2 | (30) | ||
LEASE_NAME | VARCHAR2 | (50) | ||
LEASE_NUMBER | VARCHAR2 | (30) | ||
LEASE_ID | NUMBER | |||
BILL_STATUS | VARCHAR2 | (26) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
PERIOD_ID | NUMBER | |||
ABSTRACTED_BY_USER | NUMBER | |||
INCL_PRD | VARCHAR2 | (4000) | ||
LOCATION_CODE | VARCHAR2 | (90) | ||
LOCATION_ID | NUMBER | |||
PROPERTY_CODE | VARCHAR2 | (90) | ||
PROPERTY_NAME | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT REFERENCE_NUM
, RENT_NUM
, VAR_RENT_ID
, PARENT
, LEASE_STATUS
, PRORATION_RULE
, LEASE_TYPE
, LEASE_CLASS
, ACT_INV_DATE
, INV_DATE
, INV_START_DATE
, INV_END_DATE
, ACT_AMOUNT
, METHOD
, BILLING_FREQ
, REPORTING_FREQUENCY
, LEASE_NAME
, LEASE_NUMBER
, LEASE_ID
, BILL_STATUS
, START_DATE
, END_DATE
, PERIOD_ID
, ABSTRACTED_BY_USER
, INCL_PRD
, LOCATION_CODE
, LOCATION_ID
, PROPERTY_CODE
, PROPERTY_NAME
FROM APPS.PN_VAR_SUMM_DET_V;
APPS.PN_VAR_SUMM_DET_V is not referenced by any database object
|
|
|