APPS.RCV_GET_DELIVERED_QTY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16

                 SELECT rct.transaction_type      trans_type,
                        rct.transaction_id        trans_id,
                        rct.parent_transaction_id parent_trans_id,
                        rct.primary_quantity      trans_qty
                 FROM   rcv_shipment_lines rsl,
                        po_headers_all poh,
                        rcv_transactions rct
                 WHERE  rct.source_document_code = 'PO'
                 AND    rsl.item_id = x_item_id
                 AND    rsl.po_header_id = poh.po_header_id
                 AND    poh.vendor_id = x_vendor_id
                 AND    NVL(poh.vendor_site_id,-99) = NVL(x_vendor_site_id,-99)
                 AND    rct.shipment_line_id = rsl.shipment_line_id
                 AND    rct.transaction_type = 'DELIVER'
                 AND    rct.transaction_date between x_start_date and x_end_date;

Line: 35

                 SELECT rct.transaction_type      trans_type,
                        rct.transaction_id        trans_id,
		        rct.parent_transaction_id parent_trans_id,
                        rct.primary_quantity      trans_qty
	         FROM   rcv_shipment_lines rsl,
                        rcv_transactions rct
		 WHERE  rct.source_document_code = 'PO'
		 AND    rsl.item_id = x_item_id
   		 AND    rct.shipment_line_id = rsl.shipment_line_id
   		 AND    rct.transaction_type = 'DELIVER'
   		 AND    rct.transaction_date between x_start_date and x_end_date
		 AND    exists
      		        (SELECT 1 FROM po_headers_all poh
        		 WHERE  rsl.po_header_id = poh.po_header_id
          		 AND    NVL(poh.vendor_site_id,-99) = NVL(x_vendor_site_id,-99)
          		 AND    poh.vendor_id = x_vendor_id
          		 AND    rownum = 1);

Line: 56

                 SELECT rct.transaction_type      trans_type,
                        rct.transaction_id        trans_id,
                        rct.parent_transaction_id parent_trans_id,
                        rct.primary_quantity      trans_qty
                 FROM   rcv_transactions rct
                 WHERE  rct.parent_transaction_id = std_rec.trans_id;

Line: 116

                 SELECT rct.transaction_type      trans_type,
                        rct.transaction_id        trans_id,
                        rct.parent_transaction_id parent_trans_id,
                        rct.primary_quantity      trans_qty
                 FROM   rcv_shipment_lines rsl,
                        rcv_transactions rct
                 WHERE  rct.shipment_line_id = rsl.shipment_line_id
                 AND    rsl.item_id = x_item_id
                 AND    rsl.from_organization_id = x_from_org_id
                 AND    rsl.to_organization_id = x_to_org_id
                 AND    rct.transaction_type = 'DELIVER'
                 AND    rct.transaction_date between x_start_date and x_end_date;

Line: 132

                 SELECT rct.transaction_type      trans_type,
                        rct.transaction_id        trans_id,
                        rct.parent_transaction_id parent_trans_id,
                        rct.primary_quantity      trans_qty
                 FROM   rcv_transactions rct
                 WHERE  rct.parent_transaction_id = int_rec.trans_id;

Line: 187

          SELECT count(*)
          INTO   x_rec_not_del_qty
          FROM   rcv_shipment_lines rsl
                 , mtl_supply ms
          WHERE  rsl.SHIPMENT_LINE_ID     = ms.SHIPMENT_LINE_ID
          AND    rsl.SHIPMENT_HEADER_ID   = ms.SHIPMENT_HEADER_ID
          AND    rsl.FROM_ORGANIZATION_ID = x_from_org_id
          AND    rsl.TO_ORGANIZATION_ID   = x_to_org_id
          AND    ms.FROM_ORGANIZATION_ID  = x_from_org_id
          AND    ms.TO_ORGANIZATION_ID    = x_to_org_id
          AND    ms.SUPPLY_TYPE_CODE in ('RECEIVING', 'SHIPMENT');