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

VIEW: APPS.FV_PYA_GL_V

Object Details
Object Name: FV_PYA_GL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFV.FV_PYA_GL_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

[View Source]

Columns
Name Datatype Length Mandatory Comments
WIP_BASIS VARCHAR2 (80)
TRX_REASON_NAME VARCHAR2 (25) Yes
BOM_DEPARTMENT_NAME VARCHAR2 (240)
RCV_SHIPMENT_HEADER_ID NUMBER (15) Yes
ACCOUNTING_COMPLETE VARCHAR2 (30)
WIP_FLOW_SCHEDULE_NUMBER VARCHAR2 (80) Yes
PA_PERIOD_DATE DATE

ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

ENTERED_DR NUMBER

ENTERED_CR NUMBER

WIP_JOB_NAME VARCHAR2 (100) Yes
AR_ADJUSTMENT_TYPE VARCHAR2 (80)
UNIT_PRICE NUMBER (15) Yes
PRICE_OVERRIDE NUMBER (15) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
JE_HEADER_ID NUMBER (15) Yes
JE_LINE_NUM NUMBER (15) Yes
CODE_COMBINATION_ID NUMBER (15) Yes
CURRENCY_CODE VARCHAR2 (15) Yes
APPLICATION_ID NUMBER

Query Text

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


SELECT WIP_BASIS
,      TRX_REASON_NAME
,      BOM_DEPARTMENT_NAME
,      RCV_SHIPMENT_HEADER_ID
,      ACCOUNTING_COMPLETE
,      WIP_FLOW_SCHEDULE_NUMBER
,      PA_PERIOD_DATE
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      ENTERED_DR
,      ENTERED_CR
,      WIP_JOB_NAME
,      AR_ADJUSTMENT_TYPE
,      UNIT_PRICE
,      PRICE_OVERRIDE
,      SET_OF_BOOKS_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      CODE_COMBINATION_ID
,      CURRENCY_CODE
,      APPLICATION_ID
FROM APPS.FV_PYA_GL_V;

Dependencies

[top of page]

APPS.FV_PYA_GL_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFV_FUND_PARAMETERS
ViewFV_LOOKUP_CODES
SynonymFV_PYA_TRANSACTION_HISTORY
SynonymFV_TREASURY_SYMBOLS
SynonymGL_JE_BATCHES
SynonymGL_JE_HEADERS
SynonymGL_JE_LINES
APPS.FV_PYA_GL_V is referenced by following:

SchemaAPPS
ViewXLA_FV_PYA_GL_V