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

VIEW: APPS.IGS_FI_REFUNDS_V

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

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Unique identifier for each row
REFUND_ID NUMBER (15) Yes Sequence generated primary key
VOUCHER_DATE DATE
Yes Date on which voucher was created
PERSON_ID NUMBER (15) Yes Person identifier
PAY_PERSON_ID NUMBER (15) Yes Identifier for payee
PAY_PERSON_NUMBER VARCHAR2 (30) Yes Person number of payee
FULL_NAME VARCHAR2 (450)
Full name of payee
DR_GL_CCID NUMBER (38)
General Ledger account code combination identifier
CR_GL_CCID NUMBER (38)
General Ledger account code combination identifier
DR_ACCOUNT_CD VARCHAR2 (40)
Account code
DR_ACCOUNT_DESC VARCHAR2 (60)
CR_ACCOUNT_CD VARCHAR2 (40)
Account code
CR_ACCOUNT_DESC VARCHAR2 (60)
REFUND_AMOUNT NUMBER
Yes Refund amount cannot be zero
FEE_TYPE VARCHAR2 (10) Yes Fee type identifier
FEE_CAL_TYPE VARCHAR2 (10) Yes Fee calendar identifier
FEE_CI_SEQUENCE_NUMBER NUMBER (6) Yes fee calendar instance identifier
START_DT DATE
Yes Start date of calendar instance
END_DT DATE
Yes End date of calendar instance
DESCRIPTION VARCHAR2 (60) Yes Description of calendar instance
PAYMENT_NUMBER VARCHAR2 (40)
Payment number - No longer used
PAYMENT_DATE DATE

Payment date - No longer used
PAYMENT_MODE VARCHAR2 (30)
Mode of payment i.e CHECK or EFT - No longer used
PAYMENT_MODE_DESC VARCHAR2 (0)
Description of payment mode - No longer used
SOURCE_REFUND_ID NUMBER (15)
Refund id of the reversed refund
INVOICE_ID NUMBER (15)
Invoice id of charge created for refund transaction
INVOICE_NUMBER VARCHAR2 (60)
Invoice number of charge created for refund transaction
TRANSFER_STATUS VARCHAR2 (30)
Status field for refunds process for selecting records which have not been transfered to refunds interface.The default value is TODO.
TRANSFER_STATUS_DESC VARCHAR2 (80) Yes Description of transfer status
REVERSAL_IND VARCHAR2 (1)
Mandatory if refund transaction has been reversed.
REASON VARCHAR2 (2000)
Mandatory if refund transaction has been reversed.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Descriptive Flex Field Column.
ATTRIBUTE1 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE2 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE3 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE4 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE5 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE6 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE7 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE8 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE9 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE10 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE11 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE12 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE13 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE14 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE15 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE16 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE17 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE18 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE19 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE20 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER (15)
Concurrent manager column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent manager column
PROGRAM_ID NUMBER (15)
Concurrent manager column
PROGRAM_UPDATE_DATE DATE

Concurrent manager column
GL_DATE DATE

The General Ledger Date.
REVERSAL_GL_DATE DATE

The Reversal General Ledger Date.
Query Text

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


SELECT ROW_ID
,      REFUND_ID
,      VOUCHER_DATE
,      PERSON_ID
,      PAY_PERSON_ID
,      PAY_PERSON_NUMBER
,      FULL_NAME
,      DR_GL_CCID
,      CR_GL_CCID
,      DR_ACCOUNT_CD
,      DR_ACCOUNT_DESC
,      CR_ACCOUNT_CD
,      CR_ACCOUNT_DESC
,      REFUND_AMOUNT
,      FEE_TYPE
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      START_DT
,      END_DT
,      DESCRIPTION
,      PAYMENT_NUMBER
,      PAYMENT_DATE
,      PAYMENT_MODE
,      PAYMENT_MODE_DESC
,      SOURCE_REFUND_ID
,      INVOICE_ID
,      INVOICE_NUMBER
,      TRANSFER_STATUS
,      TRANSFER_STATUS_DESC
,      REVERSAL_IND
,      REASON
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GL_DATE
,      REVERSAL_GL_DATE
FROM APPS.IGS_FI_REFUNDS_V;

Dependencies

[top of page]

APPS.IGS_FI_REFUNDS_V references the following:

SchemaAPPS
ViewIGS_CA_INST
SynonymIGS_CA_TYPE
PL/SQL PackageIGS_EN_GEN_003 - show dependent code
ViewIGS_FI_ACC
ViewIGS_FI_INV_INT
ViewIGS_FI_PARTIES_V
SynonymIGS_FI_REFUNDS
ViewIGS_LOOKUP_VALUES
APPS.IGS_FI_REFUNDS_V is referenced by following:

SchemaAPPS
Package BodyIGS_FI_PRC_REFUNDS - show dependent code