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

Object Details

Object Name:	POS_AP_CHECKS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POS_AP_CHECKS_V POS.POS_AP_CHECKS_V
Subobject Name:
Status:	VALID

View Type

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

POS_AP_CHECKS_V is the view used to select the payment info details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
AMOUNT	VARCHAR2	(4000)		Amount
CHECK_DATE	DATE		Yes	Check Date
CHECK_ID	NUMBER	(15)	Yes	Check Id
CHECK_NUMBER	NUMBER	(15)	Yes	Check Number
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency Code
BANK_ACCOUNT_NAME	VARCHAR2	(80)	Yes	Bank Account Name
VENDOR_NAME	VARCHAR2	(240)		Vendor Name
VENDOR_NUMBER	VARCHAR2	(30)		Vendor Number
VENDOR_SITE_CODE	VARCHAR2	(15)		Vendor Site Code
VENDOR_SITE_ID	NUMBER	(15)		Vendor Site Id
VENDOR_ID	NUMBER	(15)		Vendor Id
CLEARED	VARCHAR2	(1)		Cleared Flag
VOIDED	VARCHAR2	(1)		Voided Flag
STOPPED	VARCHAR2	(1)		Stopped Flag
CLEARED_DATE	DATE			Cleared Date
VOID_DATE	DATE			Void Date
STOPPED_AT	VARCHAR2	(18)		Stopped At
RELEASED_AT	VARCHAR2	(18)		Released At
FUTURE_PAY_DUE_DATE	DATE			Future Pay Due Date
ADDRESS	VARCHAR2	(211)		Address
ADDRESS_URL	VARCHAR2	(150)		Address Url
ADDRESS_STYLE	VARCHAR2	(30)		Address Style
ADDRESS_LINE1	VARCHAR2	(240)		Address Line1
ADDRESS_LINE2	VARCHAR2	(240)		Address Line2
ADDRESS_LINE3	VARCHAR2	(240)		Address Line3
ADDRESS_LINE4	VARCHAR2	(240)		Address Line4
CITY	VARCHAR2	(60)		City
COUNTY	VARCHAR2	(150)		County
STATE	VARCHAR2	(150)		State
PROVINCE	VARCHAR2	(150)		Province
ZIP	VARCHAR2	(60)		Zip Code
COUNTRY	VARCHAR2	(60)		Country
INVOICES	CHAR	(0)		Invoices
STATUS_LOOKUP_CODE	VARCHAR2	(25)		Status Lookup Code
STATUS_DISPLAYED	VARCHAR2	(80)	Yes	Status Displayed
ORG_ID	NUMBER	(15)		Org Id
ORG_NAME	VARCHAR2	(240)		Org Name
PO_NUMBER	CHAR	(0)		PO Number

Query Text

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


SELECT AMOUNT
,      CHECK_DATE
,      CHECK_ID
,      CHECK_NUMBER
,      CURRENCY_CODE
,      BANK_ACCOUNT_NAME
,      VENDOR_NAME
,      VENDOR_NUMBER
,      VENDOR_SITE_CODE
,      VENDOR_SITE_ID
,      VENDOR_ID
,      CLEARED
,      VOIDED
,      STOPPED
,      CLEARED_DATE
,      VOID_DATE
,      STOPPED_AT
,      RELEASED_AT
,      FUTURE_PAY_DUE_DATE
,      ADDRESS
,      ADDRESS_URL
,      ADDRESS_STYLE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      CITY
,      COUNTY
,      STATE
,      PROVINCE
,      ZIP
,      COUNTRY
,      INVOICES
,      STATUS_LOOKUP_CODE
,      STATUS_DISPLAYED
,      ORG_ID
,      ORG_NAME
,      PO_NUMBER
FROM APPS.POS_AP_CHECKS_V;

Dependencies

[top of page]

APPS.POS_AP_CHECKS_V references the following:

APPS: AP_CHECKS_ALL; AP_LOOKUP_CODES; FND_CURRENCY - show dependent code; FND_GLOBAL - show dependent code; HR_ALL_ORGANIZATION_UNITS_TL; PO_VENDORS

APPS.POS_AP_CHECKS_V is not referenced by any database object