View: GMF_XLA_VENDOR_V

Product:	GMF - Process Manufacturing Financials
Description:
Implementation/DBA Data:	APPS.GMF_XLA_VENDOR_V

View Text

SELECT VS.VENDOR_SITE_ID AS VENDOR_ID
, VS.ATTRIBUTE1 AS VENDGL_CLASS
, MMT.TRANSACTION_ID AS MMT_TRANSACTION_ID
FROM PO_VENDOR_SITES_ALL VS
, RCV_TRANSACTIONS RT
, PO_HEADERS_ALL POH
, MTL_MATERIAL_TRANSACTIONS MMT
WHERE VS.VENDOR_SITE_ID = NVL(RT.VENDOR_SITE_ID
, POH.VENDOR_SITE_ID)
AND POH.PO_HEADER_ID = MMT.TRANSACTION_SOURCE_ID
AND RT.TRANSACTION_ID(+) = MMT.RCV_TRANSACTION_ID
AND MMT.TRANSACTION_SOURCE_TYPE_ID = 1

Columns