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


VIEW: APPS.PA_VRM_SOURCE_DOC_SUB_LINES

Object Details
Object Name: PA_VRM_SOURCE_DOC_SUB_LINES
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DOC_SUB_LINE_TYPE CHAR (13)
DOC_SUB_LINE_LEVEL CHAR (1)
DOC_SUB_LINE_ID_INT_1 NUMBER

DOC_SUB_LINE_ID_INT_2 NUMBER (15)
DOC_SUB_LINE_ID_CHAR_1 VARCHAR2 (16)
DOC_ID_INT_1 NUMBER (15)
LINE_NUMBER NUMBER (15)
ORG_ID NUMBER (15)
LEDGER_ID NUMBER (15)
SUB_LINE_CREATION_DATE DATE

SUB_LINE_LAST_UPDATE_DATE DATE

ACCOUNT_CLASS CHAR (3)
AMOUNT NUMBER

ACCTD_AMOUNT NUMBER (22)
ACCOUNTING_DATE DATE

SLA_POSTED_FLAG VARCHAR2 (1)
SLA_POSTED_DATE DATE

EVENT_ID NUMBER (15)
CODE_COMBINATION_ID NUMBER (15)
REQUEST_ID NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER

CREATION_DATE DATE

CREATED_BY VARCHAR2 (100)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT DOC_SUB_LINE_TYPE
,      DOC_SUB_LINE_LEVEL
,      DOC_SUB_LINE_ID_INT_1
,      DOC_SUB_LINE_ID_INT_2
,      DOC_SUB_LINE_ID_CHAR_1
,      DOC_ID_INT_1
,      LINE_NUMBER
,      ORG_ID
,      LEDGER_ID
,      SUB_LINE_CREATION_DATE
,      SUB_LINE_LAST_UPDATE_DATE
,      ACCOUNT_CLASS
,      AMOUNT
,      ACCTD_AMOUNT
,      ACCOUNTING_DATE
,      SLA_POSTED_FLAG
,      SLA_POSTED_DATE
,      EVENT_ID
,      CODE_COMBINATION_ID
,      REQUEST_ID
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.PA_VRM_SOURCE_DOC_SUB_LINES;

Dependencies

[top of page]

APPS.PA_VRM_SOURCE_DOC_SUB_LINES references the following:

SchemaAPPS
SynonymFND_USER
SynonymHR_ORGANIZATION_INFORMATION
SynonymPA_CUST_EVENT_RDL_ALL
SynonymPA_CUST_REV_DIST_LINES_ALL
SynonymPA_DRAFT_REVENUES_ALL
SynonymPA_EVENTS
SynonymPA_IMPLEMENTATIONS_ALL
SynonymXLA_AE_LINES
SynonymXLA_DISTRIBUTION_LINKS
SynonymXLA_EVENTS
ViewXLE_FIRSTPARTY_INFORMATION_V

APPS.PA_VRM_SOURCE_DOC_SUB_LINES is not referenced by any database object