View: PO_SUPPLIER_OPEN_POS_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.PO_SUPPLIER_OPEN_POS_V

View Text

SELECT DISTINCT POV.VENDOR_ID
, POV.VENDOR_NAME
, POV.SEGMENT1
, POV.NUM_1099
, POV.VAT_REGISTRATION_NUM
, POV.TYPE_1099
, FL.MEANING
, PH.ORG_ID
FROM PO_VENDORS POV
, PO_HEADERS PH
, FND_LOOKUPS FL
WHERE NVL(POV.HOLD_FLAG
, 'N') = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'YES_NO'
AND NVL(PH.CLOSED_CODE
, 'OPEN') = 'OPEN'
AND POV.VENDOR_ID = PH.VENDOR_ID
AND NVL(PH.CANCEL_FLAG
, 'N') = 'N'

Columns