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')
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')
|
|
|