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

VIEW: IGI.IGI_AR_CASH_BASIS_DISTS_ALL#

Object Details
Object Name: IGI_AR_CASH_BASIS_DISTS_ALL#
Object Type: VIEW
Owner: IGI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CASH_BASIS_DISTRIBUTION_ID NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

RECEIVABLE_APPLICATION_ID NUMBER (15) Yes
SOURCE VARCHAR2 (3) Yes
SOURCE_ID NUMBER (15) Yes
TYPE VARCHAR2 (15) Yes
PAYMENT_SCHEDULE_ID NUMBER (15) Yes
GL_DATE DATE
Yes
CURRENCY_CODE VARCHAR2 (15) Yes
AMOUNT NUMBER
Yes
ACCTD_AMOUNT NUMBER
Yes
CODE_COMBINATION_ID NUMBER (15) Yes
POSTING_CONTROL_ID NUMBER (15) Yes
GL_POSTED_DATE DATE
Yes
RECEIVABLE_APPLICATION_ID_CASH NUMBER (15)
ORG_ID NUMBER (15)
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 IGI.IGI_AR_CASH_BASIS_DISTS_ALL#;

Dependencies

[top of page]

IGI.IGI_AR_CASH_BASIS_DISTS_ALL# references the following:

SchemaIGI
TableIGI_AR_CASH_BASIS_DISTS_ALL
IGI.IGI_AR_CASH_BASIS_DISTS_ALL# is referenced by following:

SchemaAPPS
SynonymIGI_AR_CASH_BASIS_DISTS_ALL