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: ViewPO.POS_AP_CHECKS_V
ViewPOS.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:

SchemaAPPS
SynonymAP_CHECKS_ALL
ViewAP_LOOKUP_CODES
PL/SQL PackageFND_CURRENCY - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
ViewPO_VENDORS

APPS.POS_AP_CHECKS_V is not referenced by any database object