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.CE_AP_FC_PAYMENTS_V

Object Details

Object Name:	CE_AP_FC_PAYMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CE_AP_FC_PAYMENTS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

The CE_AP_FC_PAYMENTS_V view contains AP payments for forecasting. The Cash Forecasting program uses this view to generate projected cash outflow amounts from the AP payments. Based on the forecast template definition and forecast submiss

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CHECK_ID	NUMBER	(15)	Yes	Check identifier
BASE_AMOUNT	NUMBER			Payment amount in the functional currency
AMOUNT	NUMBER			Payment amount
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code for the payment
PAYMENT_PRIORITY	NUMBER			Payment priority assigned for the payment
SUPPLIER_TYPE	VARCHAR2	(30)		Suppler type of the payment
PAYGROUP	VARCHAR2	(25)		Pay group assigned to the payment
CLEARED_DATE	DATE			Cleared date of the payment
MATURITY_DATE	DATE			Maturity date of the payment
PAYMENT_DATE	DATE		Yes	Payment date of the payment
ACTUAL_VALUE_DATE	DATE			Actual value date of the payment
ANTICIPATED_VALUE_DATE	DATE			Anticipated value date of the payment
STATUS	VARCHAR2	(25)		Status of the payment
BANK_ACCOUNT_ID	NUMBER	(15)	Yes	Bank account identifier
PAYMENT_METHOD	VARCHAR2	(30)		Payment method for the payment
ORG_ID	NUMBER	(15)		Organization identifier
CHECK_NUMBER	NUMBER	(15)	Yes	Check Number
REFERENCE_ID	NUMBER	(15)	Yes	Reference identifier

Query Text

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


SELECT CHECK_ID
,      BASE_AMOUNT
,      AMOUNT
,      CURRENCY_CODE
,      PAYMENT_PRIORITY
,      SUPPLIER_TYPE
,      PAYGROUP
,      CLEARED_DATE
,      MATURITY_DATE
,      PAYMENT_DATE
,      ACTUAL_VALUE_DATE
,      ANTICIPATED_VALUE_DATE
,      STATUS
,      BANK_ACCOUNT_ID
,      PAYMENT_METHOD
,      ORG_ID
,      CHECK_NUMBER
,      REFERENCE_ID
FROM APPS.CE_AP_FC_PAYMENTS_V;

Dependencies

[top of page]

APPS.CE_AP_FC_PAYMENTS_V references the following:

APPS: AP_CHECKS_ALL; CE_BANK_ACCOUNTS; CE_BANK_ACCT_USES_ALL; FND_GLOBAL - show dependent code; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.CE_AP_FC_PAYMENTS_V is referenced by following:

APPS: CE_CP_DISC_APP_V; CE_CP_DISC_OVERDUE_V; CE_CP_DISC_PRIOR_V; CE_CP_PRIORDAY - show dependent code; CE_CSH_FCST_POP - show dependent code; CE_FC_APP_DISC_V