View: ICX_RELATED_TEMPLATES_VAL_V

Product:	ICX - Oracle iProcurement
Description:	Web Requisitions Related Templates Value View
Implementation/DBA Data:	APPS.ICX_RELATED_TEMPLATES_VAL_V

View Text

SELECT PRT.EXPRESS_NAME
, PRT.RELATED_EXPRESS_NAME
, PRT.RELATIONSHIP_TYPE
, PRXT.RESERVE_PO_NUMBER
FROM PO_REQEXPRESS_HEADERS PRXT
, PO_RELATED_TEMPLATES PRT
WHERE PRT.RELATED_EXPRESS_NAME = PRXT.EXPRESS_NAME
AND NVL(INACTIVE_DATE
, SYSDATE+1) > SYSDATE

Columns