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

VIEW: APPS.IGS_FI_CRDT_TRNSCTNS

Object Details
Object Name: IGS_FI_CRDT_TRNSCTNS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_FI_CRDT_TRNSCTNS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Holds Credit Transactions


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15) Yes Person Identifier
SUBACCOUNT_ID NUMBER (15)
OBSOLETE. Subaccount Identifier
STATUS VARCHAR2 (15) Yes Status - CLEARED or REVERSED - System level Lookup Code
CREDIT_ACTIVITY_ID NUMBER (15) Yes Sequence generated Primary Key for this view
EFFECTIVE_DATE DATE
Yes Effective Date
CREDIT_NUMBER VARCHAR2 (60) Yes Credit Number
CREDIT_TYPE VARCHAR2 (60) Yes Credit Type
DESCRIPTION VARCHAR2 (240)
Credit Type Description
AMOUNT NUMBER
Yes Transaction Amount
Query Text

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


SELECT PERSON_ID
,      SUBACCOUNT_ID
,      STATUS
,      CREDIT_ACTIVITY_ID
,      EFFECTIVE_DATE
,      CREDIT_NUMBER
,      CREDIT_TYPE
,      DESCRIPTION
,      AMOUNT
FROM APPS.IGS_FI_CRDT_TRNSCTNS;

Dependencies

[top of page]

APPS.IGS_FI_CRDT_TRNSCTNS references the following:

SchemaAPPS
ViewIGS_FI_CREDITS
SynonymIGS_FI_CR_ACTIVITIES
ViewIGS_FI_CR_TYPES
ViewIGS_LOOKUP_VALUES
APPS.IGS_FI_CRDT_TRNSCTNS is referenced by following:

SchemaAPPS
Package BodyIGS_FI_BILL_EXTRACT - show dependent code