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

VIEW: APPS.IGI_STP_BATCHES_V

Object Details
Object Name: IGI_STP_BATCHES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGI.IGI_STP_BATCHES_V
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


IGI_STP_BATCHES_V is a view based on IGI_STP_BATCHES view that displays batch information created on completing third party netting transactions.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER

Organization identifier
ROW_ID ROWID (10)
Row ID
BATCH_ID NUMBER
Yes Batch ID
BATCH_STATUS VARCHAR2 (30)
Batch status. One of five types listed in the IGI_LOOKUPS table
NETTING_TRX_TYPE VARCHAR2 (80) Yes Netting transaction type
BATCH_MEANING VARCHAR2 (80) Yes Batch meaning
Query Text

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


SELECT ORG_ID
,      ROW_ID
,      BATCH_ID
,      BATCH_STATUS
,      NETTING_TRX_TYPE
,      BATCH_MEANING
FROM APPS.IGI_STP_BATCHES_V;

Dependencies

[top of page]

APPS.IGI_STP_BATCHES_V references the following:

SchemaAPPS
ViewIGI_LOOKUPS
SynonymIGI_STP_BATCHES_ALL

APPS.IGI_STP_BATCHES_V is not referenced by any database object