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


VIEW: APPS.WIPFV_JOB_CLOSE_VARIANCE_TXNS

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

View Type

A Business Intelligence System view


This shows the variance transactions associated with a period close.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes
TRANSACTION_TYPE VARCHAR2 (80) Yes
TRANSACTION_DATE DATE
Yes
SOURCE VARCHAR2 (30)
DESCRIPTION VARCHAR2 (240)
ORGANIZATION_CODE VARCHAR2 (3)
ORGANIZATION_NAME VARCHAR2 (240) Yes
MFG_ORDER_NAME VARCHAR2 (240) Yes
PERIOD_NAME VARCHAR2 (15) Yes
_DF CHAR (27)
ORGANIZATION_ID NUMBER
Yes
MFG_ORDER_ID NUMBER
Yes
ACCT_PERIOD_ID NUMBER
Yes
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
,      TRANSACTION_TYPE
,      TRANSACTION_DATE
,      SOURCE
,      DESCRIPTION
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      MFG_ORDER_NAME
,      PERIOD_NAME
,      _DF
,      ORGANIZATION_ID
,      MFG_ORDER_ID
,      ACCT_PERIOD_ID
,      SOURCE_LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      UPDATED_BY
FROM APPS.WIPFV_JOB_CLOSE_VARIANCE_TXNS;

Dependencies

[top of page]

APPS.WIPFV_JOB_CLOSE_VARIANCE_TXNS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
ViewMFG_LOOKUPS
SynonymMTL_PARAMETERS
SynonymMTL_TRANSACTION_REASONS
SynonymORG_ACCT_PERIODS
SynonymWIP_ENTITIES
SynonymWIP_TRANSACTIONS

APPS.WIPFV_JOB_CLOSE_VARIANCE_TXNS is not referenced by any database object