APPS.GR_DISPATCH_HISTORY_PVT SQL Statements

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

Line: 137

SELECT 1
FROM   fnd_documents
WHERE  document_id = p_document_id;

Line: 143

SELECT fnd_document_id , version_label
FROM   edr_files_b
WHERE  original_file_name = p_document_name
AND    version_label = nvl(p_document_version, version_label)
order by version_label desc;

Line: 150

SELECT document_id
FROM   fnd_documents_vl
WHERE  file_name = p_document_name;

Line: 156

SELECT fnd_document_id
FROM   edr_files_b
WHERE  original_file_name = p_document_name;

Line: 162

SELECT category_id
FROM   fnd_document_categories
WHERE  name = p_document_category;

Line: 168

SELECT 1
FROM   fnd_languages
WHERE  language_code = p_language;

Line: 174

SELECT 1
FROM   fnd_user
WHERE  user_id = p_user_id;

Line: 180

SELECT  file_data
FROM    gr_upload_file_tmp
WHERE   request_id = -12345;

Line: 186

SELECT  gr_dispatch_history_s.nextval
FROM    DUAL;

Line: 466

         Delete from gr_upload_file_tmp where request_id = -12345;

Line: 511

		P_LAST_UPDATED_BY     =>         p_user_id,
		P_LAST_UPDATE_LOGIN   =>         NULL,
		P_LAST_UPDATE_DATE    =>         SYSDATE,
		X_RETURN_STATUS       =>         x_return_status,
		X_MSG_DATA            =>         x_msg_data);

Line: 614

          INSERT INTO GR_DISPATCH_HISTORY (
               dispatch_history_id	 ,
               document_id		 ,
               item                      ,
               organization_id	         ,
               inventory_item_id	 ,
               recipient_id              ,
               recipient_site_id         ,
               date_sent                 ,
               dispatch_method_code      ,
               creation_source	         ,
               attribute_category        ,
               attribute1                ,
               attribute2                ,
               attribute3                ,
               attribute4                ,
               attribute5                ,
               attribute6                ,
               attribute7                ,
               attribute8                ,
               attribute9                ,
               attribute10               ,
               attribute11               ,
               attribute12               ,
               attribute13               ,
               attribute14               ,
               attribute15               ,
               attribute16               ,
               attribute17               ,
               attribute18               ,
               attribute19               ,
               attribute20               ,
               attribute21               ,
               attribute22               ,
               attribute23               ,
               attribute24               ,
               attribute25               ,
               attribute26               ,
               attribute27               ,
               attribute28               ,
               attribute29               ,
               attribute30               ,
               created_by	         ,
               creation_date	         ,
               last_updated_by           ,
               last_update_date          ,
               last_update_login
             ) VALUES (
                l_dispatch_history_id	 ,
                l_document_id		 ,
                l_item                   ,
                p_organization_id	 ,
                l_inventory_item_id	 ,
                p_recipient_id           ,
                p_recipient_site_id      ,
                p_date_sent              ,
                p_dispatch_method_code   ,
                p_creation_source	 ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
                NULL       ,
		NULL       ,
		NULL       ,
		NULL       ,
		NULL       ,
		NULL       ,
		NULL       ,
		NULL       ,
		NULL       ,
		NULL       ,
		p_user_id  ,
		sysdate ,
		p_user_id,
		sysdate,
		-1);

Line: 873

  select NVL(CAS_Number,' ')
  into P_CAS_NO
  from mtl_system_items_kfv
  WHERE concatenated_segments = p_item
  AND   organization_id = p_organization_id ;

Line: 945

      select NVL(ORGANIZATION_CODE,' ') into p_orgn_code
        from MTL_PARAMETERS
        where ORGANIZATION_ID =  p_orgn_id;

Line: 982

      select NVL(DESCRIPTION,' ') into p_item_desc
        from MTL_SYSTEM_ITEMS
        where INVENTORY_ITEM_ID = p_item_id
        and   ORGANIZATION_ID = p_orgn_id;