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

VIEW: APPS.PAY_PAYMENT_COSTS_V

Object Details
Object Name: PAY_PAYMENT_COSTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_PAYMENT_COSTS_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
PAYMENT_METHOD_NAME VARCHAR2 (80) Yes Name given to the payment method.
ACCOUNTING_DATE DATE
Yes Payment Date or Cleared Date or Voided Date
COST_TYPE VARCHAR2 (4000)
Account type
DEBIT_OR_CREDIT VARCHAR2 (4000)
Debit or credit
COSTED_VALUE VARCHAR2 (4000)
Costed value
SOURCE_TYPE VARCHAR2 (30) Yes Source type
SOURCE_ACTION_ID NUMBER (15) Yes Source action id
GL_ACCOUNT_CCID NUMBER (9) Yes GL account id
FLEX_NUM NUMBER (15) Yes Chart of accounts id
ASSIGNMENT_ID NUMBER (10)
ASSIGNMENT_ACTION_ID NUMBER (15) Yes
PRE_PAYMENT_ID NUMBER (15)
PAYMENT_COST_ID NUMBER (15) Yes
Query Text

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


SELECT PAYMENT_METHOD_NAME
,      ACCOUNTING_DATE
,      COST_TYPE
,      DEBIT_OR_CREDIT
,      COSTED_VALUE
,      SOURCE_TYPE
,      SOURCE_ACTION_ID
,      GL_ACCOUNT_CCID
,      FLEX_NUM
,      ASSIGNMENT_ID
,      ASSIGNMENT_ACTION_ID
,      PRE_PAYMENT_ID
,      PAYMENT_COST_ID
FROM APPS.PAY_PAYMENT_COSTS_V;

Dependencies

[top of page]

APPS.PAY_PAYMENT_COSTS_V references the following:

SchemaAPPS
SynonymGL_CODE_COMBINATIONS
PL/SQL PackageHR_CHKFMT - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymPAY_ASSIGNMENT_ACTIONS
SynonymPAY_ORG_PAYMENT_METHODS_F
SynonymPAY_PAYMENT_COSTS
SynonymPAY_PAYROLL_ACTIONS
SynonymPAY_PRE_PAYMENTS
APPS.PAY_PAYMENT_COSTS_V is referenced by following:

SchemaAPPS
Package BodyPAY_SLA_UPDATE_PKG - show dependent code