APPS.PO_POXRVODS_XMLP_PKG SQL Statements

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

Line: 19

		select organization_name
		into l_org_displayed
		from org_organization_definitions
		where organization_id = P_org_id ;

Line: 93

        select structure_id
        into l_p_struct_num
        from mtl_default_sets_view
        where functional_area_id = 2 ;

Line: 222

   t_stmt := 'SELECT SUBSTR( '||P_FLEX_ITEM||' ,1,900)
   INTO   :C_FLEX_ITEM
   FROM   mtl_system_items msi
   WHERE  inventory_item_id = :item_id
   AND    organization_id = :organization_id';