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

VIEW: APPS.IGS_FI_LOCKBOXES_V

Object Details
Object Name: IGS_FI_LOCKBOXES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_FI_LOCKBOXES_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_NAME VARCHAR2 (30) Yes The Lockbox Name associated with the record.
LOCKBOX_DESC VARCHAR2 (240) Yes User defined description for the Lockbox.
CLOSED_FLAG VARCHAR2 (1) Yes Closed Indicator for deactivating the Lockbox.
GL_DATE_SOURCE_CODE VARCHAR2 (30) Yes Indicates GL Date Source associated to the lockbox.
GL_DATE_SOURCE_MEANING VARCHAR2 (80) Yes Indicates GL Date Source meaning associated to a user defined Lockbox.
DEFAULT_CREDIT_TYPE_ID NUMBER (15)
Default Credit Type Identifier associated to the defined Lockbox.
DEFAULT_CREDIT_TYPE_NAME VARCHAR2 (60)
Default Credit Type name.
BANK_BRANCH_ID VARCHAR2 (0)
Bank Branch Identifier.
BANK_BRANCH_NAME VARCHAR2 (0)
Bank Branch Name.
BANK_ACCOUNT_ID NUMBER (15)
No longer used
BANK_ACCOUNT_NUM VARCHAR2 (0)
Bank Account Number.
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.
Query Text

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


SELECT ROW_ID
,      LOCKBOX_NAME
,      LOCKBOX_DESC
,      CLOSED_FLAG
,      GL_DATE_SOURCE_CODE
,      GL_DATE_SOURCE_MEANING
,      DEFAULT_CREDIT_TYPE_ID
,      DEFAULT_CREDIT_TYPE_NAME
,      BANK_BRANCH_ID
,      BANK_BRANCH_NAME
,      BANK_ACCOUNT_ID
,      BANK_ACCOUNT_NUM
,      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
FROM APPS.IGS_FI_LOCKBOXES_V;

Dependencies

[top of page]

APPS.IGS_FI_LOCKBOXES_V references the following:

SchemaAPPS
ViewIGS_FI_CR_TYPES
SynonymIGS_FI_LOCKBOXES
ViewIGS_LOOKUP_VALUES

APPS.IGS_FI_LOCKBOXES_V is not referenced by any database object