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

TABLE: IGI.IGI_DUN_CUST_PROF

Object Details
Object Name: IGI_DUN_CUST_PROF
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.IGI_DUN_CUST_PROF
Subobject Name:
Status: VALID


IGI_DUN_CUST_PROF is an extended table that stores one row for each valid row in HZ_CUSTOMER_PROFILES.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGI_DUN_CUST_PROF_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_PROFILE_ID
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_PROFILE_ID NUMBER (15) Yes Identifier of customer profile
USE_DUNNING_FLAG VARCHAR2 (1) Yes Allows decision on whether dunning charges should be applied
DUNNING_CHARGE_TYPE VARCHAR2 (1) Yes Dunning Charge Type to be created, Adjustment (A), or Invoice (I). Adjustment Type will create adjustments in Receivables. Invoice Type will call AutoInvoice and create an invoice detailing the charges.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated 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_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
Query Text

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


SELECT CUSTOMER_PROFILE_ID
,      USE_DUNNING_FLAG
,      DUNNING_CHARGE_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGI.IGI_DUN_CUST_PROF;

Dependencies

[top of page]

IGI.IGI_DUN_CUST_PROF does not reference any database object

IGI.IGI_DUN_CUST_PROF is referenced by following:

SchemaAPPS
SynonymIGI_DUN_CUST_PROF