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


VIEW: APPS.PAY_JP_SOE_PREPAY_PAYMENTS_V

Object Details
Object Name: PAY_JP_SOE_PREPAY_PAYMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_JP_SOE_PREPAY_PAYMENTS_V
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
SOURCE_ASSIGNMENT_ACTION_ID NUMBER (15) Yes
PRE_PAYMENT_ID NUMBER (15) Yes
ASSIGNMENT_ACTION_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER

PAYROLL_ACTION_ID NUMBER

ACTION_TYPE VARCHAR2 (4000)
D_ACTION_TYPE VARCHAR2 (80)
ACTION_STATUS VARCHAR2 (4000)
MARKED_FOR_RETRY_FLAG VARCHAR2 (1)
CATEGORY VARCHAR2 (2) Yes
PAYMENT_TYPE_NAME VARCHAR2 (80) Yes
ORG_PAYMENT_METHOD_NAME VARCHAR2 (80) Yes
PRIORITY NUMBER (15)
VALUE NUMBER
Yes
FORMATTED_VALUE VARCHAR2 (40)
CURRENCY_CODE VARCHAR2 (15) Yes
EXTERNAL_ACCOUNT_ID NUMBER (9)
MESSAGES_EXIST_FLAG VARCHAR2 (1)
Query Text

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


SELECT SOURCE_ASSIGNMENT_ACTION_ID
,      PRE_PAYMENT_ID
,      ASSIGNMENT_ACTION_ID
,      OBJECT_VERSION_NUMBER
,      PAYROLL_ACTION_ID
,      ACTION_TYPE
,      D_ACTION_TYPE
,      ACTION_STATUS
,      MARKED_FOR_RETRY_FLAG
,      CATEGORY
,      PAYMENT_TYPE_NAME
,      ORG_PAYMENT_METHOD_NAME
,      PRIORITY
,      VALUE
,      FORMATTED_VALUE
,      CURRENCY_CODE
,      EXTERNAL_ACCOUNT_ID
,      MESSAGES_EXIST_FLAG
FROM APPS.PAY_JP_SOE_PREPAY_PAYMENTS_V;

Dependencies

[top of page]

APPS.PAY_JP_SOE_PREPAY_PAYMENTS_V references the following:

SchemaAPPS
PL/SQL PackageFND_CURRENCY - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymPAY_ASSIGNMENT_ACTIONS
PL/SQL PackagePAY_JP_SOE_PKG - show dependent code
SynonymPAY_ORG_PAYMENT_METHODS_F
SynonymPAY_ORG_PAYMENT_METHODS_F_TL
SynonymPAY_PAYMENT_TYPES
SynonymPAY_PAYMENT_TYPES_TL
SynonymPAY_PAYROLL_ACTIONS
SynonymPAY_PERSONAL_PAYMENT_METHODS_F
SynonymPAY_PRE_PAYMENTS
SchemaPUBLIC
SynonymDUAL

APPS.PAY_JP_SOE_PREPAY_PAYMENTS_V is not referenced by any database object