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

VIEW: APPS.IGS_FI_LB_RECT_ERRS_V

Object Details
Object Name: IGS_FI_LB_RECT_ERRS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_FI_LB_RECT_ERRS_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)
Row Identifier.
LOCKBOX_RECEIPT_ERROR_ID NUMBER
Yes The Unique sequence generated identifier for the erroneous receipt record.
LOCKBOX_INTERFACE_ID NUMBER
Yes The Unique Lockbox Interface Identifier.
ITEM_NUMBER NUMBER (15) Yes The Item Number of the receipt record.
LOCKBOX_NAME VARCHAR2 (30) Yes The Lockbox Name associated with the record.
RECEIPT_AMT NUMBER
Yes The Receipt Amount.
BATCH_NAME VARCHAR2 (30)
The Lockbox batch name.
PARTY_NUMBER VARCHAR2 (30)
The party number supplied by the bank with which the receipt record is associated.
PAYER_NAME VARCHAR2 (450)
The payer name provided by the bank with which the receipt record is associated.
CHECK_CD VARCHAR2 (30)
The check number supplied by the bank for the receipt record.
DEPOSIT_DATE DATE

The Bank Supplied Lockbox Deposit Date.
CREDIT_TYPE_CD VARCHAR2 (30)
The bank supplied code for Credit Type of the receipt record.
FEE_CAL_INSTANCE_CD VARCHAR2 (30)
The bank supplied code for Fee Calendar Instance of the receipt record.
CHARGE_CD1 VARCHAR2 (60)
The Charge Number for Targeted Application.
CHARGE_CD2 VARCHAR2 (60)
The Charge Number for Targeted Application.
CHARGE_CD3 VARCHAR2 (60)
The Charge Number for Targeted Application.
CHARGE_CD4 VARCHAR2 (60)
The Charge Number for Targeted Application.
CHARGE_CD5 VARCHAR2 (60)
The Charge Number for Targeted Application.
CHARGE_CD6 VARCHAR2 (60)
The Charge Number for Targeted Application.
CHARGE_CD7 VARCHAR2 (60)
The Charge Number for Targeted Application.
CHARGE_CD8 VARCHAR2 (60)
The Charge Number for Targeted Application.
APPLIED_AMT1 NUMBER

The Amount to be applied for Targeted Application.
APPLIED_AMT2 NUMBER

The Amount to be applied for Targeted Application.
APPLIED_AMT3 NUMBER

The Amount to be applied for Targeted Application.
APPLIED_AMT4 NUMBER

The Amount to be applied for Targeted Application.
APPLIED_AMT5 NUMBER

The Amount to be applied for Targeted Application.
APPLIED_AMT6 NUMBER

The Amount to be applied for Targeted Application.
APPLIED_AMT7 NUMBER

The Amount to be applied for Targeted Application.
APPLIED_AMT8 NUMBER

The Amount to be applied for Targeted Application.
ADM_APPLICATION_ID NUMBER (15)
The Unique Admission Application identifier provided by the bank in case the inbound lockbox receipt is for a Enrollment Deposit.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield.
CREATED_BY NUMBER (15) Yes Standard Who column.
CREATION_DATE DATE
Yes Standard Who column.
LAST_UPDATE_DATE DATE
Yes Standard Who column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
REQUEST_ID NUMBER (15)
Standard Concurrent Program column.
PROGRAM_ID NUMBER (15)
Standard Concurrent Program column.
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Concurrent Program column.
PROGRAM_UPDATE_DATE DATE

Standard Concurrent Program column.
Query Text

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


SELECT ROW_ID
,      LOCKBOX_RECEIPT_ERROR_ID
,      LOCKBOX_INTERFACE_ID
,      ITEM_NUMBER
,      LOCKBOX_NAME
,      RECEIPT_AMT
,      BATCH_NAME
,      PARTY_NUMBER
,      PAYER_NAME
,      CHECK_CD
,      DEPOSIT_DATE
,      CREDIT_TYPE_CD
,      FEE_CAL_INSTANCE_CD
,      CHARGE_CD1
,      CHARGE_CD2
,      CHARGE_CD3
,      CHARGE_CD4
,      CHARGE_CD5
,      CHARGE_CD6
,      CHARGE_CD7
,      CHARGE_CD8
,      APPLIED_AMT1
,      APPLIED_AMT2
,      APPLIED_AMT3
,      APPLIED_AMT4
,      APPLIED_AMT5
,      APPLIED_AMT6
,      APPLIED_AMT7
,      APPLIED_AMT8
,      ADM_APPLICATION_ID
,      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_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.IGS_FI_LB_RECT_ERRS_V;

Dependencies

[top of page]

APPS.IGS_FI_LB_RECT_ERRS_V references the following:

SchemaAPPS
SynonymIGS_FI_LB_RECT_ERRS

APPS.IGS_FI_LB_RECT_ERRS_V is not referenced by any database object