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