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

VIEW: APPS.IGI_STP_AP_BAL

Object Details
Object Name: IGI_STP_AP_BAL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGI.IGI_STP_AP_BAL
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_AP_BAL is a view based on a multiple organizations view IGI_STP_CANDIDATES that displays the available payables netting transactions.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER

Organization identifier
USER_ID NUMBER
Yes User identifier
STP_ID NUMBER
Yes Single Third Party identifier
TRX_ID NUMBER
Yes Transaction identifier for Payables or Receivables
TRX_NUMBER VARCHAR2 (20) Yes User-defined transaction number
AMOUNT NUMBER
Yes Amount
NETTING_AMOUNT NUMBER

Netting amount
PROCESS_FLAG VARCHAR2 (1) Yes Process flag, used for batch creation. Records selected for batch creation are set to S. Records awaiting batch creation records are set to A.
CURRENCY_CODE VARCHAR2 (15)
Currency code
Query Text

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


SELECT ORG_ID
,      USER_ID
,      STP_ID
,      TRX_ID
,      TRX_NUMBER
,      AMOUNT
,      NETTING_AMOUNT
,      PROCESS_FLAG
,      CURRENCY_CODE
FROM APPS.IGI_STP_AP_BAL;

Dependencies

[top of page]

APPS.IGI_STP_AP_BAL references the following:

SchemaAPPS
SynonymIGI_STP_CANDIDATES_ALL

APPS.IGI_STP_AP_BAL is not referenced by any database object