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


VIEW: APPS.PABV_TRANSACTION_SOURCES

Object Details
Object Name: PABV_TRANSACTION_SOURCES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PABV_TRANSACTION_SOURCES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows information about classifications of transactions originating in an external system and imported into Oracle Projects via the Transaction Import program.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_SOURCE VARCHAR2 (30) Yes
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (80) Yes
_LA:COSTED_FLAG CHAR (42)
_LA:PURGEABLE_FLAG CHAR (45)
_DF CHAR (35)
DESCRIPTION VARCHAR2 (240)

USER_TRANSACTION_SOURCE VARCHAR2 (80) Yes
START_EFFECTIVE_DATE DATE
Yes
END_EFFECTIVE_DATE DATE


LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
PRE_PROCESSING_EXTENSION VARCHAR2 (60)
POST_PROCESSING_EXTENSION VARCHAR2 (60)
Query Text

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


SELECT TRANSACTION_SOURCE
,      SYSTEM_LINKAGE_FUNCTION
,      _LA:COSTED_FLAG
,      _LA:PURGEABLE_FLAG
,      _DF
,      DESCRIPTION
,      USER_TRANSACTION_SOURCE
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      PRE_PROCESSING_EXTENSION
,      POST_PROCESSING_EXTENSION
FROM APPS.PABV_TRANSACTION_SOURCES;

Dependencies

[top of page]

APPS.PABV_TRANSACTION_SOURCES references the following:

SchemaAPPS
SynonymPA_SYSTEM_LINKAGES
SynonymPA_TRANSACTION_SOURCES

APPS.PABV_TRANSACTION_SOURCES is not referenced by any database object