Skip to content

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

VIEW: APPS.APFV_AP_PAYMENTS

Object Details
Object Name: APFV_AP_PAYMENTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.APFV_AP_PAYMENTS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Shows payments, which are disbursements issued to a supplier.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CHECK_ID NUMBER (15) Yes
BANK_ACCOUNT_NAME VARCHAR2 (80) Yes
AMOUNT NUMBER
Yes
CURRENCY_CODE VARCHAR2 (15) Yes
CHECK_DATE DATE
Yes
CHECK_NUMBER NUMBER (15) Yes
CHECK_VOUCHER_NUMBER NUMBER (16)
CHECKRUN_NAME VARCHAR2 (255)
PAYMENT_TYPE VARCHAR2 (25) Yes
_LA:PAYMENT_TYPE_DESCR CHAR (69)
PAYMENT_STATUS VARCHAR2 (25)
_LA:PAYMENT_STATUS_DESCR CHAR (69)
PAYMENT_METHOD VARCHAR2 (25)
_LA:PAYMENT_METHOD_DESCR CHAR (80)
CHECK_SEQUENCE_NUMBER NUMBER

CLEARED_AMOUNT NUMBER

CLEARED_DATE DATE

VENDOR_ID NUMBER (15)
VENDOR_SITE_ID NUMBER (15)
VENDOR_NAME VARCHAR2 (240)
ADDRESS_LINE_1 VARCHAR2 (240)
ADDRESS_LINE_2 VARCHAR2 (240)
ADDRESS_LINE_3 VARCHAR2 (240)
VENDOR_CITY VARCHAR2 (25)
VENDOR_STATE VARCHAR2 (150)
VENDOR_POSTAL_CODE VARCHAR2 (20)
VENDOR_COUNTRY VARCHAR2 (25)
VENDOR_SITE_CODE VARCHAR2 (15)
VENDOR_BANK_ACCOUNT_NUMBER VARCHAR2 (30)
VENDOR_BANK_ACCOUNT_TYPE VARCHAR2 (25)
TREASURY_PAYMENT_DATE DATE

TREASURY_PAYMENT_NUMBER NUMBER (15)
STOP_PAYMENT_RELEASED_DATE VARCHAR2 (18)
STOP_PAYMENT_RELEASED_USER_ID NUMBER (15)
STOP_PAYMENT_RECORDED_DATE VARCHAR2 (18)
STOP_PAYMENT_RECORDED_USER_ID NUMBER (15)
VOID_DATE DATE

FUTURE_PAY_DUE_DATE DATE

_DF: CHAR (22)
_DF:GLBL CHAR (22)
CLEARED_FUNCTIONAL_AMOUNT NUMBER

CLEARED_CURRENCY_EXCH_RATE NUMBER

CLEARED_CURRENCY_EXCH_DATE DATE

CLEARED_CRNCY_EXCH_RATE_TYPE VARCHAR2 (30)
CURRENCY_EXCHANGE_RATE NUMBER

CURRENCY_EXCHANGE_DATE DATE

CURRENCY_EXCHANGE_RATE_TYPE VARCHAR2 (30)
FUNCTIONAL_AMOUNT NUMBER

CLEARED_ERROR_AMOUNT NUMBER

CLEARED_CHARGES_AMOUNT NUMBER

CLEARED_ERROR_FUNCTIONAL_AMT NUMBER

CLEARED_CHARGES_FUNCTIONAL_AMT NUMBER

TRANSFER_PRIORITY VARCHAR2 (25)
STAMP_DUTY_AMOUNT NUMBER

STAMP_DUTY_FUNCTIONAL_AMOUNT NUMBER

BANK_ACCOUNT_ID NUMBER (15)
EXTERNAL_BANK_ACCOUNT_ID NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
Query Text

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


SELECT CHECK_ID
,      BANK_ACCOUNT_NAME
,      AMOUNT
,      CURRENCY_CODE
,      CHECK_DATE
,      CHECK_NUMBER
,      CHECK_VOUCHER_NUMBER
,      CHECKRUN_NAME
,      PAYMENT_TYPE
,      _LA:PAYMENT_TYPE_DESCR
,      PAYMENT_STATUS
,      _LA:PAYMENT_STATUS_DESCR
,      PAYMENT_METHOD
,      _LA:PAYMENT_METHOD_DESCR
,      CHECK_SEQUENCE_NUMBER
,      CLEARED_AMOUNT
,      CLEARED_DATE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_NAME
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      VENDOR_CITY
,      VENDOR_STATE
,      VENDOR_POSTAL_CODE
,      VENDOR_COUNTRY
,      VENDOR_SITE_CODE
,      VENDOR_BANK_ACCOUNT_NUMBER
,      VENDOR_BANK_ACCOUNT_TYPE
,      TREASURY_PAYMENT_DATE
,      TREASURY_PAYMENT_NUMBER
,      STOP_PAYMENT_RELEASED_DATE
,      STOP_PAYMENT_RELEASED_USER_ID
,      STOP_PAYMENT_RECORDED_DATE
,      STOP_PAYMENT_RECORDED_USER_ID
,      VOID_DATE
,      FUTURE_PAY_DUE_DATE
,      _DF:
,      _DF:GLBL
,      CLEARED_FUNCTIONAL_AMOUNT
,      CLEARED_CURRENCY_EXCH_RATE
,      CLEARED_CURRENCY_EXCH_DATE
,      CLEARED_CRNCY_EXCH_RATE_TYPE
,      CURRENCY_EXCHANGE_RATE
,      CURRENCY_EXCHANGE_DATE
,      CURRENCY_EXCHANGE_RATE_TYPE
,      FUNCTIONAL_AMOUNT
,      CLEARED_ERROR_AMOUNT
,      CLEARED_CHARGES_AMOUNT
,      CLEARED_ERROR_FUNCTIONAL_AMT
,      CLEARED_CHARGES_FUNCTIONAL_AMT
,      TRANSFER_PRIORITY
,      STAMP_DUTY_AMOUNT
,      STAMP_DUTY_FUNCTIONAL_AMOUNT
,      BANK_ACCOUNT_ID
,      EXTERNAL_BANK_ACCOUNT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.APFV_AP_PAYMENTS;

Dependencies

[top of page]

APPS.APFV_AP_PAYMENTS references the following:

SchemaAPPS
SynonymAP_CHECKS

APPS.APFV_AP_PAYMENTS is not referenced by any database object