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

VIEW: APPS.WIPFV_PERIOD_CLOSE_VAR_TXNS

Object Details
Object Name: WIPFV_PERIOD_CLOSE_VAR_TXNS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWIP.WIPFV_PERIOD_CLOSE_VAR_TXNS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows the variance transactions that are generated when periods are closed.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes
_LA:TRANSACTION_TYPE CHAR (61)
TRANSACTION_DATE DATE
Yes
SOURCE VARCHAR2 (30)
TRANSACTION_REFERENCE VARCHAR2 (240)
ORGANIZATION_CODE VARCHAR2 (3)
ORGANIZATION_NAME VARCHAR2 (240) Yes
MFG_ORDER_NAME VARCHAR2 (240) Yes
LINE VARCHAR2 (10)
PERIOD_NAME VARCHAR2 (15) Yes
REASON VARCHAR2 (30)
_DF CHAR (27)
ORGANIZATION_ID NUMBER
Yes
MFG_ORDER_ID NUMBER
Yes
LINE_ID NUMBER

ACCT_PERIOD_ID NUMBER
Yes
REASON_ID NUMBER

SOURCE_LINE_ID NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
UPDATED_BY NUMBER
Yes
Query Text

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


SELECT TRANSACTION_ID
,      _LA:TRANSACTION_TYPE
,      TRANSACTION_DATE
,      SOURCE
,      TRANSACTION_REFERENCE
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      MFG_ORDER_NAME
,      LINE
,      PERIOD_NAME
,      REASON
,      _DF
,      ORGANIZATION_ID
,      MFG_ORDER_ID
,      LINE_ID
,      ACCT_PERIOD_ID
,      REASON_ID
,      SOURCE_LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      UPDATED_BY
FROM APPS.WIPFV_PERIOD_CLOSE_VAR_TXNS;

Dependencies

[top of page]

APPS.WIPFV_PERIOD_CLOSE_VAR_TXNS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_PARAMETERS
SynonymMTL_TRANSACTION_REASONS
SynonymORG_ACCT_PERIODS
SynonymWIP_ENTITIES
SynonymWIP_LINES
SynonymWIP_TRANSACTIONS

APPS.WIPFV_PERIOD_CLOSE_VAR_TXNS is not referenced by any database object