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.

[Home] [Help]

View: OF_PO_VEND_ASC_VW

Product:	GML - Process Manufacturing Logistics
Description:	Vendor Association View
Implementation/DBA Data:	APPS.OF_PO_VEND_ASC_VW

View Text

SELECT V1.VENDOR_ID
, V2.VENDOR_ID
, 1
, V1.CREATION_DATE
, V1.LAST_UPDATE_DATE
, V1.LAST_UPDATE_LOGIN
, V1.CREATED_BY
, V1.LAST_UPDATED_BY
, 0
, NULL
, 0
, V1.PROGRAM_APPLICATION_ID
, V1.PROGRAM_ID
, V1.PROGRAM_UPDATE_DATE
, V1.REQUEST_ID
FROM PO_VEND_MST V1
, PO_VEND_MST V2
WHERE V1.VENDOR_ID != V2.VENDOR_ID
AND V1.PAYMENT_IND = 1
AND V2.SHIP_IND = 1
AND V1.DELETE_MARK = 0
AND V2.DELETE_MARK = 0
AND V1.CO_CODE = V2.CO_CODE
AND V1.OF_VENDOR_ID = V2.OF_VENDOR_ID

Columns

Name
VEND_ID
ASSOCVEND_ID
ASSOC_TYPE
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CREATED_BY
LAST_UPDATED_BY
DELETE_MARK
TEXT_CODE
TRANS_CNT
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID