GML OPM Apps Receipt Number

SELECT
                   HDR.PAYVEND_ID,
                                    HDR.ORGN_CODE      PO_ORGN,
                                    HDR.PO_DATE,
                   RHDR.ORGN_CODE   RC_ORGN,
                   HDR.PO_NO, DTL.LINE_NO,
                   RHDR.RECV_ID,
                                    RHDR.RECV_NO,
                   MAP.RCV_RECEIPT_NUM,
                   HDR.CREATION_DATE,
                   RHDR.CREATION_DATE,
                               RHDR.RECV_DATE,
                               VEND.VENDOR_NO,VEND.VENDOR_NAME
            FROM
                 PO_ORDR_HDR HDR,
                 PO_ORDR_DTL DTL,
                 PO_RECV_HDR RHDR,
                 PO_RECV_DTL RDTL,
                 GML_RECV_TRANS_MAP MAP,
                              PO_VEND_MST VEND
            WHERE
                   RDTL.PO_ID=HDR.PO_ID
                   AND HDR.PO_ID=DTL.PO_ID
                   AND HDR.PAYVEND_ID = RHDR.PAYVEND_ID
                               AND VEND.VENDOR_ID=HDR.PAYVEND_ID
                               AND VEND.VENDOR_ID= RHDR.PAYVEND_ID
                   AND MAP.RECV_ID=RHDR.RECV_ID
                   AND RDTL.LINE_ID=MAP.LINE_ID
                   AND RDTL.RECV_ID=RHDR.RECV_ID
                   AND RDTL.POLINE_ID=DTL.LINE_ID
                                        &PARAM_WHERE_CLAUSE
            ORDER BY
                 RHDR.RECV_NO, RDTL.LINE_NO