Skip to content

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

TABLE: BIS.EDW_LOCAL_SYSTEM_PARAMETERS

Object Details
Object Name: EDW_LOCAL_SYSTEM_PARAMETERS
Object Type: TABLE
Owner: BIS
FND Design Data: TableBIS.EDW_LOCAL_SYSTEM_PARAMETERS
Subobject Name:
Status: VALID


Table for edw local system parameters


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RATE_TYPE VARCHAR2 (30) Yes comment
WAREHOUSE_CURRENCY_CODE VARCHAR2 (15) Yes comment
DAYS_SALES_OUTSTANDING NUMBER
Yes comment
INVOICE_SPLIT_AMOUNT NUMBER

comment
AR_BUCKET_NAME VARCHAR2 (40) Yes comment
AR_BUCKET_TYPE VARCHAR2 (30) Yes comment
AR_B0_TYPE VARCHAR2 (30) Yes comment
AR_B0_DAYS_FROM NUMBER
Yes comment
AR_B0_DAYS_TO NUMBER
Yes comment
AR_B1_TYPE VARCHAR2 (30)
comment
AR_B1_DAYS_FROM NUMBER

comment
AR_B1_DAYS_TO NUMBER

comment
AR_B2_TYPE VARCHAR2 (30)
comment
AR_B2_DAYS_FROM NUMBER

comment
AR_B2_DAYS_TO NUMBER

comment
AR_B3_TYPE VARCHAR2 (30)
comment
AR_B3_DAYS_FROM NUMBER

comment
AR_B3_DAYS_TO NUMBER

comment
AR_B4_TYPE VARCHAR2 (30)
comment
AR_B4_DAYS_FROM NUMBER

comment
AR_B4_DAYS_TO NUMBER

comment
AR_B5_TYPE VARCHAR2 (30)
comment
AR_B5_DAYS_FROM NUMBER

comment
AR_B5_DAYS_TO NUMBER

comment
AR_B6_TYPE VARCHAR2 (30)
comment
AR_B6_DAYS_FROM NUMBER

comment
AR_B6_DAYS_TO NUMBER

comment
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
EDW_LANGUAGE_CODE VARCHAR2 (240)
comment
FREEZE_FLAG VARCHAR2 (1)
comment
PERIOD_SET_NAME VARCHAR2 (15)
comment
CLASS_CATEG1 VARCHAR2 (30)
comment
CLASS_CATEG2 VARCHAR2 (30)
comment
CLASS_CATEG3 VARCHAR2 (30)
comment
CLASS_CATEG4 VARCHAR2 (30)
comment
CLASS_CATEG5 VARCHAR2 (30)
comment
CLASS_CATEG6 VARCHAR2 (30)
comment
CLASS_CATEG7 VARCHAR2 (30)
comment
INSTANCE_CODE VARCHAR2 (30)
comment
PERIOD_TYPE VARCHAR2 (15)
comment
ITEM_CATEGORY_SET1 VARCHAR2 (30)
comment
ITEM_CATEGORY_SET2 VARCHAR2 (30)
comment
ITEM_CATEGORY_SET3 VARCHAR2 (30)
comment
ITEM_ORG_CATEGORY_SET1 VARCHAR2 (30)
comment
ITM_HRCHY3_COLL_TYPE VARCHAR2 (1)
comment
ITM_HRCHY3_VBH_TOP_NODE VARCHAR2 (30)
comment
Query Text

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


SELECT RATE_TYPE
,      WAREHOUSE_CURRENCY_CODE
,      DAYS_SALES_OUTSTANDING
,      INVOICE_SPLIT_AMOUNT
,      AR_BUCKET_NAME
,      AR_BUCKET_TYPE
,      AR_B0_TYPE
,      AR_B0_DAYS_FROM
,      AR_B0_DAYS_TO
,      AR_B1_TYPE
,      AR_B1_DAYS_FROM
,      AR_B1_DAYS_TO
,      AR_B2_TYPE
,      AR_B2_DAYS_FROM
,      AR_B2_DAYS_TO
,      AR_B3_TYPE
,      AR_B3_DAYS_FROM
,      AR_B3_DAYS_TO
,      AR_B4_TYPE
,      AR_B4_DAYS_FROM
,      AR_B4_DAYS_TO
,      AR_B5_TYPE
,      AR_B5_DAYS_FROM
,      AR_B5_DAYS_TO
,      AR_B6_TYPE
,      AR_B6_DAYS_FROM
,      AR_B6_DAYS_TO
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      EDW_LANGUAGE_CODE
,      FREEZE_FLAG
,      PERIOD_SET_NAME
,      CLASS_CATEG1
,      CLASS_CATEG2
,      CLASS_CATEG3
,      CLASS_CATEG4
,      CLASS_CATEG5
,      CLASS_CATEG6
,      CLASS_CATEG7
,      INSTANCE_CODE
,      PERIOD_TYPE
,      ITEM_CATEGORY_SET1
,      ITEM_CATEGORY_SET2
,      ITEM_CATEGORY_SET3
,      ITEM_ORG_CATEGORY_SET1
,      ITM_HRCHY3_COLL_TYPE
,      ITM_HRCHY3_VBH_TOP_NODE
FROM BIS.EDW_LOCAL_SYSTEM_PARAMETERS;

Dependencies

[top of page]

BIS.EDW_LOCAL_SYSTEM_PARAMETERS does not reference any database object

BIS.EDW_LOCAL_SYSTEM_PARAMETERS is referenced by following:

SchemaAPPS
SynonymEDW_LOCAL_SYSTEM_PARAMETERS