View: AHL_HZ_PO_SUPPLIERS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This stores supplier information.
Implementation/DBA Data:	APPS.AHL_HZ_PO_SUPPLIERS_V

View Text

SELECT PARTY_ID
, PARTY_NUMBER
, PARTY_NAME
FROM HZ_PARTIES
WHERE AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO') IN ('N'
, 'L') UNION SELECT VENDOR_ID
, SEGMENT1
, VENDOR_NAME
FROM PO_VENDORS
WHERE AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO') IN ('I'
, 'S')

Columns