Receipt_Count_R12

Select * from xx_receipt_no
Select * from rcv_shipment_headers where receipt_num='425003788'
SELECT   shipment_header_id,receipt_num
                  FROM   rcv_shipment_headers
                 WHERE   receipt_num IN
                               (SELECT   receipt_no FROM xx_receipt_no)

Select * from jai_rcv_line_taxes
SELECT   receipt_num
                  FROM   rcv_shipment_headers
                 WHERE   shipment_header_id IN
                               (SELECT   shipment_header_id
                                  FROM   jai_rcv_line_taxes)
                                  order by (receipt_num)
/* Formatted on 26-08-2011 11:44:14 (QP5 v5.115.810.9015) */
SELECT   *
  FROM   jai_rcv_line_taxes
 WHERE   shipment_header_id IN
               (SELECT   shipment_header_id
                  FROM   rcv_shipment_headers
                 WHERE   receipt_num not  IN
                               (SELECT   receipt_no FROM xx_receipt_no))
                              
                              
SELECT   receipt_no
  FROM   xx_receipt_no
 WHERE   RECEIPT_NO  IN
               (SELECT   receipt_num
                  FROM   rcv_shipment_headers
                 WHERE   shipment_header_id IN
                               (SELECT   shipment_header_id
                                  FROM   jai_rcv_line_taxes))