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

VIEW: APPS.FV_PAYMENT_MASTER_V

Object Details
Object Name: FV_PAYMENT_MASTER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFV.FV_PAYMENT_MASTER_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
ORG_ID NUMBER (15)
Organization identifier
CHECK_ID NUMBER (15) Yes Payment identifier
VENDOR_ID NUMBER (15)
Supplier identifier
VENDOR_SITE_ID NUMBER (15)
Supplier site identifier
TREASURY_PAY_NUMBER NUMBER (15)
Number assigned to payment processed through internal clearing organization
ACCOMPLISHED_DATE DATE

AMOUNT NUMBER
Yes Payment amount
CHECKRUN_NAME VARCHAR2 (255)
Payment batch name
CHECK_NUMBER NUMBER (15) Yes Payment number
CHECK_DATE DATE
Yes Payment date
VOID_STATUS VARCHAR2 (25)
Void Status
VOID_DATE DATE

Payment void date
Query Text

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


SELECT ORG_ID
,      CHECK_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      TREASURY_PAY_NUMBER
,      ACCOMPLISHED_DATE
,      AMOUNT
,      CHECKRUN_NAME
,      CHECK_NUMBER
,      CHECK_DATE
,      VOID_STATUS
,      VOID_DATE
FROM APPS.FV_PAYMENT_MASTER_V;

Dependencies

[top of page]

APPS.FV_PAYMENT_MASTER_V references the following:

SchemaAPPS
SynonymAP_CHECKS

APPS.FV_PAYMENT_MASTER_V is not referenced by any database object