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

Object Details

Object Name:	AP_INTERFACE_REJECTIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLAP.AP_INTERFACE_REJECTIONS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
VENDOR_ID	NUMBER	(15)	Supplier identifier. Validated against PO_VENDORS.VENDOR_ID
VENDOR_NUM	VARCHAR2	(30)	Supplier number
VENDOR_NAME	VARCHAR2	(240)	Supplier name
VENDOR_SITE_ID	NUMBER	(15)	Supplier site identifier. Validated against PO_VENDOR_SITES_ALL.VENDOR_SITE_ID
VENDOR_SITE_CODE	VARCHAR2	(15)	Supplier site code
INVOICE_NUM	VARCHAR2	(50)	Invoice number
INVOICE_ID	NUMBER	(15)	Invoice identifier
LINE_NUMBER	VARCHAR2	(80)
DESCRIPTION	VARCHAR2	(2000)
DISPLAYED_FIELD	VARCHAR2	(2000)
PARENT_TABLE	VARCHAR2	(30)
PARENT_ID	NUMBER	(15)
REJECT_LOOKUP_CODE	VARCHAR2	(30)
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE

Query Text

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


SELECT VENDOR_ID
,      VENDOR_NUM
,      VENDOR_NAME
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      INVOICE_NUM
,      INVOICE_ID
,      LINE_NUMBER
,      DESCRIPTION
,      DISPLAYED_FIELD
,      PARENT_TABLE
,      PARENT_ID
,      REJECT_LOOKUP_CODE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.AP_INTERFACE_REJECTIONS_V;

Dependencies

[top of page]

APPS.AP_INTERFACE_REJECTIONS_V references the following:

APPS: AP_INTERFACE_REJECTIONS; AP_INVOICES_INTERFACE; AP_INVOICE_LINES_INTERFACE; AP_LOOKUP_CODES; FND_GLOBAL - show dependent code; FND_NEW_MESSAGES

APPS.AP_INTERFACE_REJECTIONS_V is not referenced by any database object