eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PAY_US_PRE_PAYMENTS_V

Object Details

Object Name:	PAY_US_PRE_PAYMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAY_US_PRE_PAYMENTS_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 Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
PRE_PAYMENT_ID	NUMBER	(15)	System-generated primary key column.
PERSONAL_PAYMENT_METHOD_ID	NUMBER	(9)	Foreign key to PAY_PERSONAL_PAYMENT_METHODS.
ASSIGNMENT_ACTION_ID	NUMBER	(15)	Foreign key to PAY_ASSIGNMENT_ACTIONS.
ORG_PAYMENT_METHOD_ID	NUMBER	(9)	Foreign key to PAY_ORG_PAYMENT_METHODS.
VALUE	NUMBER		Value of payment in target currency.
BASE_CURRENCY_VALUE	NUMBER		Payment value in base currency.
SOURCE_ACTION_ID	NUMBER	(15)	Foreign Key to PAY_ASSIGNMENT_ACTIONS. Used, for example, to identify part payments for a particular run type.
PREPAYMENT_ACTION_ID	NUMBER	(15)	Parent prepayment action
SERIAL_NUMBER	VARCHAR2	(30)	Check or Magnetic Tape number.
ACTION_TYPE	VARCHAR2	(30)	Type of the payroll action.
CHECK_ASSIGNMENT_ACTION_ID	NUMBER		The system generated primary key.
PAYROLL_ACTION_ID	NUMBER		Foreign key to PAY_PAYROLL_ACTIONS.

Query Text

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


SELECT PRE_PAYMENT_ID
,      PERSONAL_PAYMENT_METHOD_ID
,      ASSIGNMENT_ACTION_ID
,      ORG_PAYMENT_METHOD_ID
,      VALUE
,      BASE_CURRENCY_VALUE
,      SOURCE_ACTION_ID
,      PREPAYMENT_ACTION_ID
,      SERIAL_NUMBER
,      ACTION_TYPE
,      CHECK_ASSIGNMENT_ACTION_ID
,      PAYROLL_ACTION_ID
FROM APPS.PAY_US_PRE_PAYMENTS_V;

Dependencies

[top of page]

APPS.PAY_US_PRE_PAYMENTS_V references the following:

APPS: PAY_ACTION_INTERLOCKS; PAY_ASSIGNMENT_ACTIONS; PAY_ORG_PAYMENT_METHODS_F; PAY_PAYROLL_ACTIONS; PAY_PRE_PAYMENTS

APPS.PAY_US_PRE_PAYMENTS_V is referenced by following:

PUBLIC: PAY_US_PRE_PAYMENTS_V