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

VIEW: APPS.IGI_AR_CASH_BASIS_DISTS

Object Details
Object Name: IGI_AR_CASH_BASIS_DISTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGI.IGI_AR_CASH_BASIS_DISTS
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_AR_CASH_BASIS_DISTS stores Combined Basis Accounting Cash Basis distributions. It is based on IGI_AR_CASH_BASIS_DISTS_ALL table.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CASH_BASIS_DISTRIBUTION_ID NUMBER (15) Yes Identifier of the distribution item
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_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
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).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
RECEIVABLE_APPLICATION_ID NUMBER (15) Yes Identifier of the record used to determine the application of payments or credit memos associated with this distribution item
SOURCE VARCHAR2 (3) Yes Indicates whether this is a distribution of an ar_adjustments record or ra_cust_trx_line_gl_dist record
SOURCE_ID NUMBER (15) Yes Identifier of ar_adjustments record, or ra_cust_trx_line_gl_dist
TYPE VARCHAR2 (15) Yes Indicates whether this is a distribution of Lines, Tax, Freight, Charges, or Invoice
PAYMENT_SCHEDULE_ID NUMBER (15) Yes Payment Schedule to which application was made
GL_DATE DATE
Yes General Ledger date
CURRENCY_CODE VARCHAR2 (15) Yes Currency of distribution
AMOUNT NUMBER
Yes Amount posted
ACCTD_AMOUNT NUMBER
Yes Functional Currency equivalent of amount
CODE_COMBINATION_ID NUMBER (15) Yes General Ledger Code Combination (account
POSTING_CONTROL_ID NUMBER (15) Yes ID of general ledger posting process
GL_POSTED_DATE DATE
Yes Accounting date the distribution amount was posted
RECEIVABLE_APPLICATION_ID_CASH NUMBER (15)
Application that triggered the posting of a Credit Memo Application
ORG_ID NUMBER (15)
Organization identifier
Query Text

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


SELECT CASH_BASIS_DISTRIBUTION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RECEIVABLE_APPLICATION_ID
,      SOURCE
,      SOURCE_ID
,      TYPE
,      PAYMENT_SCHEDULE_ID
,      GL_DATE
,      CURRENCY_CODE
,      AMOUNT
,      ACCTD_AMOUNT
,      CODE_COMBINATION_ID
,      POSTING_CONTROL_ID
,      GL_POSTED_DATE
,      RECEIVABLE_APPLICATION_ID_CASH
,      ORG_ID
FROM APPS.IGI_AR_CASH_BASIS_DISTS;

Dependencies

[top of page]

APPS.IGI_AR_CASH_BASIS_DISTS references the following:

SchemaAPPS
SynonymIGI_AR_CASH_BASIS_DISTS_ALL
APPS.IGI_AR_CASH_BASIS_DISTS is referenced by following:

SchemaAPPS
Package BodyIGIRCBAP - show dependent code
Package BodyIGIRCBJP - show dependent code