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

VIEW: APPS.PAY_PRE_PAYMENTS_V2

Object Details
Object Name: PAY_PRE_PAYMENTS_V2
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_PRE_PAYMENTS_V2
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ACTION_ID NUMBER (15) Yes
PRE_PAYMENT_ID NUMBER (15) Yes
CURRENCY_CODE VARCHAR2 (15) Yes
SERIAL_NUMBER VARCHAR2 (30)

VALUE NUMBER
Yes
BUSINESS_GROUP_ID NUMBER


OPM_EFFECTIVE_START_DATE DATE
Yes
OPM_EFFECTIVE_END_DATE DATE
Yes
Query Text

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


SELECT ASSIGNMENT_ACTION_ID
,      PRE_PAYMENT_ID
,      CURRENCY_CODE
,      SERIAL_NUMBER
,      VALUE
,      BUSINESS_GROUP_ID
,      OPM_EFFECTIVE_START_DATE
,      OPM_EFFECTIVE_END_DATE
FROM APPS.PAY_PRE_PAYMENTS_V2;

Dependencies

[top of page]

APPS.PAY_PRE_PAYMENTS_V2 references the following:

SchemaAPPS
SynonymPAY_ASSIGNMENT_ACTIONS
SynonymPAY_ORG_PAYMENT_METHODS_F
SynonymPAY_PRE_PAYMENTS
APPS.PAY_PRE_PAYMENTS_V2 is referenced by following:

SchemaAPPS
Package BodyPAY_AE_CHEQUE_REPORT - show dependent code
Package BodyPAY_KW_CHEQUE_REPORT - show dependent code
Package BodyPAY_SA_CHEQUE_REPORT - show dependent code