APPS.GR_XML_REPORTS SQL Statements

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

Line: 29

            ' SELECT organization_code '
         || '     , SYSDATE report_date '
         || '     , CURSOR (SELECT grdh.* '
         || '		    , fdc.user_name document_category_user_name '
         || '		 FROM gr_dispatch_history_v grdh '
         || '		    , fnd_document_categories_vl fdc '
         || '		WHERE grdh.organization_id = mp.organization_id '
         || '		  AND grdh.document_category = fdc.NAME(+) ';

Line: 87

            || ' AND grdh.inventory_item_id IN (SELECT product_item_id FROM gr_ingredient_concentrations '
            || '                                 WHERE organization_id = ' || p_organization_id
            || '                                   AND ingredient_item_id = ' || p_ingredient_item_id
            || ' ) ';