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

TABLE: IGI.IGI_STP_CANDIDATES_ALL

Object Details
Object Name: IGI_STP_CANDIDATES_ALL
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.IGI_STP_CANDIDATES_ALL
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_CANDIDATES is a multi org view which displays netting transactions, either Payables or Receivables, available for netting.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER
Yes User identifier
STP_ID NUMBER
Yes Single Third Party identifier
SITE_ID NUMBER
Yes Single Third Party site identifer
BATCH_ID NUMBER
Yes Batch identifier
APPLICATION VARCHAR2 (2) Yes Application, either Payables or Receivables
TRX_ID NUMBER
Yes Transaction identifier for Payables or Receivables
TRX_NUMBER VARCHAR2 (20) Yes User-defined transaction number
AMOUNT NUMBER
Yes Amount
PROCESS_FLAG VARCHAR2 (1) Yes Process flag, used for batch creation. Records selected for batch creation the flag is set to S, records awaiting batch creation records are set to A.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ORG_ID NUMBER

Organization identifier
PACKAGE_ID NUMBER

Netting package identifier
NETTING_TRX_TYPE_ID NUMBER

Netting transaction type identifer
REFERENCE VARCHAR2 (20)
Reference column which inserts in the description column on AP_INVOICES
ACCOUNTING_DATE DATE

Accounting date
NETTING_AMOUNT NUMBER

Netting amount
DIAL_UNIT_ID NUMBER

Dialog unit identifier
PACKAGE_NUM NUMBER

This lists the package number in a batch
CURRENCY_CODE VARCHAR2 (15)
Currency code
CONTRA_PARTY_ID NUMBER

Single third party identifier used in Debt Beneficiary , Assignments Netting Transactions
CONTRA_SITE_ID VARCHAR2 (30)
Single third party site identifier used in Debt Beneficiary , Assignments Netting Transactions
CONTRA_AMOUNT NUMBER

Amount used in Debt Beneficiary , Assignments Netting Transactions
EXCHANGE_RATE NUMBER

Exchange rate used to convert foreign currency amounts into functional currency
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Conversion type used to convert foreign currency transactions
EXCHANGE_DATE DATE

Date for which rate is selected
TRX_TYPE VARCHAR2 (30)
Transaction type
Query Text

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


SELECT USER_ID
,      STP_ID
,      SITE_ID
,      BATCH_ID
,      APPLICATION
,      TRX_ID
,      TRX_NUMBER
,      AMOUNT
,      PROCESS_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      PACKAGE_ID
,      NETTING_TRX_TYPE_ID
,      REFERENCE
,      ACCOUNTING_DATE
,      NETTING_AMOUNT
,      DIAL_UNIT_ID
,      PACKAGE_NUM
,      CURRENCY_CODE
,      CONTRA_PARTY_ID
,      CONTRA_SITE_ID
,      CONTRA_AMOUNT
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      TRX_TYPE
FROM IGI.IGI_STP_CANDIDATES_ALL;

Dependencies

[top of page]

IGI.IGI_STP_CANDIDATES_ALL does not reference any database object

IGI.IGI_STP_CANDIDATES_ALL is referenced by following:

SchemaAPPS
SynonymIGI_STP_CANDIDATES
SynonymIGI_STP_CANDIDATES_ALL